Results 1 to 2 of 2

Thread: Creating Sortable Database List

  1. #1
    Join Date
    Nov 2010
    Posts
    2

    Creating Sortable Database List

    Hi,

    I have created a fairly simple website, but am getting hung up on one thing. A part of my site needs to have some sort of organized list, that can be narrowed or sorted in some way. I am creating an aviation website, and would like to have a list of flight schools, that could possible be filtered by location, or a few other variables. What would be the easiest way to do this without hardcoding all the information?

    That is the most important part, but if possible - I would like to be able to create a user form where someone could come and fill out information for the flight school, and submit it themselves.

    Creating databases and that sort of code is really not my thing - so pointing me in the right direction would be great!

    Thanks,
    Alix

  2. #2
    Join Date
    Feb 2006
    Location
    Salisbury UK
    Posts
    4,332
    There are probably several ways. PHP can sort, but it's a complicated language to learn.

    You could use "chained select boxes" which uses javascript. You have two or more select boxes in a form and a choice in the first changes the options in the second, and so on. See http://www.dynamicdrive.com/dynamici...ects/index.htm which uses vehicle manufacturers, the maufacturer chosen in the first box then shows only that manufacturer's vehicle types in the second box.

    The chained select box would presumably be used in conjunction with an email to send details of a car type to a viewer, but the chained select menu
    http://www.dynamicdrive.com/dynamici...menu/index.htm
    can be used as a navigation menu to open another page.
    Code downloaded to my PC will be deleted in due course.
    WIN7; IE9, Firefox, Opera, Chrome and Safari for Windows; screen resolution usually 1366*768.
    Also IE6 on W98 with 800*600 and IE8 on Vista 1440*900.

Similar Threads

  1. Creating a Searchable List
    By mxalix258 in forum Client & Server Side Scripting (PHP, ASP, JavaScript)
    Replies: 1
    Last Post: 16 Nov 2010, 02:53 AM
  2. Sortable, browser editable list/table of items (ad's site style)
    By MrVon in forum Web Design, HTML Reference and CSS
    Replies: 0
    Last Post: 24 Feb 2010, 10:31 AM
  3. Creating multiple dynamic list boxes from mysql database
    By phoenix211984 in forum Client & Server Side Scripting (PHP, ASP, JavaScript)
    Replies: 0
    Last Post: 26 Sep 2006, 07:26 PM

Posting Permissions

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