Hi,

would anyone know how I can use javascript to show recent submissions on the index.html page of my short story site? All stories are held in a mySQL database, but I don't want to change the page from html to php or pl etc.

I want to just have a small section showing 5 most recent submissions (title, author, genre), but don't know where to start! (can you tell I'm a beginner )


Any ideas?


Marc

It would be more efficient to just use PHP to grab the latest submissions. If you use Javascript, you will need to use PHP to generate a Javascript file (this, two "actions" instead of one).

Originally Posted by Chroder

It would be more efficient to just use PHP to grab the latest submissions. If you use Javascript, you will need to use PHP to generate a Javascript file (this, two "actions" instead of one).

Is PHP simple enough to embed in an HTML page though?

How are you getting articles from a mySQL database via a static HTML page? Or do you just have a story "section" and everything else is powered by PHP/mySQL?

If you do need it to access it via a HTML page then, yes, your right, you'll need to use Javascript. You can generate Javascript with PHP and include:

<script language="javascript" src="generate_stories.php"></script>

It's kinda hard to say what code you'll need without knowing how you handle the articles.

the stories themselves are displayed using Perl scripts (eg short-story.net/story.pl?s=35), but all I am wanting to do is display "title, author, genre, rating" on the main page as links etc.

If it's a difficult task, I may just update the links manually and work something into the second version of the site that is currently being worked on!

Thanks for the input, by the way