I have a perl script that selects users dial-up usage based on month/year - It works fine, but if the selected month/year does not contain any usage data, the only way I can check is with the following code:
# $sth->execute() # Execute the query $my_result = $sth->execute() # Execute the query or die "Couldn't execute statement: " . $sth->errstr; if ($my_result eq "0E0"){ print "No data is available for the selected time period"; exit(0); } # The select produced results - Read the matching records and print them out while (@data = $sth->fetchrow_array()) { The '0E0' came about by just printing the result of $my_result during successful/non-successful selects. I'm sure there is a more elegant way to check if a select statement results in success or not. Regards, Michael Debian Linux 2.2, mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686) --------------------------------------------------------------------- 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