Jump to content
Larry Ullman's Book Forums

Recommended Posts

Hello...

 

I am some confuse with this matter. I want to print a order list with a title in php. those come from my database. Title is my category name and order list should be my subjects. I used 'institute_category_subject' table and i contain all institutes, categories and their subjects. something like this...

 

 

I now need to create my list with these values. It is something like this..

 

+--------+--------------+-------------+------------+
| ics_id | institute_id | category_id | subject_id |
+--------+--------------+-------------+------------+
|	  1 |			1 |		   1 |		  2 |
|	  2 |			1 |		   1 |		  4 |
|	  3 |			1 |		   2 |		  2 |
|	  4 |			1 |		   2 |		  3 |
|	  5 |			1 |		   3 |		  1 |
|	  6 |			1 |		   3 |		  4 |
+--------+--------------+-------------+------------+

 

category_name1

  • sub1
  • sub2
  • sub3

category_name2

  • sub1
  • sub2
  • sub3 and so on....

My problem is category id with same value going on many rows in the table and when i retrieve that id and when try to print, same category name printing repeatedly. I need to print my category name at only one time as my title and then need to print their subjects as a order list.

 

any comments are highly appreciated.

 

thank you..

Link to comment
Share on other sites

If I understand you correctly, what you need is a flag variable. Set this to false initially (outside of the fetching loop). Then, when a new row is fetched, see if the category name is the same as the flag variable. If not, then print the category name and assign its value to the flag variable. This way you'll only print the category name once per category.

Link to comment
Share on other sites

 Share

×
×
  • Create New...