Help with PHP Code

[rdimaggio]

I want this to display the date/time and author of each article, in my DB the variable names are time and informant, but I cannot get the XML to parse out correctly. Pleas help me add them to the query and output.

here is the PHP code:

<?php 

include("mainfile.php"); 

header("Content-Type: text/xml"); 
$result = sql_query("SELECT sid, title FROM ".$prefix."_stories ORDER BY sid DESC limit 10", $dbi); 
    if (!result) { 
    echo "An error occured"; 
    } else { 
        echo "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>\n\n"; 
    echo "<!DOCTYPE rss PUBLIC \"-//Netscape Communications//DTD RSS 0.91//EN\"\n"; 
    echo " \"http://my.netscape.com/publish/formats/rss-0.91.dtd\">\n\n"; 
        echo "<rss version=\"0.91\">\n\n"; 
    echo "<channel>\n"; 
        echo "<title>".htmlspecialchars($sitename)."</title>\n"; 
        echo "<link>$nukeurl</link>\n"; 
        echo "<description>".htmlspecialchars($backend_title)."</description>\n"; 
    echo "<language>$backend_language</language>\n\n"; 
        for ($m=0; $m < sql_num_rows($result, $dbi); $m++) { 
            list($sid, $title) = sql_fetch_row($result, $dbi); 
            echo "<item>\n"; 
            echo "<title>".htmlspecialchars($title)."</title>\n"; 
            echo "<link>$nukeurl/modules.php?name=News&file=article&sid=$sid</link>\n"; 
            echo "</item>\n\n"; 
        } 
    echo "</channel>\n"; 
        echo "</rss>"; 
    } 

?> 

Thanks!

[rdimaggio]

here is how it displays now: http://ironmagazine.com/backend.php

[herve]

You add what's in red :

$result = sql_query("SELECT sid, title,time,informant FROM ".$prefix."_stories ORDER BY sid DESC limit 10", $dbi);

...

list($sid, $title,$date_time,$informant) = sql_fetch_row($result, $dbi);

...
and then after the line

echo "<title>".htmlspecialchars($title)."</title>\n";

you can add the two lines :

echo "<date>".htmlspecialchars($date_time)."</date>\n";
echo "<informant>".htmlspecialchars($informant)."</informant>\n";

for instance

[rdimaggio]

thanks herve! I got it working.