Jump to content

Archived

This topic is now archived and is closed to further replies.

1planetone

PHP/MYSQL database results problem

Recommended Posts

Hi there,
I am having little problem while I try to retrieve
data from mysql table, everything works fine but the
first row of the table display empty, here is how it is look like:
----------------------------------
empty ¦ results ok
----------------------------------
results ok ¦ results ok
----------------------------------
results ok ¦ results ok
----------------------------------
results ok ¦ results ok
----------------------------------
results ok ¦ results ok
----------------------------------

here is my code

[code]<?php
include_once ("dbase/mysql_connect.php");
?>

<table>

<?php

$limit = 25;
$query_count = "SELECT * FROM Rb_fiftyMl_bottle";
$result_count = mysql_query($query_count);
$totalrows = mysql_num_rows($result_count);

if(empty($page)){
$page = 1;
}

$limitvalue = $page * $limit - ($limit);
$query = "SELECT * FROM Rb_fiftyMl_bottle LIMIT $limitvalue, $limit";
$result = mysql_query($query) or die("Error: " . mysql_error());

if(mysql_num_rows($result) == 0){
echo("Nothing to Display!");
}

$bgcolor = "#CCCCCC"; // light gray

echo("<center><table>");

while($row = mysql_fetch_array($result)){
if ($bgcolor == "#CCCCCC"){
$bgcolor = "#FFF4CA";
}else{
$bgcolor = "#CCCCCC";
$product_name = $row['product_name'];
$product_id = $row['product_id'];
}

echo("<tr bgcolor=".$bgcolor.">");
echo("<td><a href=\"products_details.php?product_id=$product_id\">$product_name</a></td>");
echo("<td>");
echo($row["product_price"]);
echo("</td></tr>");
}

echo("</table>");

if($page!= 1){
$pageprev = $page-1;

echo("<a href=\"$PHP_SELF?page=$pageprev\">←</a> ");
}else{
echo("←  ");
}

$numofpages = $totalrows / $limit;

for($i = 1; $i <= $numofpages; $i++){
if($i == $page){
echo($i." ");
}else{
echo("<a href=\"$PHP_SELF?page=$i\">$i</a> ");
}
}

if(($totalrows % $limit)!= 0){
if($i == $page){
echo($i." ");
}else{
echo("<a href=\"$PHP_SELF?page=$i\">$i</a> ");
}
}

if(($totalrows - ($limit * $page)) >= 0){
$pagenext = $page+1;

echo("<a href=\"$PHP_SELF?page=$pagenext\">→</a>");
}else{
echo("→");
}

mysql_free_result($result);

?>

</table>[/code]

Share this post


Link to post
Share on other sites
Since there's no zero record in your db table, change:
[code]$limitvalue = $page * $limit - ($limit);[/code]
to this:
[code]$limitvalue = ($page-1) * $limit  +1;[/code]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.