Jump to content

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


Recommended Posts

$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... :)

Link to comment
Share on other sites

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

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...