Greywacke Posted December 29, 2009 Share Posted December 29, 2009 (edited) $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 Link to comment Share on other sites More sharing options...
Greywacke Posted December 29, 2009 Author Share Posted December 29, 2009 (edited) nevermind... found i forgot to add the serviceid column to the 9_supplierattributes table. Edited December 29, 2009 by Pierre 'Greywacke' du Toit Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now