From:             [EMAIL PROTECTED]
Operating system: Linux 2.4.9
PHP version:      4.0.6
PHP Bug Type:     MySQL related
Bug description:  mysql_query does not understand result resource from "CREATE TABLE" 
query

Basically this code will return this error:
Warning: Supplied argument is not a valid MySQL result resource in
/var/lib/apache/htdocs/mailtest/class.db_tool.inc.php on line 35


$tblname = "mail_" . $user_id;

$query = "CREATE TABLE $tblname (id int(11) NOT NULL auto_increment, folder
varchar(255) default NULL, user_id int(11) default NULL, uidl varchar(255)
NOT NULL default '', tos text, froms text, subject text, is_mime tinyint(1)
default NULL, was_read tinyint(1) default NULL, acc_id int(11) default
NULL, mail longtext, date varchar(14) default NULL, priority tinyint(4)
default '0', from_name text, PRIMARY key (id), KEY uidl(uidl))";

$res = $this->db_tool->db_query($query);
-- 
Edit bug report at: http://bugs.php.net/?id=13198&edit=1


-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to