[SOLVED] SQL query error

[MrBillybob]

query:

$sql = 'SELECT * FROM `eve_wallet` WHERE `refType` = \'' . $in_refType . '\'';

 

error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

 

What causes this?

[ToonMariner]

echo out the string and copy and paste it direct into phpmyadmin (or similar) see what error that throws...

[mtoldfield]

So the actual query is...

 

SELECT * FROM `eve_wallet` WHERE `refType` = 'variableoutput'

 

Seems fine to me. Personally though, I have had problems when using the ` `. I don't use those with my queries and they seem to run fine. Have you tried that? Otherwise, have you just tried the following:

 

$sql = 'SELECT * FROM `eve_wallet` WHERE `refType` = \'$in_refType\'';

 

Usually works for me...

[MrBillybob]

i have i c&p'ed this

 

SELECT * FROM `eve_wallet` WHERE `refType` = 'Bounty Prize'

 

and it worked

[ToonMariner]

swap

 

$sql = 'SELECT * FROM `eve_wallet` WHERE `refType` = \'' . $in_refType . '\'';

 

for

 

$sql = "SELECT * FROM `eve_wallet` WHERE `refType` = '" . $in_refType . "'";

 

I prefer double quotes AND concatenation on query strings - IMO its easier to read the code then!

[MrBillybob]

still doesnt work i have tried all of these...

 

 

P.S. not trying to be rude