Hi,
What would be the best way to display the results of the following 2 queries? (This is my search page which looks within my database tables to find a match on the 'keyword' posted.
$sqlquery1 = "SELECT * FROM tblexhibitions WHERE MATCH (title,content) AGAINST ('+$mytest' IN BOOLEAN MODE);";
$result1 = mysql_query($sqlquery1);
$sqlquery2 = "SELECT * FROM tblclasses WHERE MATCH (what, date, details) AGAINST ('+$mytest' IN BOOLEAN MODE);";
$result2 = mysql_query($sqlquery2);
I am basically trying to build a search result page and I want to list the results accordingly from the queries.
Thanks in advance.