multiple table search with mysql

[TobesC]

i want to search multiple tables to see whether a certain user has posted more than three times in any category in my database. how can i do a search for the same field in different tables?

 

thanks.

[immanuelx2]

easy, you use the 'as' function... here's an example:

 

mysql_query = ("SELECT M.name, M.posts, C.name as category_name
               FROM members as M, categories as C
               WHERE M.category_id = C.id");

[micah1701]

select table1.columnName, table2.columnName FROM table1,table2 WHERE table1.columnName = '$value' OR table2.columnName = '$value'

[Renlok]

use sql join

 

itd be something like

 

SELECT * FROM table1, table2

WHERE table1.column = table2.column

 

Or you could have

 

SELECT * FROM table1

LEFT JOIN table2 ON ( table1.column = table2.column )