PHP & MySQL Dates

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
Csnake
Forum Newbie
Posts: 1
Joined: Sun Jun 13, 2010 12:40 am

PHP & MySQL Dates

Post by Csnake »

Code: Select all

     $today = date("Y-m-d");

      $query = mysql_query("select * from user where username = '$user'") or die(mysql_error());
      if(mysql_num_rows($query)==1){

      $query = mysql_query("select * from points where username = '$user' AND date = $today") or die(mysql_error());
      if(mysql_num_rows($query)==0){
        mysql_query("insert into points (username, date, points) values('$user', $today, 1)");
        echo "<p>1 Thank you, Your points have been added.</a>";
      } else {
        mysql_query("UPDATE points SET points = points+1 WHERE username = '$user' AND date = $today");
        echo "<p>2 Thank you, Your points have been added.</a>";
      }

      } else {
       echo '<div style="color: red">Invalid Username</div>';
      }

The code always executes the INSERT INTO MYSQL.
Help :/
User avatar
Eran
DevNet Master
Posts: 3549
Joined: Fri Jan 18, 2008 12:36 am
Location: Israel, ME

Re: PHP & MySQL Dates

Post by Eran »

You don't quote the date

Code: Select all

date = '$today'
Post Reply