|
|
|
|
|
|
|
Βρέθηκαν $number_of_rows πελάτες σε $page1 σελίδες";
?>
0)
{
$prv = "Προηγούμενη";
}
else
{
$prv = "Προηγούμενη";
}
/////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////
//Following SQL Statement uses SQL_CALC_FOUND_ROWS function to calculate total
//number of rows found by the query excluding the limit function added at the
//end of the SQL statement. This is followed by second query with FOUND_ROWS()
//function which actually gives out the number of rows found.
/////////////////////////////////////////////////////////////////////////////////
$q="Select * from customers order by num desc limit $cps, $rpp";
$rs=mysql_query($q) or die(mysql_error());
$nr = mysql_num_rows($rs); //Number of rows found with LIMIT in action
$q0="Select Count(*) as FOUND_ROWS FROM customers ";
$rs0=mysql_query($q0) or die(mysql_error());
$row0=mysql_fetch_array($rs0);
$nr0 = $row0["FOUND_ROWS"]; //Number of rows found without LIMIT in action
/////////////////////////////////////////////////////////////////////////////////
//Following IF Statement is used to determine whether the user has reached the
//last page of the records. For example, if we have 27 rows to print and we show
//10 rows per page, then on the third and the last page it will show seven rows
//and will say at the top that SHOWING RECORDS FROM 21 to 27. If the following
//validator is not used then it shows SHOWING RECORDS FROM 21 to 30.
/////////////////////////////////////////////////////////////////////////////////
if (($nr0 < 10) || ($nr < 10))
{
$b = $nr0;
}
else
{
$b = ($cps) + $rpp;
}
/////////////////////////////////////////////////////////////////////////////////
?>
|
";
echo "![\"\"](\"image/customers/$val3\")
$val4
";
echo " | ";
while ($row=mysql_fetch_array($rs)){
$cps = $cps +1;
$val2 = $row["id"];
$val3=$row["foto"];
$val4=$row["url"];
$nums = ++$num;
echo" |
";
echo "
$val4
";
echo "
|
| _______________________________ |
";
break;
}
}
echo "
$prv";
/////////////////////////////////////////////////////////////////////////////////
//Following IF Statement is used to determine whether the Next link will be
//enabled or disabled. If the user has reached the last page of the record, then
//the Next link will be disabled.
/////////////////////////////////////////////////////////////////////////////////
if ($cps == $nr0)
{
echo " | Επόμενη |
";
}
else
{
if ($nr0 > 5)
{
echo " | Επόμενη | ";
}
}
/////////////////////////////////////////////////////////////////////////////////
?>
|
εταιρία
πελάτες