Warning: mysql_fetch_array(): supplied argument is not

formy

Registered
Здравейте този код ми дава грешка и не мога да рабера какжо съм объркала в селекта
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Documents and Settings\hrisi\My Documents\My Pictures\xampp\htdocs\search.php on line 15



<?php
$search = $_POST ["mes"];
$host="localhost";
$user="root";
$password="";
$db="bgsites";
$connect=mysql_connect( "localhost", "root","");
if (!$connect) { echo("ERROR: " . mysql_error() . "\n"); }

mysql_select_db($db) or die ("no select DB");
$query="SELECT phone,email FROM urls where url LIKE %$search%";
if (!$query) {echo("ERROR:". mysql_error()."\n");}
$result= mysql_query($query);

while ($row = mysql_fetch_array($result))

{

echo "Phone:".$row["phone"]."<br>";
echo "Email:".$row["email"]."<br>";

}
mysql_close( );

?>
Моля ви за съвет
 
'%$search%'

трябва да има и кавички май ..

edit:
или така ..

$query=mysql_query("SELECT phone,email FROM urls where url LIKE '%$search%' ");

като махнеш
$result= mysql_query($query);
 

Back
Горе