RSS feeds with PHP and MySQL?

[Zenbug]

Does anyone have any good tutorials on how to create a dynamic RSS feed
that pulls data from a MySQL database using PHP? I found this one:
http://www.tiffanybbrown.com/article...article.php/66
....But I haven't quite been able to get it to work.

Thanks.
--ZenBug

[Tim Van Wassenhove]

On 2005-09-06, Zenbug <ze****@gmail.c om> wrote:

Does anyone have any good tutorials on how to create a dynamic RSS feed
that pulls data from a MySQL database using PHP? I found this one:
http://www.tiffanybbrown.com/article...article.php/66
...But I haven't quite been able to get it to work.

At first sight, the article seems pretty clear.
Might want to tell us where exactly you are having problems...

--
Met vriendelijke groeten,
Tim Van Wassenhove <http://timvw.madoka.be >

[Zenbug]

Okay -- I wanted to be sure the question was appropriate for this group
first...

Essentially, I've had to modify the code in order to get any results
When I view my generated RSS feed in an RSS reader, I see a series of
items that are all titled "No Title", and they all contain no content.
I do know that it must be connecting to the database in some way,
because there are as many RSS items as there are news items in my
database. So I guess it's having a problem pulling out actual field
values.

Thanks for the help.
Here's my code as it is now:

<?
header('Content-type: text/xml');
?>

<rss version="2.0">
<channel>
<title>My title</title>
<description> My description</description>
<link>www.mysit e.com</link>
<copyright>copy right information</copyright>

<?
$dbh=mysql_conn ect ("localhost" , "user", "pass") or die ('I cannot
connect to the database because: ' . mysql_error());
mysql_select_db ("myDatabase ");

$getItems="SELE CT id, title, news FROM news ORDER BY id DESC";
$doGet=mysql_qu ery($getItems);

while($item=mys ql_fetch_array( $doGet))
{
$id=$doGet['id'];
$title=($doGet['title']);
$news=($doGet['news']);
?>

<item>
<title><?prin t $title;?></title>
<description><? print $news;?></description>
<link>http://www.littlepilgr ims.ca/</link>
</item>

<? } ?>
</channel>
</rss>

[Malcolm Dew-Jones]

Zenbug (ze****@gmail.c om) wrote:
: Okay -- I wanted to be sure the question was appropriate for this group
: first...

: Essentially, I've had to modify the code in order to get any results
: When I view my generated RSS feed in an RSS reader, I see a series of
: items that are all titled "No Title", and they all contain no content.
: I do know that it must be connecting to the database in some way,
: because there are as many RSS items as there are news items in my
: database. So I guess it's having a problem pulling out actual field
: values.

: Thanks for the help.
: Here's my code as it is now:

: <?
: header('Content-type: text/xml');
: ?>

: <rss version="2.0">
: <channel>
: <title>My title</title>
: <description> My description</description>
: <link>www.mysit e.com</link>
: <copyright>copy right information</copyright>

: <?
: $dbh=mysql_conn ect ("localhost" , "user", "pass") or die ('I cannot
: connect to the database because: ' . mysql_error());
: mysql_select_db ("myDatabase ");

: $getItems="SELE CT id, title, news FROM news ORDER BY id DESC";
: $doGet=mysql_qu ery($getItems);

: while($item=mys ql_fetch_array( $doGet))
: {
: $id=$doGet['id'];
^^^^^^
: $title=($doGet['title']);
: $news=($doGet['news']);
Surely that should be $id=$item['id'], $title=$item['title'], etc.
^^^^^ ^^^^^

Off topic, but I think that <?php tags are prefered. All php servers
suport them, whereas <? only works on some servers, so it's a best habit
to simply use <?php and be done with it.

--

This programmer available for rent.

[Zenbug]

You're right; there was an error in the tutorial. Seems to be working
now.
Thanks again everyone!
--ZenBug
Malcolm Dew-Jones wrote:

Zenbug (ze****@gmail.c om) wrote:
: Okay -- I wanted to be sure the question was appropriate for this group
: first...

: Essentially, I've had to modify the code in order to get any results
: When I view my generated RSS feed in an RSS reader, I see a series of
: items that are all titled "No Title", and they all contain no content.
: I do know that it must be connecting to the database in some way,
: because there are as many RSS items as there are news items in my
: database. So I guess it's having a problem pulling out actual field
: values.

: Thanks for the help.
: Here's my code as it is now:

: <?
: header('Content-type: text/xml');
: ?>

: <rss version="2.0">
: <channel>
: <title>My title</title>
: <description> My description</description>
: <link>www.mysit e.com</link>
: <copyright>copy right information</copyright>

: <?
: $dbh=mysql_conn ect ("localhost" , "user", "pass") or die ('I cannot
: connect to the database because: ' . mysql_error());
: mysql_select_db ("myDatabase ");

: $getItems="SELE CT id, title, news FROM news ORDER BY id DESC";
: $doGet=mysql_qu ery($getItems);

: while($item=mys ql_fetch_array( $doGet))
: {
: $id=$doGet['id'];
^^^^^^
: $title=($doGet['title']);
: $news=($doGet['news']);
Surely that should be $id=$item['id'], $title=$item['title'], etc.
^^^^^ ^^^^^

Off topic, but I think that <?php tags are prefered. All php servers
suport them, whereas <? only works on some servers, so it's a best habit
to simply use <?php and be done with it.

--

This programmer available for rent.