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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php