MySQL: SELECT DISTINCT skipping the first row?

Question

Hi,

I'm working with PHP and MySQL again and I've hit a snag. I'm using SHOW TABLES in combination with SELECT DISTINCT to create a dynamic menu.
The problem is that the SELECT DISTINCT code seems to ignore the "subtype" value of the first row. For example, if the subtype value for the first record is wood, it won't show up in the menu, and none of the other records that match "wood" don't cause it to show up in the menu either.

Any help would be appreciated...I'll post the code in as additional info.

Answer 1

You call a fetch_row and store the result in $numrows2, but calling num_rows is what you meant to do. So your first row is skipped in the subsequent loop. I bet if you comment out line 13 and run it again you'll see what I mean, and your output will appear complete.



Yeah that "while" loop's just gonna continue where the cursor's at. Don't throw in your hat! It's all gonna show how you ask it to be! While we're at it, don't forget to thwart HTML injection attacks by calling htmlentities where applicable!



I've sung this for you at: http://noise.dillfrog.com/audio/fawm2009/selectdistinct.mp3

Answer 2

It would probably be much better to just define the menu in a separate PHP file and include it where you need it. Or, if you want it to be dynamic, list the menu options in an array in a separate PHP file and include it where you need it. I don't mean to be rude, but using a database for this makes no sense.

Answer 3

If you want to make a dynamic menu from a database, create a table that makes sense for creating a menu from. Then you do a single SELECT-WHERE and your dataset is the menu items.

Answer 4

What do you mean by "last five rows"?