Jump to content


Photo

PHP/MYSQL database results problem


  • Please log in to reply
1 reply to this topic

#1 1planetone

1planetone
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 14 May 2006 - 09:40 PM

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

<?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>


#2 AndyB

AndyB
  • Staff Alumni
  • Advanced Member
  • 5,465 posts
  • LocationToronto

Posted 14 May 2006 - 10:26 PM

Since there's no zero record in your db table, change:
$limitvalue = $page * $limit - ($limit);
to this:
$limitvalue = ($page-1) * $limit  +1;

Legend has it that reading the manual never killed anyone.
My site




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users