SQL statement syntaxis
| From: | (PHPDiscuss - PHP Newsgroups and mailing lists) | Date: | Thu, 06 Jan 2005 19:58:34 +0000 |
| Subject: | SQL statement syntaxis | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-38048@lists.php.net to get a copy of this message | ||
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,
CompanyOrDepartment, BillingAddress, City, PostalCode, PhoneNumber FROM
company WHERE company.CompanyName=".$_POST['CompanyName']." ORDER BY
CompanyName ASC";
But it messes up if I include it because the first " is considered as the
end of the previous one and so on. So the code gets messed up.
Any help will be greatly appreciated!
Have everybody a wonderful 2005!
Jorge