PHP search script error

[Limit]

This is my script:

			<?php
				@require "includes/connect.php";
					$search = $_POST['search'];
					$explode = explode(" ", $search);
		    		$search = "biz_name LIKE '%" . implode("%' OR biz_name LIKE '%", $explode) . "%'";
					$count = count($explode);
					$query = array();
					for ($i=0, $i < $count, $i++){
		    			$query[$i] = mysql_query("SELECT * FROM businesses WHERE $search");
					}

					
		    		echo "<p><strong style=\"font-size: 13px;\">Standard listings</strong></p>";
		    		if (@mysql_num_rows($result) == 0) {
		    			echo "There are currently no listings for this category.";
					}
		    		while (@$row = mysql_fetch_assoc($result)) {
		    		    $row['biz_description'] = str_replace("\n", "\n<br />", $row['biz_description']);
		    			echo "<p style=\"padding: 10px; border: 1px dashed #C4C4C4; width: 96%;\"><a href=\"http://".$row['biz_website']."\" onclick=\"window.open(this.href,'_blank');return false;\"><strong>".$row['biz_name']."</strong> - <em>".$row['biz_website']."</em></a><br />";
		    			echo $row['biz_description'];
		    			echo "</p>";
					}
			?>

i get this error:

Parse error: parse error, expecting `';'' in search.php on line 51

line 51 is within that script but i cannot find it. What the script does is when a user searchs for example 'Webmaster Forum' it will split it into biz_name like 'webmaster' or biz_name like 'forum'.

any help fixing this will be appreciated.

[insitedev]

The issue is with your for loop. Use semi-colons instead of commas to separate the parts.

[Limit]

k that fixed that but how do i display the results i tried:-

while($row = @mysql_fetch_array($query)) {
		echo $row['biz_name'];
	}

but it won't display the results from the search.

[Limit]

when using this:-

PHP Code:

                @require "includes/connect.php";
                    $search = $_POST['search'];
                    $explode = explode(" ", $search);
                 $search = "biz_name LIKE '%" . implode("%' OR biz_name LIKE '%", $explode) . "%'";
                    $count = count($explode);
                    $query = array();
                    echo "<p><strong style=\"font-size: 13px;\">Search Results</strong></p>";
                    for ($i=0; $i < $count; $i++){
                     $query[$i] = mysql_query("SELECT biz_name, biz_description, biz_website FROM businesses WHERE $search");
                 if (@mysql_num_rows($query[$i]) == 0) {
                     echo "There are currently no listings for this category.";
                    }
                 while (@$row = mysql_fetch_assoc($query[$i])) {
                  $row['biz_description'] = str_replace("\n", "\n<br />", $row['biz_description']);
                     echo "<p style=\"padding: 10px; border: 1px dashed #C4C4C4; width: 96%;\"><a href=\"http://".$row['biz_website']."\" onclick=\"window.open(this.href,'_blank');return false;\"><strong>".$row['biz_name']."</strong> - <em>".$row['biz_website']."</em></a><br />";
                     echo $row['biz_description'];
                     echo "</p>";
                    }
                    } 


It returns two results when i search 'webmaster forum' one for webmaster the other for forum can i fix this. so that is still searches for both biz_name LIKE 'webmaster' OR biz_name LIKE 'forum' but only show one result.

[insitedev]

well.. you could try a couple things.

1. use DISTINCT in the query (SELECT DISTINCT [columns] WHERE .....)
2. use a GROUP BY in the query (SELECT [columns] WHERE ..... GROUP BY [uniquecolumn])

By "uniquecolumn" I mean something that would be common only if the two results were identical (such as the id).

[Limit]

sorry couldn't get on last night but i have fixed the problem. It was that one of my other scripts was interfering.