search errors

[bushkid85]

Errors on num rows and fetch array paramter 1…? help!

[php]$conn = mysql_connect(“localhost”, “", "”);
mysql_select_db("***");

							$searchby = $_POST["searchby"];
							$id = $_POST["id"];
							$mysql = "";
							
						if ($searchby != "")
						{
							$mysql = "SELECT * FROM customer_db WHERE type = '$searchby'";
							$result = mysql_query($mysql);
							
							if (mysql_num_rows($result)==0)
							{
								echo "Sorry there are currently 0 $searchby results please search again<br/>";
							}
			{
					echo "<table width='100%' border='1'>";
					echo "<tr>";
					echo "<td>Site ID</td>";
					echo "<td>Site Name</td>";
					echo "<td>Customer Name</td>";
					echo "<td>Address 1</td>";
					echo "<td>Address 2</td>";
					echo "<td>Post Code</td>";
					echo "<td>Tel No</td>";
									
					echo "</tr>";
							}
			{
					while($row = mysql_fetch_array($result))
								{
					echo "<tr>";
					echo "<td>$row[site_id]</td>";
					echo "<td>$row[site_name]</td>";
					echo "<td>$row[cust_name]</td>";
					echo "<td>$row[add_1]</td>";
					echo "<td>$row[add_2]</td>";
					echo "<td>$row[post_code]</td>";
					echo "<td>$row[tel_no]</td>";
					echo "</tr>";
								}
							}
			{
					echo "</table>";
							}
						}

mysql_close($conn);[/php]