[RESOLVED] User account limit by number -how can I do this??

php_noob2

Hello,

I have an account creation section where "sub-admins" can create users. I set limits for the number of accounts these sub-admins can create in a mysql field. If I have a limit of 10 accounts for example, how can I put that query in so that will control whether or not the sub-admin can create them?

Thanks!!

Phpnoob

NogDog

The simplest way would be to first do a query to find out how many they have created so far. This assumes, however, that there is some way in the database to determine which accounts were created by which admin user?

halojoy

NogDog wrote:
The simplest way would be to first do a query to find out how many they have created so far. This assumes, however, that there is some way in the database to determine which accounts were created by which admin user?

Yes, I suggest you CREATE TABLE 'subadmin'.
Fields could be, just for example like:

item_id
subadmin_id
account_id

Where account_id is the account created by subadmin x

We should not be afraid CREATE new TABLES!!
They make Database searching and handling much more simple.
Read: Makes our SQL Query not too complicated.
We may have for example something like:

$sql = "SELECT count(account_id) FROM subadmin WHERE subadmin_id = '$id'";

regars

php_noob2

Ok, thanks you two. I understand conceptually how to do it and will play with the queries until it's right. The mysql aggregate functions look like what I need for the tally too -right under my nose. I'm such a noob but gaining more skillz all the time. :p