Hi All, I'm very much a newbie and only really experimented with inserting/selectign data etc, a simple project I would like do have a script to email me the entrys from a database every day. But bit unsure where to start I can select the data fine using a simple query, not sure how to format it or should I first look at making PHP send me something first? Any help gratefully recieved I havent found any similar tutorials online to help guide me.
First of all, we'll probably need some more information... Let me get this right, you would like to get an email every day that show's you the new records for the previous day, or something like that. Does each record in your database table have a date/time field which is when that record was created? If it does, you should be able to do a simple query to return records with a specific date. You can use PHP to create a nicely formatted list of records and email it to yourself. The php script could then be executed every night via a cron job.