Page 1 of 1

combining to result sets

Posted: Wed Jan 31, 2007 7:53 am
by hame22
Hi I have 2 result sets generated by mysql queries

$result1, $result 2, how do I combine the 2 results to form just one set of results and then sort them by a particular field?

Thanks in advance

Posted: Wed Jan 31, 2007 8:15 am
by superdezign
How so? You don't give much detail.

Like... You have table rows of a bunch of values, and you want to combine the corresponding values into one table row? That could be done using a loop if you make $result1=mysql_fetch_row($result1) and $result2=mysql_fetch_row($result2)

Posted: Wed Jan 31, 2007 8:19 am
by feyd
Hmm.. duplicate thread.

Locked.