I have a huge db of data drawing information from a form that is submitted. There is so much data that i made the form submit to 4 different mysql tables that are all within the same db. Now I know I have my connections correct, but what I want to have happen is have the rows of my html table repeat, while there is still data in the 4 mysql tables. I know that the rows in the mysql tables will all be identical, so that isn't a problem, the problem i'm having is in my do {repeat info goes here} and while {what is going to make the information repeat}
sometimes I can have one table of data shown, but then it just repeats the same entry for the other 4 entries, sometimes I can have no info from all but one table, this is what I have written for my wile statement right now:
Code: Select all
while ($row_general = mysql_fetch_assoc($general) & $row_curriculum = mysql_fetch_assoc($curriculum) & $row_products = mysql_fetch_assoc($products) & $row_miscellaneous = mysql_fetch_assoc($miscellaneous));
the 4 tables are general curriculum products and miscellaneous. That code won't work it has a table with 5 rows, 4 are blank and one has the info from the first row of mysql, can anyone help?