need a lil bit help

[bijaybd]

hello there ,
does anyone no the code in sql how to limit the room enter users not more then 30 i mean to say per room user limit is 30 anyone know the code please let me know thanks .

and sorry for my bad english.

[synergyx2009]

what script you using? and is it for a chat room cos if so you can also do it in php

[bijaybd]

yes

anybody know how to code this ???? anyone

[bijaybd]

can anybody there who can help me on this

[Anshul]

can anybody there who can help me on this

$users = mysql_fetch_row(mysql_query("SELECT COUNT(`id`) FROM `chat_users` WHERE ltime>'".intval(time()-$offline)."' AND room='$rid'"));
if($users[0] >= "30")
{
# error you cnt enter
}
else
{
# you can enter
} 

[bijaybd]

hey anshul bro thanks a lot

[Anshul]

hey anshul bro thanks a lot

better to click on thankx button