cron job to create csv file

[AndrewSimm]

I use the word links gold mod and would like to have a cron job that creates a csv file. The SQL is the following for the mod.

SELECT title, entryid
FROM `adv_dyna_entries`
WHERE 1


I then need it to build a csv file that looks like

title, http://www.website.com/entries/category/title-entryid