Windows 10 reached EOS (end of support) on October 14, 2025. For more information, see this article.

Avatar for Username

Search Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

Este fío arquivouse. Faga unha nova pregunta se precisa axuda.

Can I make a database call from within my rss.xml file?

  • 1 resposta
  • 1 has this problem
  • 5 views
  • Last reply by guigs

Chip W
Chip W
more options

I have a rss.xml file for my web site which works just fine, but has to be manually updated each time my web site blog is updated. Is it possible to insert a sql query in my rss.xml file so it can pull the updated info automatically from my mysql db?

I know the rss.xml file will have to be renamed with a .php extension, will it still work?

I have a rss.xml file for my web site which works just fine, but has to be manually updated each time my web site blog is updated. Is it possible to insert a sql query in my rss.xml file so it can pull the updated info automatically from my mysql db? I know the rss.xml file will have to be renamed with a .php extension, will it still work?

All Replies (1)

guigs
guigs
more options

I think this is what you are looking forhttp://dev.mysql.com/doc/refman/5.1/e.../xml-functions.html They are called XML functions that you can set up in an .php file to export the updated file name as rss.xml, though I think it will overwrite anything already in the .xml file.

If you care to dabble, you may already be a master, but there are some cool rss tutorials here http://www.w3schools.com/rss/

Hope this helps!