PHP date field to RSS style date

[NDK1971]

Hi. I have my database feeding to an RSS feed now. But one thing I can't get right is the date.

MySQL date field is called "date" and the value is stored like: 20090713 or 20100623

How do I change that to the acceptable RSS pubDate format?

Help!

[halojoy]

rss <pubDate>Thu, 27 Apr 2006</pubDate>
to convert your string

<?php

$mysql_date = "20090713";

$rss_date = date("D, d M Y", strtotime($mysql_date));

echo $rss_date;

?>

[NDK1971]

That helps a lot but where would I put this code? I've highlighted in RED where I thought it would go but it doesn't seem to be right.

---

<?php

include('connection/my_connect.php');

$detailsTable = "news";

$sql_select="select * from news";

$result=mysql_query($sql_select);

$today=date("Y-m-d");

?>

<?php header("Content-Type: application/xml; charset=ISO-8859-1"); ?>

<?php echo "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>"; ?>

<rss version="2.0">

<channel>

<title>My Website</title>

<description>My Website Description.</description>

<pubDate>Thu, 27 Apr 2006</pubDate>

<link>http://www.vegasauditions.com</link>

<?php while($item = mysql_fetch_array($result)) {

$mysql_date = $item['date'];

$rss_date = date("D, d M Y", strtotime($mysql_date));

?>

<item>

<title><?php echo "TITLE: ".$item['new_word'].' '.$item['show_name']?></title>

<description><?php echo "Company: " .$item['company']."&lt;br&gt; Location: ".$item['audition_city']?></description>

<pubDate><?php echo [COLOR="Red"]$rss_date[/COLOR] ?></pubDate>

<link>http://www.mywebsite.com</link>

</item>

<?php } ?>

</channel>

</rss>

[Installer]

RSS dates should conform to RFC 2822:

Thu, 4 Feb 2010 11:58:00 -0500
or
Thu, 4 Feb 2010 11:58:00 EST

$rss_date = date('r', strtotime($mysql_date));

Where you have the code looks correct.