|
|
Posted by Ravi on 05/25/07 04:46
On May 24, 6:24 pm, Miss...@gmail.com wrote:
> Ravi :> Hi,
> > Before alloting a room check the rooms like
>
> > select count(roomid) from maproomstudent mp ,rooms where
> > room.roomid=mp.roomid
>
> > after this check if count >=2 don't allot otherwise allot it
>
> -------------------------------------------------------------------------
> hey, thanks but how can i write this statement in php?
>
> after this check if count >=2 don't allot otherwise allot it
> ??
>
> :s sorry for bothering
>
> waiting for ur reply
$sql ="select count(roomid) from maproomstudent mp ,rooms where
room.roomid=mp.roomid";
$result = mysql_query($sql);
$row = mysql_fetch_row($result);
Navigation:
[Reply to this message]
|