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

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

  • 1 svar
  • 1 har dette problemet
  • 5 views
  • Siste svar av guigs

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)

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!