function stars($star_rating){ $array = explode('.',$star_rating); $stars = ''; if(preg_match('@[0-4]@',$array[0])){ for($i=0;$i<$array[0];$i++){ $stars .= '*'; } } if(count($array)==2){ $stars .= '1/2'; } if(preg_match('@[A-Z]@',$star_rating)){ $stars .= $star_rating; } if($star_rating=='0'){ $stars .= '(no stars)'; } $stars = ''.$stars.''; return $stars; } function _e($str){ return htmlspecialchars($str); } require_once('mysql.php'); $db = new MySQL; $db->connect(); $result = $db->select("SELECT * FROM master_list ORDER BY year ASC,star_rating DESC,title ASC"); ${'N/A'} = '';${'DNF'} = '';${'W/O'} = ''; ?> while($movie = $db->get_row($result)): ?> if($movie['year']!=$last_year): ?>= ${'N/A'} ?>= ${'DNF'} ?>= ${'W/O'} ?> ${'N/A'} = '';${'DNF'} = '';${'W/O'} = ''; ?>
= $movie['year'] ?> $yearcount = $db->select("SELECT * FROM master_list WHERE year='".$movie['year']."'"); $eligcount = $db->select("SELECT * FROM master_list WHERE year='".$movie['year']."' AND (star_rating='3.5' OR star_rating='4')"); echo '('.mysql_num_rows($yearcount).'; '.mysql_num_rows($eligcount).')'; ?>
endif; $last_year = $movie['year']; ?>
if($movie['star_rating']!='DNF' && $movie['star_rating']!='N/A' && $movie['star_rating']!='W/O'): ?>
= _e($movie['title']) ?> (= _e($movie['directors']) ?>) = stars($movie['star_rating']) ?>
else: ${$movie['star_rating']} .= _e($movie['title']).' ('._e($movie['directors']).') '.stars($movie['star_rating']).'
'; endif; ?>
endwhile; ?>= ${'N/A'} ?>= ${'DNF'} ?>= ${'W/O'} ?>