Query Not Working?

[kalo93]

Here's my code:

<style type="text/css">
<!--
.b {
    font-weight: bold;
}
.red {
    color: #F00;
}
-->
</style>
<form action="" method="post">
<table width="310" height="32" border="0">
  <tr>
    <td width="137">Login Name:</td>
    <td width="264"><input type="text" name="username"></td>
  </tr>
  </table>
<p class="red"><span class="b">This is NOT your character's name </span>
</p>
<p class="red"><input type="submit" value="Vote" name="vote"></p>
<?php
$user = mysql_real_escape_string($_POST['username']);
$ucheck = mysql_query("SELECT * FROM `accounts` WHERE `name`='".$user."'") or die(mysql_error());
$votecheck = mysql_query("SELECT * FROM `accounts` WHERE `name` = '".$user."' && `votedtoday` != 1") or die(mysql_error());
$alreadyvoted = mysql_num_rows($votecheck);
if(isset($_POST['vote'])){
if(mysql_num_rows($ucheck) >= 1){
    if(alreadyvoted >= 1) {
        mysql_query("UPDATE `accounts` SET `paypalNX` = paypalNX + 10000 WHERE `name` = '".$user."'") or die(mysql_error());
        mysql_query("UPDATE `accounts` SET `votedtoday` = 1 WHERE `name` ='".$user."'") or die(mysql_error());
        echo "Successfully added 10k NX to your account, if you are currently logged in, relog. You will now be redirected.";
        echo"
        <META HTTP-EQUIV=\"refresh\" CONTENT=\"1;URL=http://www.gtop100.com/in.php?site=39688\">
        ";
    }
    else{
        echo "You have already voted today, come back tomorrow!";
        }
}
    else{
        echo "Username does not exist.";
    }

}
?>
</form>

But when I use it, even if votedtoday = 0 it will still say they have already voted.

Please help.

[kows]

The SQL looks fine. How is "votedtoday" set up? Do you have a cron script that sets the entire table's "votedtoday" value to 0 at midnight, or something?

After writing that, I noticed your error. You are checking the constant that doesn't exist, 'alreadyvoted,' rather than the variable $alreadyvoted. Just change that and everything should work fine.

This line:

    if(alreadyvoted >= 1) { 

[kalo93]

After all that, I made a basic mistake >_>

I forgot to use $alreadyvoted instead of alreadyvoted.

[Nightwalker83]

Yeah it is easy to forget the $ in front of php variables sometimes! Especially when you have a lot of code to deal with.

[Static]

might i suggest getting UltraEdit for coding php/html etc... it has syntax highlighting for PHP, html, css, js, java, perl, vb, c++, MySQL.. etc its very nice and worth the $!!! it makes it easy to see when you miss a $ because of the coloring.