FeedForAll Forum Index  
 Home  •  FAQ  •   Search   •  Register   •  Profile   •  Log in
Search found 4 matches
Author Message
Topic: Clickable URL
crjensen

Replies: 3
Views: 10455

PostForum: SQL2RSS (MySQL to RSS Feed Creator)   Posted: Thu Apr 14, 2011 8:47 am   Subject: Clickable URL
I know, I have the SQL2RSS script already. What I would like to know is what to do to insert a field from the database containing a URL and make it click-able.
Topic: Clickable URL
crjensen

Replies: 3
Views: 10455

PostForum: SQL2RSS (MySQL to RSS Feed Creator)   Posted: Thu Apr 14, 2011 5:14 am   Subject: Clickable URL
Ok, every table row in my mySQL database ends with a database field containing a URL. I want it so that when people read the RSS feed the last thing they see is that URL, and I want them to be able to click that URL so it opens a webbrowser.
Is that posssible?
Topic: Beginner help
crjensen

Replies: 1
Views: 7676

PostForum: SQL2RSS (MySQL to RSS Feed Creator)   Posted: Thu Apr 14, 2011 3:16 am   Subject: Re: Beginner help
Never mind. I found the solution myself...
:-)

So, I just bought and installed SQL2RSS and wanted to test it.

When I run the script after configuring it I get a blank page, except for the channel title and date.
What am I doing wrong?
In the configuration I am calling a specific table in my database and I have set debuglevel to 3:

****************
$debugLevel = 3;

//
// $SQLQuery is a valid database query for your database
$SQLQuery = "SELECT * FROM nynyhjemmeside_content";
****************

This is what I get in the browser when I run the script with debugging (http://www.riisjensen.dk/sql2rss/sql2rss.php?CONFIGFILE=nykonfiguration.php).

As you can see just a blank page, except for the channel title and date:

SUCCESS: mysql_connect(localhost, ********, ********)
SUCCESS: mysql_select_db(riisjensen_dk)
SUCCESS: FeedForAll_database_query($config, SELECT * FROM nynyhjemmeside_content)

<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
<channel>
<title>Bibelnoeglen</title>
<link>http://www.blr.dk/</link>
<generator>FeedForAll-scripts (sql2rss.php), http://www.FeedForAll.com/, Copyright 2006-2007, NotePage, Inc.</generator>
<lastBuildDate>Thu, 14 Apr 2011 06:39:40 +0000</lastBuildDate>
<pubDate>Thu, 14 Apr 2011 06:39:40 +0000</pubDate>
<item>
<title></title>
<link>http://www.riisjensen.dk/index.php</link>
<description></description>
</item>
<item>
<title></title>
<link>http://www.riisjensen.dk/index.php</link>
<description></description>
</item>
<item>
<title></title>
<link>http://www.riisjensen.dk/index.php</link>
<description></description>
</item>
<item>
<title></title>
<link>http://www.riisjensen.dk/index.php</link>
& ...
Topic: Beginner help
crjensen

Replies: 1
Views: 7676

PostForum: SQL2RSS (MySQL to RSS Feed Creator)   Posted: Thu Apr 14, 2011 1:49 am   Subject: Beginner help
So, I just bought and installed SQL2RSS and wanted to test it.

When I run the script after configuring it I get a blank page, except for the channel title and date.
What am I doing wrong?
In the configuration I am calling a specific table in my database and I have set debuglevel to 3:

****************
$debugLevel = 3;

//
// $SQLQuery is a valid database query for your database
$SQLQuery = "SELECT * FROM nynyhjemmeside_content";
****************

This is what I get in the browser when I run the script with debugging (http://www.riisjensen.dk/sql2rss/sql2rss.php?CONFIGFILE=nykonfiguration.php).

As you can see just a blank page, except for the channel title and date:

SUCCESS: mysql_connect(localhost, ********, ********)
SUCCESS: mysql_select_db(riisjensen_dk)
SUCCESS: FeedForAll_database_query($config, SELECT * FROM nynyhjemmeside_content)

<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
<channel>
<title>Bibelnoeglen</title>
<link>http://www.blr.dk/</link>
<generator>FeedForAll-scripts (sql2rss.php), http://www.FeedForAll.com/, Copyright 2006-2007, NotePage, Inc.</generator>
<lastBuildDate>Thu, 14 Apr 2011 06:39:40 +0000</lastBuildDate>
<pubDate>Thu, 14 Apr 2011 06:39:40 +0000</pubDate>
<item>
<title></title>
<link>http://www.riisjensen.dk/index.php</link>
<description></description>
</item>
<item>
<title></title>
<link>http://www.riisjensen.dk/index.php</link>
<description></description>
</item>
<item>
<title></title>
<link>http://www.riisjensen.dk/index.php</link>
<description></description>
</item>
<item>
<title></title>
<link>http://www.riisjensen.dk/index.php</link>
<description></description>
</item&g ...
 

 Jump to:   


Powered by phpBB © 2001, 2002 phpBB Group :: FI Theme