select from multiple tables error

[lofaifa]

I Basically never did it before , i tried to add those two together

 

$sql1="SELECT * FROM questions WHERE post_num_reporters<>0 ORDER BY post_num_reporters DESC , post_date ASC";

$sql2="SELECT * FROM answers WHERE post_num_reporters<>0 ORDER BY post_num_reporters DESC , post_date ASC";

soo they have they same columns names required , i tried this :

 

$sql="SELECT * FROM questions,answers WHERE post_num_reporters<>0 ORDER BY post_num_reporters DESC , post_date ASC";

and it didnt work , whats the solution ??

[Maq]

You should be joining these tables:

http://dev.mysql.com/doc/refman/5.0/en/join.html

[awjudd]

You will need to prefix your tables in the WHERE and ORDER BY clauses.  That said, you are currently doing a CROSS JOIN between these two tables which I don't think that is what you want.  As Maq said, you probably want to do a JOIN.

 

~awjudd