I want to display the data from a table set up like this:
table:
field1 field2, field3, id, order
I select the rows with the same id, then I want to list them in the order of the order variable.
what I have right now:
$loopy = mysql_query("SELECT * FROM response WHERE id='$id'");
Unfortunately, that ignores the order variable and when I use a FOR loop, it lists them in the wrong order.
So my question is: How do i select a row based on the results of two fields?
table:
field1 field2, field3, id, order
I select the rows with the same id, then I want to list them in the order of the order variable.
what I have right now:
$loopy = mysql_query("SELECT * FROM response WHERE id='$id'");
Unfortunately, that ignores the order variable and when I use a FOR loop, it lists them in the wrong order.
So my question is: How do i select a row based on the results of two fields?