Code: Select all
<?
error_reporting(E_ALL);
$username=$_POST['username'];
$password=$_POST['password'];
$db = mysql_connect("localhost",$username,$password);
mysql_select_db("mysql",$db);
if (! $db)
die("Couldn't connect to MySQL");
$query = "SELECT * FROM user SORT BY id DESC";
$result = mysql_query($query);
echo "<table border=1>\n";
echo "<tr><td>Host</td><td>Username</td><td>Select</td><td>Insert</td><td>Update</td><td>Delete</td><td>Create</td><td>Drop</td><td>Reload</td><td>Shutdown</td><td>Proccess</td><td>File</td><td>Grant</td><td>References</td><td>Index</td><td>Alter</tr>\n";
while ($myrow = mysql_fetch_row($result)) {
printf('<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</tr>',
$myrow[1], $myrow[2], $myrow[4], $myrow[5], $myrow[6], $myrow[7], $myrow[8], $myrow[9], $myrow[10], $myrow[11], $myrow[12], $myrow[13], $myrow[14], $myrow[15], $myrow[16], $myrow[17]);}
mysql_close($db);
?>
</table>I get this error when I use the script.
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /usr/www/html/prototype/web_prototype/matt/admin/listusers.php on line 16