RE: [PHP-DB] SQL statement syntaxis

2005-01-07 Thread Bastien Koert
R BY CompanyName ASC"; bastien From: [EMAIL PROTECTED] (PHPDiscuss - PHP Newsgroups and mailing lists) To: php-db@lists.php.net Subject: [PHP-DB] SQL statement syntaxis Date: 6 Jan 2005 19:12:16 - Hello everybody, I'm building a small application and I have trouble passing a POST var

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

[PHP-DB] SQL statement syntaxis

2005-01-06 Thread PHPDiscuss - PHP Newsgroups and mailing lists
Hello everybody, I'm building a small application and I have trouble passing a POST variable form one page to another inside the SQL statement. The query (displayed below) works great without the ".$_POST['CompanyName']." $query_company_listing = "SELECT CompanyID, CompanyName, CompanyOrDepartme

[PHP-DB] SQL statement syntaxis

2005-01-06 Thread PHPDiscuss - PHP Newsgroups and mailing lists
Hello everybody, I'm building a small application and I have trouble passing a POST variable form one page to another inside the SQL statement. The query (displayed below) works great without the ".$_POST['CompanyName']." $query_company_listing = "SELECT CompanyID, CompanyName, CompanyOrDepartme