$sql_string = "SELECT * FROM shirts";
$sql_query = mysql_query($sql_string) or die("SQL Error: ".$sql_string);
$sql_total = mysql_num_rows($sql_query);
$sql_string = "SELECT * FROM shirts LIMIT ".$pagenum.",".$rows_limit;
$sql_query = mysql_query($sql_string) or die("SQL Error: ".$sql_string);
$sql_total_rows = mysql_num_rows($sql_query);
$page_next=$pagenum+$rows_limit;
$page_prev=$page_next-2*$rows_limit;
for ($i=0; $i<$sql_total_rows;){
?>
for($j=0; $j<3; $j++){
$num = mysql_result($sql_query, $i, 'num');
$name = mysql_result($sql_query, $i, 'name');
$url = mysql_result($sql_query, $i, 'url');
$image = mysql_result($sql_query, $i, 'image');
?>
; ?>)
echo($name); ?>
|
$i++;
if($i>=$sql_total_rows) break;
}
?>
}
?>
|