Possible Duplicate:
mysql_fetch_array() expects parameter 1 to be resource, boolean given in select
I am receiving the following two errors:
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\SystemVehicle\delete_multiple.php on line 51
Warning: mysql_fetch_array() expects parameter 1 to be resource, null given in C:\xampp\htdocs\SystemVehicle\delete_multiple.php on line 75
$sql="SELECT * FROM $userlogin";
$result=mysql_query($sql);
//count table row
$count=mysql_num_rows($result);
?>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td><form name="form1" method="post" action="">
<table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td bgcolor="#FF0000"> </td>
<td colspan="4" bgcolor="#FF0000"><strong>Delete multiple rows in mysql</strong> </td>
</tr>
<tr>
<td align="center" bgcolor="#FF0000">#</td>
<td align="center" bgcolor="#FF0000"><strong>name</strong></td>
<td align="center" bgcolor="#FF0000"><strong>matric</strong></td>
<td align="center" bgcolor="#FF0000"><strong>Position</strong></td>
<td align="center" bgcolor="#FF0000"><strong>Department</strong></td>
<td align="center" bgcolor="#FF0000"><strong>UserName</strong></td>
<td align="center" bgcolor="#FF0000"><strong>Password</strong></td>
<td align="center" bgcolor="#FF0000"><strong>Email</strong></td>
</tr>
<?php
while($result=mysql_fetch_array($row)){
?>
How can these be resolved?
$row does not exist (ie, it is not a resource)
Did you mean $result?
EDIT: Just saw the update, have you tried echoing the mysql_error()?
You should fetch query arrays..
<?php
while($row=mysql_fetch_array($result))
{
echo $row['some_column'];
}
?>
I think you need to see what $userlogin contains and run that query against the database.
In other words, table name: $userlogin doesn't exist or needs to be surrounded with backticks : `$userlogin`