How to edit or remove citys / states in database for my php script ??

Discussion in 'MySQL' started by Jason328, Oct 21, 2009.

  1. #1
    Hey guys I'm really new to the website building and I'm sure this is such a noob questions so you will get some humor out of answering it for me. lol


    Ok well I uploaded a php script for a real estate website. there is a search string with the city and states. I just want to keep one state and the citys i want to delete the ones I do not need.

    How do I do this? there is no option in the script to delete this and I asked the company that sold it to me and all they would say is that i have to change the values in my phpadmin area. They could not offer me detailed information on how to do this and just gave me the names of the files I would have to edit. City_Vs is one of them. Can someone tell me exactly how to do this? I do not know anything about editing a mysql database and I really want to learn this.

    the site is
    http://www.buyhomesinny.net/search

    thanks for the help!

    I'm really Confused :confused::confused:
     
    Jason328, Oct 21, 2009 IP
  2. mastermunj

    mastermunj Well-Known Member

    Messages:
    687
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    110
    #2
    Jason328, please post some examples so that we can get idea about what exactly you wish to do.

    If you have little knowledge of mysql, share table structures with us to help us build actual queries for you.
     
    mastermunj, Oct 21, 2009 IP
  3. Jason328

    Jason328 Peon

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I really don't know how to describe it better, if you go to my site you will see the search box with citys, states I just want to remove all the citys but Brooklyn And I want to remove all states but new York
     
    Jason328, Oct 22, 2009 IP
  4. mastermunj

    mastermunj Well-Known Member

    Messages:
    687
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    110
    #4
    Link gives following error message:

     
    mastermunj, Oct 22, 2009 IP