Database and queries

[Latch]

Hi guys, I have a database that I need to run a query on but I am at a bit of a loss. I have used mysql to build the table and uploaded ny data into it but how do I write a query to do a search on it. What I want to do is allow people to put in their first and surname and run a search on the database for matching records. So how do I conect it to the database?

thanks for the help in advance.

Latch

[coopster]

You'll need to decide on a server-side technology (such as PHP) for running those statements, Latch. What are you using today or intending to use?

[mack]

As Coopster pointed out you will need to use a scripting language to acheive this. ASP or PHP are pretty common options for this.

What your script will need to do is build an sql query to send to the database. The script will need to know your mysql log in details such as host name, username and password. It will then be able to access the data contained within the database.

Mack.

[Latch]

I will be using PHP.

cheers
Latch

[maxi million]

excellent choice!
:)