Problem inserting value from html page

[fisher7679]

The data is passing as I can echo it. The issue I am having is in these to lines I suspect.

 

 

$name= mysql_real_escape_string($_POST['name']);

$data = mysql_query ('SELECT * FROM `my_data` WHERE `value` LIKE CONVERT(_utf8 \'%$name%\' USING latin1) COLLATE latin1_swedish_ci');

 

My issue is I need to be able to use the $name result in the $data string. I however am unable to do this. Is there a way to accomplish this?

 

Thank you in advance for any help you can give.

Edited March 21, 2013 by fisher7679

[haku]

$data = mysql_query ("SELECT * FROM `my_data` WHERE `value` LIKE CONVERT(_utf8 '%$name%' USING latin1) COLLATE latin1_swedish_ci");