PROS! Simple search engine?

[Anon]

Hello pros,

Can anyone give me a hand with a simple serach engine?

I basically have one table with 9 rows of data, BUT I only want my users to be able to search one row...the TITLE row.

When they enter the search terms I want a page to be spit out that calls all of the TITLE that match their terms...along with some other variables attached to that title!

Any help would be appreciated!

Thanks in advance.

[Anon]

something like this...

select * from table_name where title like '%$searchstring%'

[Anon]

Thanks!

[Anon]

Hey Mark....the example you gave is only returning 1 variable...how do I make return more than one?

[Anon]

Put more data in your database? 😛
Just kidding 🙂

while(list($data) = mysql_fetch_row(mysql_query("select * from table_name where title like '%$searchstring%'")) {
echo $data."<br>";
}

Brian wrote:

Hey Mark....the example you gave is only returning 1 variable...how do I make return more than one?