Dan wrote:
> I've managed to get SQL working now. Just one query. How can I get perl to
> create a new table? I have the table's name set in $acctab, this is what i
> have, but it doesn't work.. how so?
what's the error? any error message? perhaps you don't have permission?
>
> my $sth = $dbh->prepare(" CREATE TABLE $acctab ( uid mediumint(10) NOT
> NULL, nick varchar(30) NOT NULL, ulevel tinyint(3) NOT NULL, slevel
> tinyint(3) DEFAULT '0' NOT NULL, aop tinyint(1) DEFAULT '0' NOT NULL,
> greet text, PRIMARY KEY (uid) ) ");
> $sth->execute;
try:
$sth->execute or die $dbh->errstr;
to see what's wrong with it
david
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
