query($Sql_Cust);
// if ($result->num_rows > 0) {
if ($result->num_rows == 0)
{
echo "0 results";
}
else
{
$nume = $result->num_rows;
}
echo 'Upptagnings schema ' . $nume .'
br>';
*/
echo 'Upptagnings schema ' .'
br>';
$sql=" SELECT * FROM up_days";
$result = $conn->query($sql);
echo "";
echo "
Id |
Upptagningdag |
Klockslag |
Max antal |
Bokade |
";
// ORDER BY cust_no ASC
//////////////// Now we will display the returned records in side the rows of the table/////////
//foreach ($conn->query($query) as $row) {
$pager = new PS_Pagination($conn, $sql, 10, 30, "param1=valu1¶m2=value2");
/* Enable debugging if you want o view query errors*/
$pager->setDebug(true);
$rs = $pager->paginate();
if(!$rs) die(mysql_error());
// while($row = $result->fetch_assoc()) {
while($row = $rs->fetch_assoc()) {
$m=$i%2; // required for alternate color of rows matching to style class
$i=$i+1; // increment for alternate color of rows
// echo "$row[cust_no] | $row[last_name] | $row[first_name] | $row[street] | $row[city] |
";
echo "
$row[id] |
$row[up_day] |
$row[up_time] |
$row[max_no] |
$row[occup_no] |
";
}
echo "
";
echo $pager->renderFullNav();
?>
Tillbaka
|