My apologies for the large email, but I wanted to include all the source code for 
interested folks and thank everyone who provided suggestions for implementing "hot or 
not"-like functionality. 

Here is what I ended up doing. I've stripped out alot of the formatting to make it as 
readable as possible, but it's a little messy. Tried to comment it to help you see 
what is going on.

Basically, it builds a comma separated list of images that have been rated and using 
"NOT IN" in the query, gets a random one that hasn't been seen yet. 

Feel free to contact me off list if you want to see the beta page that implements this.



 @ $conn = getDBConn();
 $total_num_rows = 4;  // number of rows in table -- will not stay static, but for 
beta, just make it 4

 @ $action = $_POST['action'];  //set by the form; 
 if ($action == "rateIt") {
  @ $excludeList = $_POST['excludeList'];  // comma-separated list of ID's; passed as 
a hidden form field
  @ $rating = $_POST['rating']; // the user-submitted rating
  @ $honID = $_POST['honID'];  //the ID for the image; passed as a hidden form field

  $query = "update hotornot set numVotes=numVotes+1, pointTotal=pointTotal+".$rating." 
where honID=" . $honID; 
  $result_rateIt = mysql_query($query);
  //get last image plus statistics
  $query = "select image, numVotes, pointTotal from hotornot where honID=" . $honID;
  $result_getLastPic = mysql_query($query);
  $row = mysql_fetch_array($result_getLastPic);
  $lastImage = $row['image']; 
  $lastNumVotes = $row['numVotes'];
  $lastPointTotal = $row['pointTotal'];
 } else {
  $excludeList = "0"; // reset or for first time visitor -- must init it as a 0, 
otherwise db error if empty
 //get new image
 $query = "select honID, image from hotornot where honID not in (" . $excludeList . ") 
order by rand() limit 1";
 $result_getPic = mysql_query($query);
 $row = mysql_fetch_array($result_getPic);
 $image = $row['image'];
 $noMoreImages = FALSE;
 if (!$image) { // identifies that query as not finding an image, which means it was 
the last image
  $noMoreImages = TRUE;
 $honID = $row['honID'];

if ($action == "rateIt") {
   <!-- this is the "Last Image" table, shows the one the user just rated and it's 
statistics -->
   <TABLE bgcolor="#9999CC">
    <td align=center><?php echo round($lastPointTotal/$lastNumVotes,1); ?><br>
        based on <?php echo $lastNumVotes;?> votes<br>
        You rated it: <?php echo $rating; ?> <br>
    <img src="hotornot/<?php echo $lastImage; ?>" width=80 height=80 border=0 vspace=2 
} else {  //else, the user just started and there is no "Last Image" box to show
echo '<img src="images/dot-white.gif" alt="" width="110" height="1" border="0">';
<form action="hotornot.php" method="post" target="_top">

<TABLE border="0" width="340" bgcolor="#FFFFFF" cellpadding="0" cellspacing="0">
  if ($noMoreImages) {
   echo '<TR><TD><A HREF="hotornot.php">Start Over</A></TD></TR>';
  } else {
  <TD colspan="12"><BR><div align="center"><h3>Rate from 1 through 10 to see the next 

   <!-- Horizontal array of radio buttons for the user to click. Clikcing on one 
immediately submits the form with the onclick events. -->

  <td bgcolor=#204080><div align="center"><input type=radio name=rating value=1 
onclick="this.form.submit()"><BR><font size=1 color="#FFFFFF">1</font></div></td>
  <td bgcolor=#202F70><div align="center"><input type=radio name=rating value=2 
onclick="this.form.submit()"><BR><font size=1 color="#FFFFFF">2</font></div></td>
  <td bgcolor=#3F2060><div align="center"><input type=radio name=rating value=3 
onclick="this.form.submit()"><BR><font size=1 color="#FFFFFF">3</font></div></td>
  <td bgcolor=#5F2050><div align="center"><input type=radio name=rating value=4 
onclick="this.form.submit()"><BR><font size=1 color="#FFFFFF">4</font></div></td>
  <td bgcolor=#7F1F4F><div align="center"><input type=radio name=rating value=5 
onclick="this.form.submit()"><BR><font size=1 color="#FFFFFF">5</font></div></td>
  <td bgcolor=#90103F><div align="center"><input type=radio name=rating value=6 
onclick="this.form.submit()"><BR><font size=1 color="#FFFFFF">6</font></div></td>
  <td bgcolor=#B0102F><div align="center"><input type=radio name=rating value=7 
onclick="this.form.submit()"><BR><font size=1 color="#FFFFFF">7</font></div></td>
  <td bgcolor=#CF0F1F><div align="center"><input type=radio name=rating value=8 
onclick="this.form.submit()"><BR><font size=1 color="#FFFFFF">8</font></div></td>
  <td bgcolor=#E0000F><div align="center"><input type=radio name=rating value=9 
onclick="this.form.submit()"><BR><font size=1 color="#FFFFFF">9</font></div></td>
  <td bgcolor=#F00000><div align="center"><input type=radio name=rating value=10 
onclick="this.form.submit()"><BR><font size=1 color="#FFFFFF">10</font></div></td>
 <input type=hidden name="honID" value="<?php echo $honID; ?>">
  $excludeList = $excludeList . "," . $honID;  //add the current image/row to the 
excludelist so you don't get duplicates until you cycle all the way through all the 
 <input type="hidden" name="excludeList" value="<?php echo $excludeList; ?>">
 <input type=hidden name="action" value="rateIt">
 <TR><TD colspan="12"><div align="center">
 <!-- here is the new image to rate -->
  <IMG src="hotornot/<?php echo $image; ?>" width="250" height="250" border="1"></div>
} //end no more images check

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to