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.
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.
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.
Here is one way that comes to mind (adapt the select statement to your needs:
Did this method work?
yeah..it did really work. I already tried it ...
|All times are GMT. The time now is 07:43 PM.|
Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0