Re: Perl DBI

jwlarson3rd, in order to help you at all, we really need to know what the error message is. Which line generated the error? Is there some other code in your script that might be the culprit? You aren't giving us anything to help you with, we're not omniscient (ok, maybe a few of the locals are, but I'm not) here.

One thing I do see with what little scraps you've given us is that you appear to be trying to drop a TABLE named $username which I wouldn't think would be a tablename. Maybe it's something more like $username.$tablename ?

Comment on Re: Perl DBI

Replies are listed 'Best First'.
Re: Re: Perl DBI by jwlarson3rd (Acolyte) on Feb 02, 2004 at 18:06 UTC
Sorry It is a syntax error. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at deleteuser.cgi line 15. `my $sthe=$dbh->prepare("DROP TABLE $username"); $sthe->execute();(line 15)` [download] john larson	[reply] [d/l]