Help! Why Does This Mysql Query Return Boolean In Php?

[Greywacke]

$sql5 = "SELECT * FROM 2_servicescatalogue, 9_supplierattributes, 1_regions WHERE 9_supplierattributes.bigint_SupplierID = ".$row["bigint_SupplierID"]." AND 9_supplierattributes.bigint_ServiceID = 2_servicescatalogue.bigint_ServiceID AND 9_supplierattributes.bigint_RegionID = 1_regions.bigint_RegionID ORDER BY 2_servicescatalogue.text_ServiceDescription, 1_regions.text_RegionDescription ASC;\n";$result5 = mysql_query($sql5);

it should select the correct records, here's the related error:

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\XAMPP\htdocs\fab\scripts\ajax_suppliers.php on line 69

this line is where i do the while loop,

while ($row5 = mysql_fetch_array($result5) {

a multiple table select (supposedly simple) from 3 tables: 2_servicescatalogue, 9_supplierattributes, and 1_regions where the data coincides.i don't see what i'm doing wrong! and i wasn't sure where to post this, SQL or PHP so i posted on both forums...

Edited December 29, 2009 by Pierre 'Greywacke' du Toit

[Greywacke]

nevermind... found i forgot to add the serviceid column to the 9_supplierattributes table.

Edited December 29, 2009 by Pierre 'Greywacke' du Toit