mysql_fetch_array() expects parameter 1 to be resource
Posted: Tue Sep 29, 2009 12:33 am
Hi friends,
I am getting this error :
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\test\edit.php on line 11
with this code
<?php
$con = mysql_connect("localhost","new","test");
$db = mysql_select_db("test",$con);
$select = mysql_query("select * from table");
echo "<table border='0' cellpadding='0'
cellspacing='0' width='500'>";
while($result = mysql_fetch_array($select))
{
$id = $result['id'];
$name = $result['name'];
$age = $result['age'];
$salary = $result['salary'];
echo "<tr><td>$name</td><td>$age</td><td>$salary</td
><td><A HREF='delete.php?name=$name'>DELETE</A></td><td><A
HREF='update.php'>UPDATE</A></td></tr>";
}
echo "</table>";
?>
I am getting this error :
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\test\edit.php on line 11
with this code
<?php
$con = mysql_connect("localhost","new","test");
$db = mysql_select_db("test",$con);
$select = mysql_query("select * from table");
echo "<table border='0' cellpadding='0'
cellspacing='0' width='500'>";
while($result = mysql_fetch_array($select))
{
$id = $result['id'];
$name = $result['name'];
$age = $result['age'];
$salary = $result['salary'];
echo "<tr><td>$name</td><td>$age</td><td>$salary</td
><td><A HREF='delete.php?name=$name'>DELETE</A></td><td><A
HREF='update.php'>UPDATE</A></td></tr>";
}
echo "</table>";
?>