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