Simple search only returning 1 record!

Anon

Hello pros,

I have a simple search running on my site that looks like this:

$sql = "SELECT * FROM Film WHERE title LIKE '%$searchString%'";
$res = mysql_query( $sql );
$arr = mysql_fetch_row( $res );
{
echo "$arr[0] $arr[1] $arr[2] $arr[3] $arr[4] $arr[5] $arr[6]";
}

Now, when I submit a query through a form, it only returns the first value it finds!

How do I get it to find more then one value?

Thanks in advance!

Anon

You need to fetch_row and echo lines in a loop.