using variables in a SQL LIKE condition.

[Mamo]

Hi,

I have a problem with this code and that is it wouldn't perform the while loop block of code.

<?php
if(mysql_connect('localhost', 'root', 'mamo12121')  && mysql_select_db("mamo")  ) {
    

  
    
    
    $word       =  $_POST['word'];
    $project    = mysql_query("SELECT * FROM project WHERE title LIKE '%+ $word +%'") or die('ooops');



while ($pro = mysql_fetch_assoc($project)) {
    $protit = $pro['title'];
    $proque = $pro['question'];
    
    echo $protit . '<br >' .$proque;
   
} 
?> 

[oaass]

what if you remove the + signs? '% $word %'

[Mamo]

no thing changed...

i even wrote an echo statement after the while loop, and it skipped the while loop and echo out what i wrote.

[litebearer]

perhaps this

'%$word%'

rather than

'%+ $word +%'