All pastes #793089 Raw Edit

Untitled

public text v1 · immutable
·published 2007-11-21 22:56 UTC
rendered paste body
$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++;
 }