Gettign a varible from a form and sticking it into a query ?

[adi5402]

Im trying to make a dynamic query but my result always comes up blank. I have a page where the form mthod used is POST and i call a second page where I fist make the post into a varible using

<?php
$temp1=$_POST['Name'];
?>

then stick temp1 into a query like below my problem is that LIKE %$temp1% just comes up blank where as if i put the same condition in the LIKE wildcard ill get a answer my query looks as follows.

$sql = 'SELECT `book_id` , `title` , `author1` , `author2` , `subject ` , `publisher ` , `keywords ` '
        . ' FROM `greybook_books`.`books` '
        . ' WHERE `title` '
        . ' LIKE \'% $temp1 %\''
        . ' LIMIT 0 , 30'; 

Does not work but does not throw error either

$sql = 'SELECT `book_id` , `title` , `author1` , `author2` , `subject ` , `publisher ` , `keywords ` '
        . ' FROM `greybook_books`.`books` '
        . ' WHERE `title` '
        . ' LIKE \'% $sams %\''
        . ' LIMIT 0 , 30'; 

works fine but i need it to work with a varible where have i gone wrong

[Mordecai]

Don't put a variable inside quotes (double, single, whatever). It will be parsed inside double quotes, but this often reduces the speed of your program. However, within single quotes, it is not parsed at all--hence your problem. What you want to do is concatenate (fancy word for 'link together') the string and the variable, like so: 'string'.$var.'more string'

[adi5402]

Thnks so much that worked like a charm iv spend all day trying to get my head around this thanks again