gabs Posted June 30, 2006 Share Posted June 30, 2006 Hi, I want to insert PHP in an SQL statement..how do I do this? This is what I want to do... [code] $A4 = "Depth = 297 AND Width = 210 "; [color=red]*[/color]$query = "SELECT Quantity FROM Enquiries WHERE $A4"; $result = odbc_exec($conn, $query) or die (odbc_error());[/code][quote]I get this error message...Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ''., SQL state 37000 in SQLExecDirect in C:\Program Files\xampp\htdocs\valuesx.php on line 9337000[/quote] line[font=Verdana] [color=red]93 is *[/color][/font] Quote Link to comment https://forums.phpfreaks.com/topic/13289-inserting-php-in-sql-statement/ Share on other sites More sharing options...
zq29 Posted June 30, 2006 Share Posted June 30, 2006 You need to match it against a field in the database, for example:[code]$query = "SELECT Quantity FROM Enquiries WHERE measurement = '$A4'[/code] Quote Link to comment https://forums.phpfreaks.com/topic/13289-inserting-php-in-sql-statement/#findComment-51162 Share on other sites More sharing options...
gabs Posted June 30, 2006 Author Share Posted June 30, 2006 Ok, I have found my own answer....[quote] $papertype = "SELECT Quantity FROM Enquiries WHERE Depth = 297 AND Width = 210"} $query = $papertype; $result = odbc_exec($conn, $query) or die (odbc_error());[/quote] Quote Link to comment https://forums.phpfreaks.com/topic/13289-inserting-php-in-sql-statement/#findComment-51165 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.