Hi, I am using mod_perl and MySQL 3.23.38 on Red Hat Linux 6.2 and my following codes occasionally got an error. $SQL = 'SELECT col1,col2 FROM table1'. ' WHERE keya=1 AND keyb=2'; $STH = $DBH->prepare($SQL) || die $SQL; if ($STH->execute() >= 1) { $rec = $STH->fetchrow_hashref; $STH->finish(); } The error was: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at program-name line ####. It only happened once in a few dozen transactions. If anyone knows the cause of this and knows the solution for it, please let me know. Thank you very much in advance. Truoc Duong. __________________________________________________ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ --------------------------------------------------------------------- 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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php