February 21st, 2003, 06:59 PM
Join Date: Nov 2002
Location: GA, USA
Time spent in forums: < 1 sec
Reputation Power: 0
2 queries, loop once for every record
I have 2 queries. One is a list of books, the other is a list of stores.
I want to display the list of books in table rows (no problem), and list each store in columns next to the book name.
book1 store1 store2 store3
book2 store1 store2 store3
book3 store1 store2 store3
book4 store1 store2 store3
I am having a problem looping through the mysql array for the stores on every row....it just comes back blank. when I pull the loop outside of the book loop, it works, so I guess I don't understand how to nest them correctly.
Can someone show me a really rough example so I can see what I am doing wrong?
Thanks in advance,