Jump to content

Archived

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

hecheng

[b]Like function in select statement[/b]

Recommended Posts

the following is my mysql_query statement

 

$result=mysql_query(\"select * from elementary where Location like \'%\".$_POST[\'textfield\'].\"%\'\", $mylink);

 

If I input inToronto for my search string,

the result does not output the records that have

Toronto in them.

 

could anybody explain how i can fix the problem?

 

Thank you!!!

 

 

 

:D

Share this post


Link to post
Share on other sites

i\'ve had difficulties including $_POST variables in mysql queries before. see if this helps:

 

$search = $_POST[\'textfield\'];

$result = mysql_query("SELECT * FROM elementary WHERE location LIKE \'%$search%\'", $mylink);

 

cheers

Share this post


Link to post
Share on other sites

you can also enclose the POST in braces like so:

 

$result = mysql_query(\\\"SELECT * FROM elementary WHERE location LIKE \'%{$_POST[\'textfield\']}%\'\\\", $mylink);

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.