SQL statement
| From: | (PHPDiscuss - PHP Newsgroups and mailing lists) | Date: | Thu, 06 Jan 2005 19:08:54 +0000 |
| Subject: | SQL statement | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-38049@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.
I'll really appreciate any/all help!
Have you all an excellent year!
Jorge