[RESOLVED] Querying three tables at once

[stubarny]

Hi everyone,

I'm trying to query a recruitment website database to find the live jobs (from table "ads_live"), archived jobs (from table "ads_not_live") and payment transactions (from table "transactions") for an account's username (stored in $_SESSION[account_username]).

$sql = "SELECT * FROM ads_live, ads_not_live, transactions WHERE ad_account_username = '$_SESSION[account_username]'";

The above code fails and i can only google information on seeing if columns in different tables equal each other, rather than a variable.

Thanks for your help!

Stu

[ahundiak]

Please post at least a simplified list of your table columns. In particular how does transactions link to ads and which table has the ad_account_username.

[wilku]

As far as I remember FROM and a list of tables is in fact an inner join (or was it outer join?) so mysql will try to join the tables "horizontally". If you want to combine results from different tables use UNION:
http://dev.mysql.com/doc/refman/5.0/en/union.html

[stubarny]

Thanks very much, that did the trick! 🙂

Stu