mySQl Query help

[reub77]

I'm joining 3 tables at the id field in mySQL. I get an error.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/shabangw/public_html/invoices.php on line 51

This is my query:

$query = "SELECT currprojects.companyName, contracts.dueDate, invoices.amount, currprojects.jobSummary, invoices.invoiceDate, invoices.paid FROM currProjects, contracts, invoices WHERE currprojects.id = contracts.id AND currprojects.id = invoices.id AND invoices.id = contracts.id";

Does anything look wrong? How can I make it work? I've never joined 3 tables. Only 2 and I followed the same logic that I would for 2 but added a little more. Help me if you can.

[jburfield]

The first thing I notice is that you list the currProjects table two different ways, 'currProjects' and 'currprojects'

That will not work. It can only be one or the other, unless you have TWO tables with the same name and different case.

Check to make sure ALL of your field names are correct in the database and query.

Also, you might want to throw a GROUP BY statement in there as well, or you will most likely end up with quite a few more rows thatn you were hoping for.

-- Jason