Creating a page that pulls from a table

[jbnicholas]

I want to create a page that will dynamically pull information from a single
table when querried by a single record. I don't want it to display any of the
table data until it is querried. I don't know how well I'm explaining this, but
a perfect example of what I want to do is here -> [url]www.blincinc.com/database.asp[/url]
.. Try searching 22033.

That page was done with front page and access without having any very
technical knowledge. What is the easiest way for me to make a page like that
with dreamweaver? (I have access to access and excel, but let me know if I have
to use any other programs.)

[MrBonk]

You need to be able to write a query using whatever server language your site is using (eg. ColdFusion) to do this. Do you know what language it is?

[jbnicholas]

PHP is enabled. But I'm sure I'm able to use just about anything else. I'm a lil familiar with PHP, but I'd just like to use whatever is easiest.

[MrBonk]

Hehehehe......easy is all relative :) If you know PHP and want to stick with
that, then there's definitely someone in here who will be able to tell you what
you need for that. I don't know PHP, so I can't help with the PHP specifics.

But, the basic approach is to create a query, then use the results of that
query to fill your table. Say you have a table called 'details' that has the
fields 'name' and 'town' and you're using a form to get the variable you're
going to use for the query. You might write SQL like:

SELECT *
FROM details
WHERE town='#form.town#'

The actual construction of the query will be language specific though, so
whatever language you're using will determine how you put that SQL into the
rest of the code.

Same deal for the results. You put the output of the query into the <td> tags
of your table.....again, how you do this is language specific.