Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Unanswered: php lookup queries

    Hi, I'm using phpmyadmin.

    I'm trying to get a lookup query on my database. Can that be done using phpmyadmin or do I have to write down the SQL myself?

    Would it involve creating a view and then attaching it to a table?

    In my case, I want the user to select from a list of cars, so what i want it to do, is in the "bookings" table to display a list of "cars". Possibly something like a field called "SelectCar" where a drop down menu would appear and the user can just click on the vehicle of their choice.


  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    you give your users access to PHPMyAdmin?

    I suspect what you want is some form of cascading drop down / combo list. in the 'old' days
    you might send a list box of manufacturers on a page
    then send send a list of makes on a page
    then send a list of models on a page
    send all the data (all manufacturers, all makes, all models as one hit and use Javascript to filter that)

    these days you could also use AJAX and szend one page but refresh the drill down boxes as required
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts