hi everyone...
this is what i want my database to do:count how many user register for a certain product and display it in the system.so, everytime a user pick a certain product to register,the database automatically count him,and display,say "3 users registered for this product".and,can i limit how many users can register for a product?say,only 4 users can register for a product and when the 5th user try to register,he will be denied.i have 2 tables and they look like this:
tblRegister<img src=../images/dmxzone/forum/icon_smile_tongue.gif border=0 align=middle>rod_ID|user_ID|date|time tblProduct<img src=../images/dmxzone/forum/icon_smile_tongue.gif border=0 align=middle>rod_ID|prod_name|prod_desc|no_of_register
so,how can i possibly do this the right way?