[Resolved] Limiting amount of posts per day

[Kefka]

Hi all,
I'm still getting to grips with php (and loving every moment 🆒 ) so forgive me if this is a n00b question...

I'm making a site where users can register and then make posts on the site. The user and post info are stored in a MySQL database (user table, primary key is uname, and a posts table, primary key is post_id).

The system of registering, logging in, posting and eating posts is all completed.

I'm looking for the best way to limit the amount of posts a user can make per day (to something like 5).

Any ideas on how this could be best achieved?

Thanks
~Kefka

[Pig]

One option would be to do a simple query when they try to post. Query the post table to see how many they have done today.

$result = mysql_query("SELECT COUNT(posts_id) FROM posts WHERE posts_user=$curr_user_id AND posts_date >= " . strtotime("12 am today"));
$row = mysql_fetch_row($result);
if( $row[0] ) >= 5 ) die("No more posts for you!");

[Kefka]

Ah, that should work just fine!

It's always so simple ^_
PHP has a tendancy to be like that

Cheers!
Kefka