New to mysql and php, need form to access database data for quotes

[ahughes3]

Hi All,

 

I'm a complete beginner when it comes to php and mysql, but I have a challenge and think that a database would do the trick.

 

I have a client who wants visitors to their site to be able to select from some option drop downs and then get a price returned on the page.  The database will contain data such as "location", "product category", "product", "price" etc.  The visitor will select their location first, then the type of product they are looking for and then the actual product.  When they click submit, a price will then be displayed.

 

I have scoured the internet, youtube, google and can't seem to find either some software that would help me to do this (given my little knowledge) or a tutorial which will help explain to me how to achieve it.

 

I think I can probably create the database and can create a form, but I don't know how to do the php to make the form query the database and then return the results.

 

I am interested in getting some help, pointers in the right direction to a solution. I'd even consider paying someone to teach me how to do it (assuming the price was fair of course!).

 

So, does anyone know of a good piece of software, tutorial or have any other suggestion to help me get this done?

 

Thanks

Andy

[trq]

So, does anyone know of a good piece of software, tutorial or have any other suggestion to help me get this done?

 

I'd suggest you start by learning PHP. Your task will then be very simple.

 

There's a good free book in my signature (Hudzilla).