$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++; }