Mysql error

[yasmine]

Hi friends,

I don't know whether this thread is related to this forum or php forum.
Please forgive me, if i had done this mistake.

Can anyone tell me is it possible to write a query attached with php variable in where clause?

for example,

$nm=implode(",",$si[name]);
$result=get_records_sql("select name, id from a where name in ($nm)");
echo $result;

But this query shows me the following 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 'something' at line 1.

can anybody tell me what is it and what i have to do to fix this?
Please help me out.

Thanx n Regards
Yas...

[debasisdas]

You need to concatinate the variable with sql ,can't include that directly .

Again the variable in the first line might return multiple values. That might be an array .

[mwasif]

$nm=implode(",",$si[name]);
$result=get_records_sql("select name, id from a where name in ($nm)");
echo $result;

If $si[name] is string then you must have to use ',' as a separater for IN () and make sure you have some value in $nm.

Try the below code

$nm=implode("','",$si["name"]);
$result=get_records_sql("select name, id from a where name in ('$nm')");
echo $result;

If you still face any problem then use mysql_error() to get the exact error message and post here.

[yasmine]

If $si[name] is string then you must have to use ',' as a separater for IN () and make sure you have some value in $nm.

Try the below code

$nm=implode("','",$si["name"]);
$result=get_records_sql("select name, id from a where name in ('$nm')");
echo $result;

If you still face any problem then use mysql_error() to get the exact error message and post here.

Thanks a lot mwasif.
I didn't use single quotes for separation. Now its working well.


Thank u very much....

Regards
Yas....

[mwasif]

You are welcome.