Çàêàçû";
// Òàáñ
$sql = "SELECT * FROM zlo_book_status WHERE id IN (1)";
$result = mysql_query($sql) or die(mysql_error());
if (mysql_affected_rows()!=0) {
echo"
";
while ($row=mysql_fetch_assoc($result)) {
// Ïîäñ÷åò êîëè÷åñòâà çàêàçîâ ïî ñòàòóñó
$sql2 = "SELECT count(`id`) AS calc FROM catalogs_orders WHERE status='".$row['id']."' AND user_id='".$_SESSION['user']['id']."'";
$result2 = mysql_query($sql2) or die(mysql_error());
$row2=mysql_fetch_assoc($result2);
if (mysql_affected_rows()!=0) {
echo"
".$row['title']."(".$row2['calc'].")
";
}
}
echo"
";
}
// =========== Ãåíåðèì òàáëèöó ===========
if (!isset($GET['status'])) {$GET['status']=1;}
$sql = "SELECT o.*, o.id as order_id, o.`mktime` as order_date FROM catalogs_orders as o
LEFT JOIN zlo_users as u on u.id=o.user_id
WHERE o.user_id=".$_SESSION['user']['id']." AND o.`status`='".$GET['status']."' ORDER BY mktime DESC ";
$pager['sql']= $sql;
$pager=pagerGetRun($pager,10,15);
$result = mysql_query($pager['sql']) or die(mysql_error());
if (mysql_affected_rows()!=0) {
while ($order=mysql_fetch_assoc($result)) {
echo"