Warning:mysql_num_rows (): supplied argument is not a valid MySQL result RESOURC

<title>Untitled Document</title>

Include ("conn.php");
$SQL = "SELECT * from ' Liuyanban ' ORDER by id DESC";
$query =mysql_query ($SQL);


$total =mysql_num_rows ($query);
$pagesize = 3;
$end _page=ceil ($total/$pagesize);
$page = $_get[' page ']; Current page
if ($page <=0)
{
$page = 1;
}

if ($page > $end _page)
{
$page = $end _page;
}
$start = ($page-1) * $pagesize;
$sql = "SELECT * from Liuyanban limit $start, $pagesize";

mysql_query ("Set names ' GBK '");
$ros = mysql_query ($sql, $connect);
?>


echo "Message form";
echo "
";
echo "Current [$page] page, total [$end _page] page";
if ($page ==1)
{

?>
Home
}else
{
?>
Home


}
?>

"> Previous page
"> Next page

if ($page = = $end _page)
{
?>
Last
}else
{
?>
"> Last
}
?>

while ($row =mysql_fetch_array ($ros)) {?> }?>

Membership Form
Name	Mailbox	Message content	Operation
			"> Modify" > Delete

Add Membership table record

Reply to discussion (solution)

There are always two errors:
Database Connection Successful!
Warning:mysql_num_rows (): supplied argument is not a valid MySQL result resource in F:\phpnew\htdocs\hp\admintxl2.php on Line 26

Warning:mysql_fetch_array (): supplied argument is not a valid MySQL result resource in F:\phpnew\htdocs\hp\admintxl2.php On line 103

$query =mysql_query ($SQL) or Die (Mysql_error ());

Could you tell me where to change the place, please?

Change to become
Unknown column ' id ' in ' order clause '

Thank you. Moderator

