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.

[haku]

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