...

View Full Version : Xml in php



Andy92
03-30-2007, 10:43 PM
Hi there,

Is there any way to insert xml in php, and make xml titles variables?

:confused:

aedrin
03-30-2007, 11:02 PM
http://us2.php.net/manual/en/ref.xml.php

Andy92
03-31-2007, 02:12 AM
Ok,

Here is what i have...



<?
header("Content-type: text/xml");
echo "<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>";

mysql_connect("localhost", "username", "password") or die(mysql_error());
mysql_select_db("database") or die(mysql_error());

echo '<rss version="2.0">';

echo '<channel>
<title>Allsortgroup Blog</title>
<description>The allsortgroup blog rss feed!</description>
<link>http://www.allsortgroup.com/blog/group</link>';

$data = mysql_query("SELECT * FROM blog LIMIT 30");

while($row = mysql_fetch_array($data)) {

echo '<item>
<link>http://www.allsortgroup.com</link>
<title>'.$row['title'].'</title>
<description>'.$row['mini'].'</description>
</item>';

}

echo '</channel></rss>';
?>


All is working fine at...

http://www.allsortgroup.com/feed.php

But, when i change the limit from 30 to say 50, the content goes black and only the title and description is there. Also, is does this also what i add in ORDER BY id DESC.

Does anyone know why?



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum