Jump to content

Archived

This topic is now archived and is closed to further replies.

gabs

inserting php in SQL statement??

Recommended Posts

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]

Share this post


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

Share this post


Link to post
Share on other sites
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]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.