<?php include("scripts/database.php"); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title></title> <style> </style> </head> <body> <?php if ($_REQUEST['success'] == "added"){ echo "<h1>news added, waiting on Admin approval</h1>"; } ?> <a href="addnews.php">Add news</a><br /> <a href="admin/news.php">Admin<a/><br /><br /><br /><br /> <?php //to dsiplay the news $q = mysql_query("SELECT * FROM news WHERE live = 1")or die(mysql_error()); $c = mysql_num_rows($q); if ($c == 0){ echo "no newss in database"; }else{ $tC = rand(0, $c-1); mysql_data_seek($q, $tC); $r = mysql_fetch_assoc($q); $id = $r['id']; $originalString = "<b>".$r['word']."</b><br />"; $upperCase = strtoupper($originalString); echo "$upperCase"; list($c1, $c2, $c3, $c4, $c5) = unserialize($r['clues']); $originalString = $c1."<br />".$c2."<br />".$c3."<br />".$c4."<br />".$c5."<br />"; $upperCase = strtoupper($originalString); echo "$upperCase"; } ?> <br /><br /> <?php echo "We currently have $c cards in the database\n"; ?> <br /><br /><br /> <form action="scripts/rate.php" method="POST"> <input type="radio" name="rating" value="1" checked /> 1 <input type="radio" name="rating" value="2" /> 2 <input type="radio" name="rating" value="3" /> 3 <input type="radio" name="rating" value="4" /> 4 <input type="radio" name="rating" value="5" /> 5 <input type="hidden" value="<?=$id; ?>" name="id" /> <input type="submit" name="submit" value="Rate Me" /> </form> <br /><br /><br /> <?php $qRate = mysql_query("SELECT * FROM rating WHERE newsId = $id")or die(mysql_error()); $cRate = mysql_num_rows($qRate); $total = 0; if ($cRate == 0){ echo "this card has not been rated yet"; }else{ while ($rRate = mysql_fetch_assoc($qRate)){ $total += $rRate['rating']; } $total = $total/$cRate; echo "Score is ".round($total, 2)." from $cRate votes"; } ?> <br /><br /> </body> </html>