According to the webpage u give me last time, i had write acode abut the pagination. But now i have the problem at this line
"while(list($NameItem) = mysql_fetch_array($result2)) { "
If i want to put all the selected field instead of only NameItem as what i had i done in the query, how should i do?
<?
//required file for database connection
require("config.php");
$query = "SELECT *FROM listofitem ";
$result = mysql_query($query);
$num_record = mysql_num_rows($result);
$display = 10;
if (empty($startrow)) {
$startrow=0;
}
$query2 = "SELECT *FROM listofitem LIMIT $startrow, $display";
$result2 = mysql_query($query2);
print("<table border=0><tr>");
$counter = 0;
while(list($NameItem) = mysql_fetch_array($result2)) {
if ($counter == 3) {
print("</tr><tr>");
$counter = 0;
}
print("<td bgcolor=#004A80 width=200 height=200 align=center><font color=#FFFFFF>$NameItem</font><br><font color=#FFFFFF>");
$counter = $counter + 1;
}
if ($startrow != 0) {
$prevrow = $startrow - $display;
print("<a href=\"$PHP_SELF?startrow=$prevrow\">Previous</a> ");
}
$pages = intval($num_record / $display);
if ($num_record % $display) {
$pages++;
}
if ($pages > 1) {
for ($i=1; $i <= $pages; $i++) { // Begin loop
$nextrow = $display * ($i - 1);
print("<a href=\"$PHP_SELF?startrow=$nextrow\">$i</a> ");
}
}
if (!(($startrow / $display) == $pages) && $pages != 1) {
$nextrow = $startrow + $display;
print("<a href=\"$PHP_SELF?startrow=$nextrow\">Next</a>");
}
if ($num_record < 1) {
print("<table border=0 width=795><tr><td>$XX</td></tr></table>");
}
?>