$title

mysql_result($result, 0, 'quote'), 'score' => mysql_result($result, 0, 'score'), 'votes' => mysql_result($result, 0, 'votes')); $title = "Quote $q"; $greeting = ''; } else { init('quotes'); $title = 'Quotes'; $vdefault = ($_GET['view'] == '' || $_GET['view'] == 'default') ? '1' : '0'; if ($vdefault) { // Load low-vote entries for the top $query = "SELECT * FROM `quotes` WHERE `votes` < 3 ORDER BY 'time' DESC"; $result = mysql_query($query) or die ('Error: '.mysql_error()); for($i = 0; $i < mysql_num_rows($result); $i++) $quotes[mysql_result($result, $i, 'id')] = array('quote' => mysql_result($result, $i, 'quote'), 'score' => mysql_result($result, $i, 'score'), 'votes' => mysql_result($result, $i, 'votes')); } // Load the rest $query = 'SELECT * FROM `quotes` ORDER BY '; switch ($_GET['view']) { case '': case 'default': case 'random': $query = substr_replace($query, 'WHERE `votes` >= 3 ', 23, 0); case 'all': $query .= '`score` DESC'; break; case 'top10': $query .= '`score` DESC LIMIT 0, 10'; break; case 'newest': $query .= '`time` DESC'; break; case 'leastvotes': $query .= '`votes` ASC'; break; } $result = mysql_query($query) or die ("Error: ".mysql_error()); for($i = 0; $i < mysql_num_rows($result); $i++) if (mysql_result($result, $i, 'votes') >= 3 || !$vdefault) $quotes[mysql_result($result, $i, 'id')] = array('quote' => mysql_result($result, $i, 'quote'), 'score' => mysql_result($result, $i, 'score'), 'votes' => mysql_result($result, $i, 'votes')); // if ($_GET['view'] == 'top10') // while (count($quotes) > 10) // array_pop($quotes); } mysql_close(); if ($_GET['view'] == 'random') { $rand = array(); foreach(array_rand($quotes, 5) as $rindex) $rand[] = $quotes[$rindex]; $quotes = $rand; } echo "$title"; echo "\n\n"; ?>

$quote) { echo "

New!

" : " id='q$i'>"); echo "\n\t

".$quote['quote']; echo "\n\t

Score: ".round($quote['score'], 1)." | Vote:"; for ($v = 1; $v < 11; $v++) { echo " $v"; } echo " | link

\n\t

"; } ?>