if (count($_SESSION['Voting_Array']) > 0){ $Voting_Array = implode(",", $_SESSION['Voting_Array']); $ANDIN = "AND picid NOT IN($Voting_Array)"; } if(!$_GET['pid']){ $where = " $ANDIN ORDER BY RAND()"; } elseif(isset($_GET['pid']) AND valid_id($_GET['pid'])){ $where = "AND picid = '{$_GET['pid']}'"; } elseif(isset($_POST['catid']) OR isset($_POST['age'])){ $where = " $ANDIN AND ncat = '".valid_id($_POST['catid'])."' AND age = '".valid_id($_POST['age'])."'"; } $pic_sql = "select picid,picture,id,comment from $pic_tbl,$usr_tbl where id=pic_userid AND $pic_tbl.status = '1' $where "; //echo $pic_sql; $pic_sql_r = mysql_query($pic_sql) or DIE(mysql_error()); if (!mysql_num_rows($pic_sql_r)){ // the first query had no results, so we get the photo they have not voted on yet. $pic_sql = "select picid,picture,id,comment from $pic_tbl,$usr_tbl where id=pic_userid AND $pic_tbl.status = '1' $ANDIN "; $pic_sql_r = mysql_query($pic_sql) or DIE(mysql_error()); } if (mysql_num_rows($pic_sql_r)){ $row_pic = mysql_fetch_array($pic_sql_r); $size = GetNewImageSize($row_pic['picture'],1); $picture = $siteurl."/pictures/".$row_pic['picture']; $pid = $row_pic['picid']; $userid = $row_pic['id']; $UserAllowComment = $row_pic['comment']; $UserAllowMsg = $row_pic['messageemail']; if ($_COOKIE['voted'] == $pid AND !$error){ $error = "