TalkPHP - How to get random number based on the condition.

TalkPHP (http://www.talkphp.com/forums.php)

- MySQL & Databases (http://www.talkphp.com/mysql-databases/)

- - How to get random number based on the condition. (http://www.talkphp.com/mysql-databases/5380-how-get-random-number-based-condition.html)

How to get random number based on the condition.

i have two table in my database which is the room table and roomtype table.i'm using phpmyadmin.

room table
room_no
r_roomtypeID

roomtype table
roomtypeID
roomtype

how can i create a query that can select A random room_no from "room table "
based on the roomtypeID in the "table roomtype"

p/s - each roomtypeID got it's own quantity room no.

roomtypeID room_no

example : Single room : 1-10
: Deluxe room : 11-20
: Suite room : 21-30

right now i'm only having this kind of idea. the random number from room. I don't know how can i generate A random room_no from table room based on the roomtypeID.

Code:

(SELECT room_no FROM room ORDER BY RAND( )LIMIT 1)

Here is one way that comes to mind (adapt the select statement to your needs:

SQL Code:

SELECT *, RAND() AS orderByMe FROM tableName WHERE 1 ORDER BY orderByMe LIMIT 1

Did this method work?

yeah..it did really work. I already tried it ...
thanks:)