Jump to content

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


Greywacke
 Share

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

Edited by Pierre 'Greywacke' du Toit
Link to comment
Share on other sites

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

Edited by Pierre 'Greywacke' du Toit
Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...