RE: [PHP-DB] SQL statement syntaxis

2005-01-07 Thread Bastien Koert
missing the singles quotes around the company name text element $query_company_listing = "SELECT CompanyID, CompanyName, CompanyOrDepartment, BillingAddress, City, PostalCode, PhoneNumber FROM company WHERE company.CompanyName='".$_POST['CompanyName']."' ORDER BY CompanyName ASC"; bastien From: [E

Re: [PHP-DB] SQL statement syntaxis

2005-01-07 Thread Joseph Crawford
the syntax for that looks fine to me what you might want to try doing is something like this if( isset( $_POST['CompanyName'] ) ) { $query_company_listing = "SELECT CompanyID, CompanyName, CompanyOrDepartment, BillingAddress, City, PostalCode, PhoneNumber FROM company WHERE company.Co