Jump to content


Photo

query from the drop down menu


  • Please log in to reply
3 replies to this topic

#1 tauchai

tauchai
  • Members
  • PipPip
  • Member
  • 14 posts

Posted 24 May 2006 - 04:39 AM

i couldn't found the code for the query using the drop down menu...if anyone hae similar code or know how 2 do, could u plz copy to here?

i want to query the database to get the result of the room and its inventory from two tables ( table room and table inventory) using the drop down menu..

actually total got 3 table ,include room type ( to show disccusion room, meeting room etc)


the structure looks like this : select room type : drop down menu

select room name: drop down menu

Result is down here:

...........................................................................................

plz help....

#2 tauchai

tauchai
  • Members
  • PipPip
  • Member
  • 14 posts

Posted 25 May 2006 - 07:47 AM

or any links will do..as i nit some idea to start the coding...

#3 wisewood

wisewood
  • Members
  • PipPipPip
  • Advanced Member
  • 226 posts
  • LocationRotherham, England

Posted 25 May 2006 - 01:23 PM

It is not clear exactly what you are wanting to acheive.
wisewood: proven fact, I am both wise, and wooden.

#4 tauchai

tauchai
  • Members
  • PipPip
  • Member
  • 14 posts

Posted 26 May 2006 - 01:37 AM

it means based on the user input throught the drop down menu, we provide the result...the result is retrieved from the database....then the result is shown down there of the same page....based on the input from user (drop down menu). of coz there is a "query" button for user to submit....do u understand? hope so..hehe.. [img src=\"style_emoticons/[#EMO_DIR#]/laugh.gif\" style=\"vertical-align:middle\" emoid=\":laugh:\" border=\"0\" alt=\"laugh.gif\" /]

plz help.....

thxs..




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users