keyword search help

[MikeDXUNL]

say the Database Field: `keywords` consists of 'halo 3 xbox 360 master chief'

 

now $by = keywords automattically unless stated otherwise.

 

so the url = http://myurl.com/search.php?halo+xbox&whereat=videogames

i want the mysql_query to look like "SELECT * FROM $whereat WHERE $qu ORDER BY releasedate ASC"

<?php 
$re = split(" ", $q);
$i=0;
while($i < count($re)) {
$qu = " $by LIKE %".$re[''.$i.'']."% OR";

$i++;
}
?>

 

any help on how to piece together the query i desire is thanked in advance

 

- Mike

 

[rajivgonsalves]

try this

 

<?php 
$re = explode(" ", $q);

$arrCondition = array();
$qu = "";

for ($i=0;$i<count($re);$i++)
{
array_push(" $by like '%{$re[$i]}%' ",$arrCondition);
}
$qu = implode(" OR ",$arrCondition);
print $qu;
?>

[MikeDXUNL]

when I try, I get the Syntax Error: Fatal error: Only variables can be passed by reference in C:\wamp\www\vgant\search.php on line 296

 

line 296: array_push(" $by like '%{$re[$i]}%' ",$arrCondition);

 

I tried to edit the go about of quotation marks, but cant seem to figure it out..

any help?

 

Thanks,

Mike

[MikeDXUNL]

bump

[rajivgonsalves]

lolz I got the syntax wrong

 

this

 

array_push(" $by like '%{$re[$i]}%' ",$arrCondition);

 

should be

 

array_push($arrCondition," $by like '%{$re[$i]}%' ");