Need coding help

[Anon]

I am using an odbc connection and it all works wonderfully. I have a search problem though.

Here is the code - I have the $search variable brought from another page. Basically what's happening and what I need to happen:

If the user searches for "Lamar" in the SmallDesc catagory, it says "NO ROWS FOUND", however, if you enter in the search "Lamar Small Ad", it will find the result and display it. That's because within that table data, it says "Lamar Small Ad". I need the search to search for ANY (not necessarily all) of the words in the cell and to display accordingly - what do I need to change in my query code to allow a search for any word?

// Build and submit a query

$query = "select * from People where SmallDesc='$search'";
$result = odbc_Exec($conn, $query);

// Display results

odbc_result_all( $result );

Thanks so much,

Seth

[badman]

hello
change your query to
$query = "select * from People where SmallDesc='%$search%'";

then it will search for items that match either fully or partially the value in $search.
cheers!

[chowdary]

Hi Seth,
If you don't want to perform the exact match use "LIKE" istead "="

$query = "select * from People where SmallDesc like '%$search%'";

Cheers
Ajay

[Anon]

Thanks so much!

[Anon]

Thanks!!!!