How to get random number based on the condition.

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
polly89
Forum Newbie
Posts: 8
Joined: Thu Mar 18, 2010 9:44 am

How to get random number based on the condition.

Post by polly89 »

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 all

(SELECT room_no FROM room ORDER BY RAND( )LIMIT 1)
any ideas is really appreciated:)
User avatar
VladSun
DevNet Master
Posts: 4313
Joined: Wed Jun 27, 2007 9:44 am
Location: Sofia, Bulgaria

Re: How to get random number based on the condition.

Post by VladSun »

Use INNER JOIN in your query
There are 10 types of people in this world, those who understand binary and those who don't
Post Reply