Hi Miko:
mikosiko wrote:in your code you were doing an initial call to mysql_fetch_record, therefore your while loop will not start in the first record but in the second.
I actually removed that first call as soon as it was explained it wasn't necessary until later in the code.
mikosiko wrote:What I do suggest you is to take a look to the code that Dave gave to you several posts ago using an array (as I did suggest in my first post)... that is the simples way to solve (no the only one)... your solution is there... anything else is going in circles... why you don't take that code.. implement it and ask anything that you do not understand there?
Sorry I was not clear on my progress in my earlier post(s). Thanks to you and Dave I actually have had this running correctly [the solution using array() ] since Sunday evening. WooHoo!!
My last questions about reordering statements were because I wanted to figure out why the while construct using $count and $row were not working.
You'll note in my post to Dave above I figured that out TOO. But I'm using array() as you originally suggested -- it's definitely more powerful.
mikosiko wrote:will be easy...

It actually was, once I started thinking "scripting" and just put a lot of time on task!
There's still ONE concept that bothers me though:
I thought a construct like
Code: Select all
$ExhibitsQuery_result = mysql_query($ExhibitsQuery)
was what "fetched" the data and that that fetch_assoc put it ALL into an array.
It appears (to ME) that these statements are one step removed from their respective results:
- mysql_query seems to PREP the query but not actually run it
- fetch_assoc seems to run the query . . . but only a line at a time (one has to iterate through) -- I wouldn't call that an array (as the PHP docs describe), it's just ONE row!
Perhaps someone can better explain this to me. I fear I might be misunderstanding something that could become important to me in future coding . . .
Thanks again!
Felix