I have a table called "tDates" in which I stored dates. The field that holds the date is called "Day_Date" (date result)

I need to create a STORED PROCEDURE in mySQL that I can specify the YEAR and it will:

Check if any dates in that year are already existing - if so generate a ERROR.

If they are not existing, create ONE RECORD for each day in that year.

If you can, please include the mySQL procedure code and the PHP that would call it.

Appreciate any help that be offered.

Don Wieland
D W   D a t a   C o n c e p t s
Direct Line - (949) 305-2771

Integrated data solutions to fit your business needs.

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to