Wondering if someone would be able to help me...
I have this MYSQL select statement that I would like to be able to use to generate a RSS from that has a variable at the end of the URL that would be used as a part of the statement.
Example of what I mean here is;
I would like the end user to be able to put in a URL like this
with % being the obvious variable.. Now when the user enters that, I would like this script to generate the RSS and then display the generated results from this select statement.
SELECT b.bossname, b.instancename, k.dateentered FROM kills k LEFT JOIN bosses b ON k.bossid = b.bossid LEFT JOIN guilds g on k.guildid = g.userid
WHERE g.guildname = '%'
AND b.activeind = 1
ORDER BY dateentered DESC LIMIT 10
Is anyone able to help me out here? point me in the right direction or show me how its done? - I am very new when it comes to RSS and XML =)