Hi! I have a small problem:
a have a database containing three fields number, timestamp, used i allready inserted into the "number" fileds about 50.000 random and unique numbers - timestamp and used are empty With my perl script i have to do the following: look into the database for the first entry with having timestamp and used empty then updating the timestamp field with the actual date. My script then in addtion presents the number to the customer via webinterface. the next time i run the script the same procedure must be repeated, so finding the first empty entry (empty timestamp field) and then updating this filed with a timestamp. How can i realize this with using perl ? Any advice? How to connect to database using perl i allready know but iam trying to find out how manage this small problem the most easy way... Thanks in advance Sascha sql,query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php