Здравейте този код ми дава грешка и не мога да рабера какжо съм объркала в селекта
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( );
?>
Моля ви за съвет
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( );
?>
Моля ви за съвет