Off-Topic Discussion => General Discussion => Topic started by: vyper on July 11, 2005, 01:16:37 pm
Title: PHP fans... I need you [and CSS fans!]
Post by: vyper on July 11, 2005, 01:16:37 pm
Alright let's see... I'm trying to create an RSS feed. Right now, the php file that generates it looks thusly:
header('Content-type: text/xml', true); $link =insert sensitive password stuff here
$sqlquer = sprintf("SELECT * FROM Content ORDER BY id DESC"); $result=mysql_query($sqlquer); $nRows = mysql_num_rows($result); ?>
CaledonianEnterprise
[url]http://www.CaledonianEnterprise.co.uk[/url]
To entertain the masses Copyright 2005
for ($i=0; $i< $nRows; $i++){ $row = mysql_fetch_object($result);?>
echo"$row->Title"; ?> echo"$row->Article"; ?>
}?>
Now the output looks like: http://www.caledonianenterprise.co.uk/rss2.php
Unfortunately when I call it up in Thunderbird as a news feed, all I get is one news item (Drop-In) and it's blank!
Any ideas?
edit: god damned PHP and CODE tags made half the rss code vanish
Title: PHP fans... I need you
Post by: WMCoolmon on July 11, 2005, 03:47:48 pm
Yeah, BBs suck for posting HTML code.
I can't see anything wrong with the generated output, I expected to find a non-closed tag someplace, but couldn't. Maybe there's an errant caret or something in one of the posts that's screwing things up?
Title: PHP fans... I need you
Post by: Taristin on July 11, 2005, 09:41:50 pm
Title: PHP fans... I need you
Post by: Admiral LSD on July 12, 2005, 06:28:58 am
errm, what's supposed to be wrong with it again? Works perfectly for me in Opera 8.02...
Title: PHP fans... I need you
Post by: vyper on July 12, 2005, 07:09:04 am
Mine or his? Basically mine will not display in Thunderbird properly. It works in SharpReader bar a small character error.
Title: PHP fans... I need you
Post by: Admiral LSD on July 12, 2005, 07:14:57 am
Yours. I went to the RSS link you provided, Opera detected it was an RSS feed and prompted me to subscribe which I did and then it presented me with the usual email-style view of what I presume is the full feed:
Title: PHP fans... I need you
Post by: vyper on July 12, 2005, 08:40:22 am
Thanks man, it means I'm doing something right! :D
Must be a Mozilla specific bug...
Title: PHP fans... I need you
Post by: Taristin on July 12, 2005, 09:25:00 am
Mine just got completely rewritten, but thanks.
*just started learning PHP 2 days ago*
Title: PHP fans... I need you
Post by: vyper on July 12, 2005, 10:09:32 am
Alright, anyone know why my CSS coded background image will sit properly in I.E.6 (fixed attatchment) but seems to shift about 50px up the way in Firefox?
Title: PHP fans... I need you
Post by: Taristin on July 12, 2005, 10:15:13 am
Is the position hard coded, or relative?
Title: PHP fans... I need you
Post by: vyper on July 12, 2005, 10:18:26 am
The position of the layer is relative to the larger containing div that holds all in creation. The div itself is not moving, otherwise the text would be skew-if. So I'm stumped.
Title: PHP fans... I need you
Post by: Taristin on July 12, 2005, 03:23:53 pm
I was reading through the template that I used for my site, and the author said that the code he used was initially set to relative, but doing so didn't cooperate, so he had to settle for hard coded.