Jump to content

1planetone

New Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

1planetone's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. 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]
×
×
  • Create New...

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.