[SOLVED] check if user posted today

[abs0lut]

the new post link will appear if the user didn't post for today once,

the new post link will not appear if the user already posted one. then, tomorrow the new post link will appear. could you please help me?

[obsidian]

Try something like this, replacing your variables or values where appropriate:

<?php
$sql = mysql_query("SELECT COUNT(post_id) FROM posts WHERE DATE(post_time) = CURDATE() AND posted_by = $user_id");
if (mysql_num_rows($sql) == 0)
{
  // User has not posted today, so show the link
}
?>

[abs0lut]

thank you