Php & Mysql - Picture display

[jnscollier]

Hey all,
I have two tables. One holds comments and the other holds the question/picture info.

What I want to do is if a logged in user has already commented on a picture, for that picture to not display (there is a drop down that allows them to sort by male/female). And if all the questions in the database are answered for the user to see smthg that says like "no more records". I know this should be so easy for me but i'm having the hardest time with this and i dont know why!

I know none of this is secure either that's my next step once i get the basic functionality going. (i have to do some research and reading on how to prevent injunctions) here's what I have... it still displays all the questions that have already been answered AND not answered by the user.

<?php 

$getqry88 = "select distinct(questid) from comments where commid = $id";
    $getres88 = mysql_query($getqry88)or die(mysql_error());
    $getrows88=mysql_num_rows($getres88);
    if($getrows88 > 0){
    while($getarray88=mysql_fetch_array($getres88)){

    $hqid12 = $getarray88['questid'];

}}    

//if male only
if ($_REQUEST['sort'] == 'male')
{

$getqry = "select * from questions where approved = 'yes' and status = 'active' and quest_gender = 'male'  and getquest_counter != $hqid12 order by rand()";

}

//if  female only
if ($_REQUEST['sort'] == 'female')
{

$getqry = "select * from questions where approved = 'yes' and status = 'active' and quest_gender = 'female'  and getquest_counter != $hqid12 order by rand()";
}


$getres = mysql_query($getqry)or die(mysql_error());
$getrows=mysql_num_rows($getres);
if($getrows > 0){
while($getarray=mysql_fetch_array($getres)){
        
    $pic = $getarray['pic1'];
    $qid2 = $getarray['getquest_counter'];
    $question = $getarray['question'];
        }
}    

else 

echo "no records";
?>

I've tried moving the brackets around to include the second query, but that doesn't work either.

any help would be greatly appreciated!

[jnscollier]

ok, so i figured out a way to make it work.... however, now i keep getting an error message when the person has commented on all questions. It shows my custom message and then this at the bottom of the page:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

I researched this online and it says something about magic quotes and addslashes. I don't think I need that because I'm just really focusing on querying an integer right? am i wrong about this?? here's my code now....

<?php 
//if male only
if ($_REQUEST['sort'] == 'male')
{

$getqry = "select * from questions where approved = 'yes' and status = 'active' and quest_gender = 'male'  and getquest_counter not in(select questid from comments where commid = $id)  order by rand()";
} 

//if female only
if ($_REQUEST['sort'] == 'female')
{

$getqry = "select * from questions where approved = 'yes' and status = 'active' and quest_gender = 'female'  and getquest_counter not in(select questid from comments where commid = $id)  order by rand()";


} 

$getres = mysql_query($getqry)or die(mysql_error());
$getrows=mysql_num_rows($getres);
if($getrows > 0){
while($getarray=mysql_fetch_array($getres)){
        
    $pic = $getarray['pic1'];
    $qid2 = $getarray['getquest_counter'];
    $question = $getarray['question'];
        }
}    

else if($getrows == 0){

echo "No new questions to answer.";

}
?>