|
Title |
User |
View |
Date |
Replies |
Status |
'.(time() - 60*60*24*31);
$res = mysql_query($sql) or mf(__FILE__, __LINE__, $sql);
if (mysql_num_rows($res) == 0) {
echo 'No tickets opened recently |
';
}
while ($row = mysql_fetch_array($res)) {
$sql2 = 'SELECT COUNT(*) FROM tickets WHERE ticket_thread = '.$row['ticket_id'];
$res2 = mysql_query($sql2) or mf(__FILE__, __LINE__, $sql2);
$num = mysql_fetch_array($res2); $num = (int)$num[0] - 1;
?>
. |
|
|
View |
|
|
'.ucfirst($row['ticket_status']).'';
} else {
echo ''.ucfirst($row['ticket_status']).' | ';
}
?>