Posted by 4sgcv5hy6d0r on 09/06/07 12:03

Hi group!
Why str_replace does not work in this case?
Thanks in advance!

if ($cat0 != ''){ $query_cat0 = "cat0 LIKE '$cat0%'"; }
if ($cat1 != ''){ $query_cat1 = "AND cat1 LIKE '$cat1%'"; }
if ($cat2 != ''){ $query_cat2 = "AND cat2 LIKE '$cat2%'"; }

$mysql_query = "SELECT * FROM mytable WHERE ".$query_cat0." ".
$query_cat1." ".$query_cat2;
$what = 'WHERE AND';
$with = 'WHERE';

$mysql_query = str_replace($what, $with, $mysql_query);

echo $mysql_query;

• Next in forum: Re: Extending classes at runtime
• Prev in forum: Re: Session variables and IE7
• Thread view: help with str_replace in select statement

[Reply to this message]