Msg#: 4293509 posted 2:32 am on Apr 7, 2011 (gmt 0)
I am trying to get the results from a MySQL DB and display them in a few HTML select tags.
The first while loop runs fine, the second runs fine if I use mysql_data_seek($result, 0); but I cannot do the same trick for a third while loop and I need to have 10 of these, what is the trick for this scenario?
Msg#: 4293509 posted 1:59 pm on May 24, 2011 (gmt 0)
Why use data seek? If you need to "rewind" the pointer ... well, I guess I never approach it that way. I build the select elements within the same while loop construct. Iterate once over the result set, building the select containers at the same time into a variable. Echo them out afterward.