$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 { // HERE IS WHERE I WOULD STORE THE RESULTS INTO AN ARRAY TO BE ACCESSED BY FLASH } $count++; }