[buzzby]

i need to place a count on a form in this way. when the users start to fill the form in they see this notice: "There are 20 places on this module" when the user submits the count needs to go down by 1 so when the next user fills in the form they see this notice "There are 19 places on this module" and so on till it gets to 1. the condition is that the number of places needs to be >=1. if its <1 then a notice needs to be shown "There are no more places" at this instant the database does not keep the data or allow ppl to enter the data. maybe the actual form just wont display.

how can i go about this

[the_mole001]

Hello there,

In your database i would assume that each module has a name, for example 'hugo'. When checking for places available this is what i would suggest.

Have a field, hidden or otherwise, with the value of the module being joined, which i will name 'modname'. The same name i will use in the database.

PHP Code:

//database connecting here

if(isset($_POST['modname'])){

if(mysql_num_rows("SELECT * FROM modules WHERE modname='".$_POST['modname']."'") <= 20){

//do the code that will let them join the module

} else {

//do the code to show the error saying the module is full

}

} 

I hope this code makes sence and helps.