Hello,
I have comprresed 4 gigs worth of information into atleast 4 or 7 different mysql tables. My whole idea is to make a search engine, so basically I can search all 7 tables at once. All tables have similar structer and field name.
The problem, when i query one table it works but when I wuery 2 i get a invalid resource error which basically says the statement doesnt work.
$results = mysql_query("SELECT $whole_list, $get_select AS relevance FROM $db_tbl WHERE $get_where HAVING relevance>0 ORDER BY relevance DESC LIMIT $page, $limit");
The code above works for querying one table. I have tried "tble1,tabke2" and it doesnt work. I dont wanna use a loop. I would like this query to be done in one line because I will be having alot more tables soon.
Thank you for your time.
