Yes simple - my schoolboy error
Glad all is working now. Will take you up on that dinner if I'm ever your way. Likewise if you ever find yourself on the Namibia/Angola border with some time to kill give me a shout
Regards,
Dave.
Moderator: General Moderators
I actually removed that first call as soon as it was explained it wasn't necessary until later in the code.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.
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!!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?
It actually was, once I started thinking "scripting" and just put a lot of time on task!mikosiko wrote:will be easy...
Code: Select all
$ExhibitsQuery_result = mysql_query($ExhibitsQuery)fbachofner wrote:....There's still ONE concept that bothers me though:
I thought a construct likewas what "fetched" the data and that that fetch_assoc put it ALL into an array.Code: Select all
$ExhibitsQuery_result = mysql_query($ExhibitsQuery)
It appears (to ME) that these statements are one step removed from their respective results:Thanks again!
- 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!
Felix