Database Lookup Query

How to do a Database Lookup Query

[kfreshley]

I am looking for a way to do a simple database lookup query. I envision a webpage that looks like a form, the user fills in the information on this form to query the datebase, the query then returns the records that match the query in a html format. Any help or advice would be appreciated. The Database is currently in Access, converting it to MYSQL is an option if needed.

Thank you in advance,
Ken Freshley
<snip>

[edited by: trillianjedi at 6:19 pm (utc) on June 7, 2005]
[edit reason] No sigs please, as per TOS [/edit]

[coopster]

Welcome to WebmasterWorld, kfreshley.

A very common practice, indeed. Along with the database, you are going to need to use some server-side technology to process the form, read from the database and format the output. PHP, Perl or otherwise.

[kfreshley]

Any advise on where to start, this is my first attempt at this. Thank you.

[coopster]

In the PHP Forum Library [webmasterworld.com] there is a thread detailing the Basics of extracting data from MySQL [webmasterworld.com]. It's a good start.