You might try to perform bother queries first then check then by
If ($result1 || $result2) {
echo "You have already voted";
} else {
...
}
This means that if either the username or ip or both exists in the db,
then the user is denied...
Hope this is along the lines of what your needing to do.
> -----Original Message-----
> From: Ryan A [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 24, 2003 12:38 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP] 3 mins of your time please...logic problem
>
> Hi all,
> Am having a bit of a problem understanding this, can anybody tell me
where
> i'm going wrong please?
>
> Basically trying to limit the "vote" to just 1 per person, first am
> checking
> if the the person with username has voted, if that comes back as false
> then
> am checking his ip (because i dont know if the person changed his
> username
> and is trying to vote again) now its allowing me to vote twice and on
the
> third time its restricting me.
>
> *****************code*************
> $check="select vote_date from site_rateing where user='".$username."'
and
> sitenumber=".$n;
> $res = mysql_query($check) or die("Error: " . mysql_error());
> $check_result = mysql_num_rows($res);
>
> if($check_result !=1)
> { $oneVote=1;
>
> $check2="select count(*) from site_rateing where ipno='".$theIP."'
and
> sitenumber=".$n;
> $check_result2 = mysql_result(mysql_query($check2),0);
>
> if($check_result2 >=1)
> { $oneVote=2;}else{$oneVote=1;}
>
> }// end of first "if"
>
>
> if($oneVote ==2)
> {
> $row = mysql_fetch_row($res);
> print("Sorry, You have already voted on ".$row[0].".<br> Only one
> vote
> is allowed");
> exit;
> }
> else
> //continue with the program.
> *****************code*************
>
> Any ideas?
>
> Thanks,
> -Ryan
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
