Hello everyone
As i said in an earlier post i am making a small sub 4 sub website for our community.
I have built 90% of the website and am stuck at the last hurdle, as youtube has a subscription limit of around
30 subscribers an hour i am trying to limit my members to only subing to 30 an hour aswell.
The now i have it where on the sub 4 sub page i list all the accounts that can be subed to through a query, and when a member clicks on one of the members to sub to they come off the list for them as they now have them subed and they gain 1 point, i want it where after they have gained 30 points within the hour instead of the query showing the results(members) i can display a message instead telling them to wait the hour and after an hour the results will show again, can anyone help me with this?
the query im using to show the members is
<?php
$query = "SELECT * FROM users WHERE subcreds > 0 AND username NOT IN (SELECT subscriber_username FROM subscribers WHERE my_id = '$id')";
$sql = mysql_query($query) or trigger_error($query . ' has an error:<br />' . mysql_error());