skimsurf4

the members table in the database has currently 18 members. the php/sql will supposedly, if the coding works, write every members name, phone#, and address to the html template that will be displayed on a webpage. until i update the members table in the database (add or delete), it will only display the current 18 members on the website.

this is the answer i was looking for. can you expand on it a little more? like what is the php code to load the entire contents of the html template? i could assign the id values in my template like this... [:memberName:] [:memberPhone:] [:memberAddress:]

Let's say from the php page, I have a sql that selects from the members table in the database: mem_name, mem_phone, and mem_address. How do I write the php code to display the 3 fields to a html web page? Let's called the php page, select.php and html page output.html.

Yes, I do know that I can embed the html in the php page. But I'm trying to keep the html template (Frontpage-WYSIWYG) design page separate from the php page. The main reason behind this is so that I can still be able to use the Frontpage WYSIWYG design template. If i combine the html into the php page and save it as php file, the html design page is no longer available.

updates to the database is very minor and quickly published to the live server after making changes on the fly.

html page is the template page where the php page connects to the database and runs the sql statement to retrieve the data to display to the html(template) page. yes, the html page will always display the same information. it will only change when there is an update to the database. i like to know the syntax how to write this bit of code.

I have created an Access database with base and query(view) tables. I know that I can run php/sql against the base tables and retrieve data for output. But, can I do the same against the query tables?

hi, i have a php page called select.php that connects and retrieves data from a database. now, how do i write that result to a html page called output.html?