The LoonyBin Caption Game
$title
"; $sql = "SELECT caption, pictureID, dateTime, who, up-down AS score, caption_name, people.hidden FROM captions INNER JOIN people ON people.id=captions.who $query $orderBy "; $result = mysql_query($sql); if(mysql_num_rows($result)==0) { print "No captions yet"; } else { print "
"; while ($caption = mysql_fetch_assoc($result)) { if($caption['hidden']>1 && !isset($_COOKIE['user'])){ $who="
Private Member
"; } else { $who= "
{$caption['caption_name']}
"; } $caption['dateTime']=makeNiceDate($caption['dateTime']); print "
{$caption['dateTime']}
{$caption['caption']}
-
$who
"; } print "
"; } ?>