Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New Coder
    Join Date
    Jan 2013
    Posts
    13
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Question Newbie question time

    Hi,

    I'm a noob when it comes to PHP and I'm wanting to do the following on a website using data in a MYSQL database:

    Have an intial Form type box that asks for the type of service the user is after:
    i.e. it reads specfic items from a column in the database called sname and autofills in the Drop down form.(note there are multiple entries for the same name in this column but would only like to see it once in the drop down list)

    Once the selection is made the user can then narrow down the search using several more drop down form type boxes with the following names that are also autofilled depending on previous boxes selected.

    Those other DB columns would be: scategory, scategorytype, scategorytype1, sregion, scity, ssuburb.
    There would be one special form that would have multiple dollar amounts selectable and not from the DB but it would check the DB column scategorycost to see if the value falls within the selected amount.
    i.e. options available in drop down form would be like the following : $0-$5, $6-10, $11-20 etc

    The initial drop down box and the special drop down box would be the only two that would be compulsory wether the other drop down forms have selected data or not i'd like it to display certain fields to the user on the same page if possible.
    i.e. db columns called sprovidername, sprovideraddress, sproviderurl and semail

    Yeah well thats about it i spose..lol nice and easy...

    Any help would be appreciated..

    Happy New Year

  • #2
    New Coder
    Join Date
    Jan 2013
    Posts
    13
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Smile

    Using some of the resources found on this great forum I have managed to create a 7drop ajax Autofill PHP script using the data in my MYSQL DB.

    All I need to do now is be able to pass the <> amounts through to the 'scategorycost' column in my 'services' table and produce a list of those db entries that meet that criteria. (I'm figuring the best way to do this would be have the <> amounts in its own column in my DB ?)

    Columns to post to an HTML page as results would be as below:
    sprovidername, sprovideraddress, sproviderurl and semail

    I will attempt to learn this info from the site but if someone can help with the right direction in the mean time all good..

    Cheers


  •  

    Posting Permissions

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