Hi
I try to create search engine that can search on multi tables
for example
I have db called search
And I have those following tables
baby_items
 decoration
 photo_frames

I want to create search engine that can go to all those tables and give me some output

I used
 while(list($table) = mysql_list_tables(search))
 {
    $query = mysql_query("SELECT * FROM $table WHERE.....;
    and find match and output it
 }
but it has 2 problem
1. it is too slow.
2. and it did not give me any out put.

For those kind of search engine do i have to create a spider?

Thanks
Regards
Mani_he

SELECT FROM baby_items, decoration, photo_frames WHERE......

-Snib
Where will you be in 100 years?
Try new FreshView 0.2!

Thanks Snib
And can I use This Query or it is wrong
$query = mysql_query("SELECT * FROM bay_items, decoration,... WHERE special_price<>''")
I mean we always use equal, but now i used not equal. I wodering is wrong or right?

Thanks
Regards
Mani_he

That is correct syntax.

-Snib
Where will you be in 100 years?
Try new FreshView 0.2!

Thanks snib

Regards
Mani_he