Warning: mysql_fetch_array(): supplied argument is not a valid MySQL

hathgola

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/yosta/public_html/index.php on line 7

and thats a index file please Help

<?PHP
session_start();
include("connection.php");

$sqlsettings = "SELECT * from admin";
$resultsettings = mysql_query($sqlsettings);
$rowsettings = mysql_fetch_array($resultsettings);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>

Bonesnap

You either have an error in your connection, you misspelled the table "admin", or you do not have SELECT permission on the table "admin". In any case, $resultsettings is failing, so start there and work backwards.

hathgola

so should i try to reinstall the script??

hathgola

Please Help I'm new to php

NogDog

Do some basic debugging:

$sqlsettings = "SELECT * from admin";
$resultsettings = mysql_query($sqlsettings);
if($resultsettings == false) // query failed for some reason
{
   user_error(mysql_error()); // get some debug info
}
$rowsettings = mysql_fetch_array($resultsettings);

This should tell you why the query failed, then you may have to work backward from there based on the info it gives you.

zooropa

 
<?PHP
session_start();
include("connection.php");

$sqlsettings = "SELECT * FROM admin";
// change the following line ********************
$resultsettings = mysql_query($dbc,$sqlsettings);
$rowsettings = mysql_fetch_array($resultsettings);
?>

where $dbc is in your connection.php file (but you'll have to change $dbc to whatever you've called it in connction.php)