I’m finding that if there is more than one WHILE loop on a page, the first loop returns a mysql error, as well as the other loops fail.
So, for example, I have a SELECT query on two tables, and then one WHILE loop listing data from both tables, then another WHILE loop on just one of those tables.
Removing either one of these loops (and its variables) will work fine.
I’m trying to say this right without having to post code, but I suppose I could if needed. Has anyone else experienced this? Is this a common syntax thing?