StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POPHP RSS not parsing at line 55
primarykey
Id
964179
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2009-06-08T10:08:01.127
FavoriteCount
0
LastActivityDate
2011-09-16T13:49:14.100
LastEditDate
2011-09-16T13:49:14.100
LastEditorUserId
1288
OwnerUserId
108528
ParentId
0
PostTypeId
1
Score
0
ViewCount
410
LastEditorDisplayName
text
Body
Hi I wonder if anyone can help with this code. I am trying to show the records from a URL table for a category, eg url_category_id = to 1. where the url and category is the same in the associating table. I am having some issues with this rss as it has a parse error on line 55. I have tried to resolve the issue but without avail. <pre><code> <?php $db = new mysqli("Host", "USER", "PW", "DB");?> <?php header('Content-type: text/xml'); ?> <?php echo "<?";?>xml version="1.0" encoding="iso-8859-1"<?php echo "?>";?> <rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom"> <channel> <title>My TITLE</title> <description>My DESCRIPTION</description> <link>www.MyWeb</link> <copyright>C) 2009 All Rights Reserved</copyright> <atom:link href="http://source of feed" rel="self" type="application/rss+xml" /> <?php $query = 'SELECT * FROM url_categories WHERE url_category_id= $type'; $result = mysql_query ($query); if (isset($_GET['type'])) { $type = (int) $_GET['type']; } else { $type = 3; } if ($type > 0) { // Get the current type name. $query = "SELECT category FROM url_categories WHERE url_category_id=$type"; $result = mysql_query ($query); list ($category) = mysql_fetch_array ($result, MYSQL_NUM); $first = TRUE; // Initialize the variable. // Query the database. $query = "SELECT u.url_id, url, title, description, pub_date, STR_TO_DATE(pub_date, '%d-%b-%Y') AS sortdate, DATE_FORMAT(STR_TO_DATE(pub_date, '%d-%b-%Y'), '%d.%b.%Y') FROM urls AS u, url_associations AS ua WHERE u.url_id = ua.url_id AND ua.url_category_id=$type AND ua.approved = 'Y'ORDER BY sortdate DESC"; $result = mysql_query ($query); $num_records = mysql_num_rows($result); $number = $results->num_rows; for ($i = 1; $i <= $number; $i++) { $row = $results->fetch_assoc(); $title = $row['title']; $description = $row['description']; $url = $row['url']; $date = $row['sortdate']; ?> <item> <title><?php echo $title; ?></title> <description><?php echo $description; ?></description> <link><?php echo "http://";?><?php echo $url; ?></link> <guid><?php echo "http://";?><?php echo $url; ?></guid> <pubDate><?php echo date("D, d M Y H:i:s O", strtotime($date)); ?></pubDate> </item> <?php } ?> </channel> </rss> <?php $db->close(); ?>//This is the parse error line </code></pre> I would be grateful for any assistance in trying to resolve this issue. <hr> All I am receiving is parse error on line 52 and if I alter it I get parse error on line 55 .. no reason as to the error, but I have noticed the code section isn't recognising it as php in this post. Sorry I can't offer anything further.
Tags
<php><mysql><rss>
Title
PHP RSS not parsing at line 55
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USBill the Lizard
UserOwnerUserId
1. USDdywalgi
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COYeah, an error would be great. :)
 singulars
 PostPostId
 POPHP RSS not parsing at line 55
 UserUserId
 USChristian

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.