Untitled
public text v1 · immutable$query = "SELECT * FROM announcements WHERE category='".$category."' AND active='1' ORDER BY date DESC";
$result = mssql_query ( $query ) or die ( 'Query Error' );
$time = time();
while ( $row = mssql_fetch_assoc ( $result ) )
{
if($time > $row['expire'])
{
$id = $row['id'];
$count = 0;
$query = "UPDATE announcements SET active='0' WHERE id='$id'";
mssql_query($query);
}else
{
$title.$count = $row['title'];
}
$count++;
}