Jump to content

[SOLVED] UNION maybe? joining tables..


shcKr-

Recommended Posts

Hey, im just struggling with this:

I want to be able to search multiple tables in my mysql database, i have bedroom, dining, living ect.

and i want to be able to search them and show the results, i tried:

 

$query = "SELECT dining.title FROM bedroom
UNION SELECT bedroom.title FROM dining
WHERE bedroom.title LIKE '%".$keywords[$i]."%' OR dining.title = '%".$keywords[$i]."%'";

 

but that doesn't work, I'm not that experienced in sql and the code I just gave you will probably be laughed at  ;D::)

But atleast i tried - but i really do need help on this.

Link to comment
https://forums.phpfreaks.com/topic/122699-solved-union-maybe-joining-tables/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.