MySQL & PHP

[spider1405]

Hi Everyone,

I want to create a MySQL database or access database to display a car dealer stocks on different pages.

Eg: One Page for Used Cars, One for Light Commercials, one for new cars, etc. and stocks should be able to be entered into the dbase using a simple user interface on a php page like an admin page.

If you could help that would be great!

[jr_yeo]

reading through this site might help

[costas]

Do you have any knowledge of how you access data from MYSQL using PHP?

[jr_yeo]

Do you have any knowledge of how you access data from MYSQL using PHP?

just a little

[shachi]

jr_yeo: I think costas was asking the OP and not you.

[jr_yeo]

oh.... my mistake

[costas]

Well, I think I could help. Give me some details and I see what can I do.

[spider1405]

Hi,

I have scrapped that first idea. I need to have a database which contains details of Mobile Phone Dealers. I have set up a MySQL database but nothing else.

I need to be able to add new dealers & edit existing dealers in the dbase from a php page.

Dealer details to be saved in dbase:
Delaer Name, Delaer Phone, Dealer Fax, Email, Website (with link), address, phone operators (4 operators listed below), description, delaer logo/image

I need to add a search form to a php page that will search the db and display results on a page.

The search should be done on these items:
County/State: There will be 26 counties
Phone Networks/Operators: There will be 4 operators: Vodafone, O2, 3 Ireland, Meteor

A person using the search should be able to select multiple operators but only one county or an option for All Counties.

Can anybody help me to do this?

[costas]

Hi Spider1405,

I think I can help, but the answer is quite big so it'll take one day or two.

Regards

[spider1405]

thanks costas