Page 1 of 1

PHP & MySQL Dates

Posted: Sun Jun 13, 2010 12:42 am
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 :/

Re: PHP & MySQL Dates

Posted: Sun Jun 13, 2010 1:16 am
by Eran
You don't quote the date

Code: Select all

date = '$today'