i have a video database ( mysql / PHP ) and i want to have an xml file to show 10 random videos from the database.
the result xml should look like this
<VIDEO Title="video1" Artist="artist1" />
<VIDEO Title="video2" Artist="artist2" />
<VIDEO Title="video10" Artist="artist10" />
can you help me with the select statement and the echo statemetn?
i am guessing it should be something like
$query = "SELECT * FROM video RANDOM 10";
and we should echo the 10 reslults..
any help is greatlly appreciated.