if ( $cgi->param ) { $sortby = defined ( $cgi->param( 'sortby' ) ) ? $cgi->param( 'sortby' ) : "name"; $ascdesc = defined ( $cgi->param( 'ascdesc' ) ) ? $cgi->param( 'ascdesc' ) : "desc"; $letter = defined ( $cgi->param( 'letter' ) ) ? $cgi->param( 'ascdesc' ) : " "; ownertbl( $sortby, $ascdesc, $letter ); #### [Sat Oct 16 11:04:23 2010] [error] [client 192.168.15.177] DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE name LIKE '%'' at line 3 at /var/www/cgi-bin/ownertbl.pl line 76., referer: http://192.168.15.222/cgi-bin/ownertbl.pl [Sat Oct 16 11:04:23 2010] [error] [client 192.168.15.177] DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /var/www/cgi-bin/ownertbl.pl line 79., referer: http://192.168.15.222/cgi-bin/ownertbl.pl [Sat Oct 16 11:04:23 2010] [error] [client 192.168.15.177] base = http://192.168.15.222/cgi-bin/ownertbl.pl, sort = ORDER BY name, sortby = name, ascdesc = , letter = WHERE name LIKE '%', referer: http://192.168.15.222/cgi-bin/ownertbl.pl