load sql problem..

[yuan]

how can i list out the data from mysql with limit 15 records per page and according to same item name?

[mogster]

Well, here's some code:

## Function ##
function multiGen($count, $perpage, $page, $pageurl) {
if($count > $perpage) {
$pagenum = $count / $perpage;
$pagenum = ceil($pagenum);
if($page == $pagenum) {
$to = $pagenum;
} elseif($page == $pagenum - 1) {
$to = $page + 1;
} elseif($page == $pagenum - 2) {
$to = $page + 2;
} else {
$to = $page + 3;
}
if($page < 4) {
$from = 1;
} else {
$from = $page - 3;
}
$multicode = "<a href=\"$pageurl&page=1\">Start</a>";
for($i = $from; $i <= $to; $i++) {
if($i == $page) {
$multicode .= "&nbsp;<b>[$i]</b>&nbsp;";
} else {
$multicode .= "&nbsp;<a href=\"$pageurl&page=$i\">$i</a>&nbsp;";
}
}
$multicode .= "<a href=\"$pageurl&page=$pagenum\">End</a>";
}
if($multicode == "") {
$multicode = "One page";
}
return $multicode;
}

## Set num per page ##
$perpage = 30;
if($page == "") {
$page = 1;
$start = 0;
} else {
$start = ($page - 1) * $perpage;
}

## Do the querys ##
$query = mysql_query("SELECT COUNT(*) FROM table WHERE item='$item'") or die(mysql_error());
$itemcount = mysql_result($query, 0);
$multimsg = multiGen($itemcount, $perpage, $page, "script.php?item=$item");

$query = mysql_query("SELECT * FROM table WHERE item='$item' ORDER BY regtime DESC LIMIT $start, $perpage") or die(mysql_error());
while($item = mysql_fetch_array($query)) {
echo "Here you echo the $item rows";
}
echo $multi;

Been a while since last test of this code, so consider it a start 😉

knutm

[yuan]

thanks... i'll try it... 🙂