Search Query - Help Needed?

[dayzeday]

I am trying to set up a search for a website I am building. The problem I am having is that I am able to get the search to work on one word, but not two. Can anyone help me. I am sure it is something simple and obvious. That is what I seem to miss the most.

Here is the Query Statement:
if($GET[what])
{
$query[] = "(class_catalog.ProductName like '%$GET[what]%')
or (class_catalog.manufacture like '%$GET[what]%')
or (class_catalog.year like '%$GET[what]%')";
}

if(!empty($query))
{
$MyQuery = implode(" and ", $query);
}

if(!empty($order))
{
$MyOrder = implode(" and ", $order);
}
else
{
$MyOrder = " class_catalog.DatePosted desc ";
}

$q1 = " select * from class_catalog where $MyQuery order by $MyOrder limit $Start, $ByPage ";

$qnav = " select * from class_catalog where $MyQuery";

Here is the The Form:
<form method=get action="http://www.truckvendors.com/search.php" style="margin:0" name=SearchForm onsubmit="return CheckSearch();">
<input type=text name=what size=15>
<input type=submit value=Go name=search src="images/img_03.gif"> </form

Okay - If you want to test what is in uses go to:
http://truckvendors.com

[bpat1434]

To say the least, your HTML should be valid: i.e. <input key="value"> You should normally try and keep to that rule.

In PHP, you should refer to non-numerical array pointers by encapsulating them in quotes.

Also, good rule of thumb would be to escape from PHP for variable values. Just to make sure.

So it should probably be like:

<form method=get action="http://www.truckvendors.com/search.php" style="margin:0" name="SearchForm" onsubmit="return CheckSearch();">
<input type="text" name="what" size="15">
<input type="submit" value="Go" name="search" src="images/img_03.gif"> </form>

if($_GET['what'])
{
$query[] = "(class_catalog.ProductName like '%".$_GET['what']."%')
or (class_catalog.manufacture like '%".$_GET['what']."%')
or (class_catalog.year like '%".$_GET['what']."%')";
}

if(!empty($query))
{
$MyQuery = implode(" and ", $query);
}

if(!empty($order))
{
$MyOrder = implode(" and ", $order);
}
else
{
$MyOrder = " class_catalog.DatePosted desc ";
}

$q1 = " select * from class_catalog where $MyQuery order by $MyOrder limit $Start, $ByPage ";

$qnav = " select * from class_catalog where $MyQuery";

If that doesn't work, the next thing I'd tell you to do is to echo the query to make sure it's what you want or should be.

~Brett

[dayzeday]

I had the quote on the form at one time. I tried it both ways. I went back and applied it your way and it still did not work.

I might have need to tell you that; If someone put in two words it is possible that they may be in different fields, with in the query group.