Layered as an employee management system, check the manual that's corresponds to your MySQL server version what's wrong with that?
I use a hierarchy to do an employee management system, write to the employee paging there when there is such a hint: you have a error in your SQL syntax; Check the manual-corresponds to your MySQL server version for the right syntax-use-near ' 6 ' on line 1
I said I have never seen, where is the problem, how to modify it?
Require_once ' SqlHelper.class.php ';
Class empservice{
Set get $pagecount, how many pages are there
function Getpagecount ($pageSize) {
$sql = "SELECT count (ID) from EMP";
$sqlHelper =new sqlHelper ();
$res = $sqlHelper->execute_dql ($sql);
if ($row =mysql_fetch_row ($res)) {
$pageCount =ceil ($row [0]/$pageSize);
}
Mysql_free_result ($res);
Mysql_close ();
return $pageCount;
}
Set up employee information that should be displayed
function Getemplisebypage ($pageSize, $pageNow) {
$sql = "SELECT * from Limit". ($pageNow-1) * $pageSize. ", $pageSize";
$sqlHelper =new sqlHelper ();
$res = $sqlHelper->execute_dql ($sql);
Releasing Resources close connections
Mysql_free_result ($res);
$sqlHelper->close_connect ();
return $res;
}
}
?>
------Solution--------------------
PHP code
$sql = "SELECT * from Limit". ( $pageNow-1) * $pageSize. ", $pageSize";