require('includes_constant.php');
require('includes_lib.php');
$link = mysql_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD);
mysql_select_db(DB_DATABASE);
require('includes_login_submit.php');
$id = $_REQUEST["id"];
$page = $_REQUEST["page"];
$page = (is_numeric($page)) ? intval($page) : 1;
if (!is_numeric($id)) $id = 1;
$sql = "select * from makeover";
$result = mysql_query($sql) or die(mysql_error());
$num_rec = mysql_num_rows($result);
mysql_free_result($result);
$total_pages = intval(($num_rec / 10)) + (($num_rec % 10 == 0) ? 0 : 1);
echo $total_pages;
$sql = "select id, name, description, imgthumb, imglarge from makeover order by name limit ".(($page - 1) * 10).", ".(($page - 1) * 10 + 10);
$result = mysql_query($sql) or die(mysql_error());
$prod_i = 0;
while( $row=mysql_fetch_array($result) ){
$prod["id"][$prod_i] = $row['id'];
$prod["name"][$prod_i] = $row['name'];
$prod["imgthumb"][$prod_i] = $row['imgthumb'];
$prod_i += 1;
}
mysql_free_result($result);
mysql_close($link);
?>
vote