[PHP-DB] adding a space in mysql From: ron wallace (wallace1248 <email protected>)
Date: 07/31/02

thanks, helpers, but I think I have a simple solution:
 I will insert a space at the front of the string,
where the db must accept and retain it.

BTW, here is the SQL I am working with:
//////////////////////////////////////////
elseif ($desc==desc) {
  $sql="SELECT bandid, bandname, bandesc, bin_id,
genre
  FROM bands, genre WHERE
(bands.genreid=genre.genreid) AND ";

  while (list($key, $word)=each($wordsarray))
//$wordsarray from textbox input
     {
        $sql=$sql."(bandname LIKE '$word %' OR
                         bandname LIKE '% $word %' OR
                         bandname LIKE '% $word' OR
                         bandesc LIKE '$word%' OR
                         bandesc LIKE '% $word %' OR
                         bandesc LIKE '% $word' OR
                         genre LIKE '$word%' OR
                         genre LIKE '% $word') AND ";
      }
$sql=substr($sql, 0, (strlen($sql)-5));
$sql=$sql." ORDER BY genre.genre ASC, bandname ASC";
                           }
///////////////////////////////////////////////////
If I do "bandname='$var' I would not hit the band 'Red
Letter Day' if the user jusr types 'red'.

__________________________________________________
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php