[thelist] php help !!

[Brian Cummiskey]

info wrote:

> hi,
> i am very curious to know if someone could help me with a small 
> problem that i am having?
> i hope you can. here it is.
> visit sample site here: http://test.rowait.com/new/inventory.php
> problem: i want to search two columns from one input field. you can 
> test  it.
> search for ie. 93 honda
> and i should get all the results matching those two words (numeric as 
> well as alphanumeric).
> so far, i can only search by typing a specific field, where LIKE in 
> mysql query has been used to match against possibilities.
> thanks in advance.
> Sincerely,
> Moses

depending on how you DB is set up, one option would be to use the IN set.

select year y from table_1 AS y
left join make AS m ON y.some_id = m.some_id
where m.keyword_field IN ($IN_QUERY_STRING)
OR
y.keyword_field IN ($IN_QUERY_STRING)

or something like that

you can populate the "IN" array with a for each loop, like

foreach( $searchfield as $v )
 {
    $IN_QUERY_STRING .= "$v,";
 }
 //get rid of the last comma
   $IN_QUERY_STRING = substr($IN_QUERY_STRING,0,-1);