Greywacke Posted December 29, 2009 Share Posted December 29, 2009 $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 More sharing options...
Greywacke Posted December 29, 2009 Author Share Posted December 29, 2009 nevermind... found i forgot to add the serviceid column to the 9_supplierattributes table. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.