inserting php in SQL statement??

[gabs]

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 93
37000[/quote] line[font=Verdana] [color=red]93 is *[/color][/font]

[zq29]

You need to match it against a field in the database, for example:
[code]$query = "SELECT Quantity FROM Enquiries WHERE measurement = '$A4'[/code]

[gabs]

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]