Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in

[dcatkin]

<?
/* connection information */ 
$hostname =  "";
$username =  "";
$password =  "";
$dbName =  "cars";
$table = "Cars";
/* make connection to database */ 
MYSQL_CONNECT($hostname, $username, $password) OR DIE( "Unable to connect
to database");

@mysql_select_db("$dbName") or die(  "Unable to select database"); 


               if ($Host == "")
                  {$Host = '%';}

                  if ($User == "")
                  {$User = '%';}

                  if ($Password == "")
                  {$Password = '%';}

                  if ($Select_priv == "")
                   {$Select_priv == '%';}

                  if ($Insert_priv == "")
                   {$Insert_priv == '%';}

                  if ($Insert_priv == "")
                    {$Insert_priv == '%';}

                  if ($Update_priv == "")
                    {$Update_priv  == '%';}

                  if ($Delete_priv == "")
                  {$Delete_priv = '%';}

                  if ($Create_priv == "")
                  {$Create_priv = '%';}

                  if ($Drop_priv == "")
                  {$Drop_priv = '%';}

                  if ($Reload_priv == "")
                   {$Reload_priv == '%';}

                  if ($Shutdown_priv == "")
                   {$Shutdown_priv == '%';}

                  if ($Process_priv == "")
                    {$Process_priv == '%';}

                  if ($File_priv == "")
                    {$File_priv == '%';}

                  if ($Grant_priv == "")
                   {$Grant_priv == '%';}

                  if ($References_priv == "")
                   {$References_priv == '%';}

                  if ($Index_priv == "")
                    {$Index_priv == '%';}

                  if ($Alter_priv == "")
                    {$Alter_priv == '%';}

$query =  ("SELECT * FROM $table WHERE Host LIKE '$host%' AND 
User LIKE '$User%' AND Password LIKE '$Password%' AND Select_priv LIKE
'$Select_priv%' AND Insert_priv LIKE '$Insert_priv%' AND Update_priv LIKE '$Update_priv%' AND Delete_priv LIKE
'$Delete_priv%' AND Create_priv LIKE '$Create_priv%' AND Drop_priv LIKE '$Drop_priv%' AND Reload_priv LIKE '$Reload_priv%' AND Shutdown_priv LIKE
'$Shutdown_priv%' AND Process_priv LIKE '$Process_priv%' AND File_priv LIKE '$File_priv%' AND Grant_priv LIKE
'$Grant_priv%' AND References_priv LIKE '$References_priv%' AND 
Index_priv LIKE '$Index_priv%' AND Alter_priv LIKE '$Alter_priv%'");


$result = MYSQL_QUERY($query);

if (!$result) print ("failed\n");
  /* Determine the number of records returned */ 

WHILE ($row=mysql_fetch_row($result))
$number = mysql_numrows($result);
if (!$number) print("failed 2 \n");
  /* Print the relevant information */ 
$i = 0;
          }
$i++;
ENDWHILE;
PRINT  "</table>";

/* Close the database connection */ 
MYSQL_CLOSE();
?>
[URL=http://hp-car.com/cars/search.php]http://hp-car.com/cars/search.php[/URL] [QUOTE]I coulden't fit all the code on here so I added the url[/QUOTE]

[diego25]

 if ($Select_priv == "")
{$Select_priv == '%';}

That should be

 if ($Select_priv == "")
{$Select_priv = '%';}

Same with the others below it...

Also, try outputting mysql_error(), to see what error MySQL is complaining about...

Diego

[dcatkin]

diego25
Senior Member

Registered: Sep 2002
Location: Toronto, ON
Posts: 679

code:--------------------------------------------------------------------------------
if ($Select_priv == "")

{$Select_priv == '%';}

That should be

code:--------------------------------------------------------------------------------
if ($Select_priv == "")

{$Select_priv = '%';}

Same with the others below it...

Also, try outputting mysql_error(), to see what error MySQL is complaining about...

Diego

---

To look up functions in the PHP manual, just append the function name after http://www.php.net/ . e.g. if you wanted to look up the "count" function, you'd go to http://www.php.net/count

This suggestion diden't work, thanks for the effort, still got the same error