need some help with coding....

Discussion in 'Web Design & Coding' started by daraptor, Dec 8, 2006.

  1. daraptor

    daraptor OSNN Junior Addict

    Messages:
    12
    hey guyz,
    am tryin to build a site...am having some problems.....what am tryin to do is..am tryin to build a travel search site....i have got this airport codes in a access file....and the table names are....code,airport name,state,country.....
    what is the exact SQL query to call a airport code by searching the code so that all name,state and country appear.....and also after i get the results ....how do i populate the parent window using the child window.....i hope someone will help me with this....plz guyz.....thanx for the help......
     
  2. Mainframeguy

    Mainframeguy Debiant by way of Ubuntu Folding Team

    Messages:
    3,763
    Location:
    London, UK
    you need to be specific on columns and if this is an access file I would seriously consider switching to SQL server... basically you need to join your tables on the code, probably in a view - then you can use SQL like

    select name, state, country from airports_view where code = yourvalue

    As for the parent and child windows - you'll need someone else to help you there...
     
  3. fitz

    fitz Just Floating Along Staff Member Political User Folding Team

    Messages:
    4,076
    Location:
    Chicagoland
    If I may also suggest using something besides Access as your backed database.

    mySQL on the cheap end or any number of other commercial products besides Access.
     
  4. Geffy

    Geffy Moderator Folding Team

    Messages:
    7,805
    Location:
    United Kingdom
    Depends what he's working with, if he's using ASP or ASP.NET then Access is typically the better choice. An alternative is MSSQL Express which I believe is free. This gives you a proper if cut down SQL server to interface with.
     
  5. X-Istence

    X-Istence * Political User

    Messages:
    6,498
    Location:
    USA
    Is this an end of semester final project?