#1 (permalink)

Hi. I want to have a webpage that will have the results of a MySQL lookup in it. Basically I want to query a database table, grab the top 5 results (after sorting), and display those on an HTML page.

I have the MySQL code working, but I'm not sure how to integrate this in to an HTML page. I don't want to use SSI as I'd need to rename all my pages to .shtml, which doesn't work for my setup. I also would rather not call a CGI to generate the HTML as this is also not consistant with my site's set up. Is there a way to include these inside the HTML, or perhaps I could have a script which generates a page that gets included into this HTML?

Thanks a lot.

david
http://www.picturesofsoup.com

#2 (permalink)

First of all, I think this thread should have been started in the "PHP and MySQL" Forum, but anyways...

Any page that you wish to integrate PHP in should be a .php file, so if you're trying to execute a PHP script in a .htm file, its not going to work, your server won't know to parse the the PHP and it will just spit out the code when you view the page.

As for displaying the results of your MySQL query, just loop through the query result and display the data however you would like. You said the query part of your script is already working so where are you executing that from?

If you need a code sample let me know.

#3 (permalink)

Ah, thanks. It seems like I'll have to reconfigure my server setup since PHP really is the way to go. Thanks for the help.