Bug #13198 Updated: mysql_query does not understand result resource from "CREATE TABLE" query

ID: 13198 Updated by: sander Reported By: matthew@ectisp.net Old Status: Open Status: Bogus Bug Type: MySQL related Operating System: Linux 2.4.9 PHP Version: 4.0.6 New Comment: Not a bug. CREATE TABLE doesn't return a result-set. Check for errors with mysql_error() and mysql_errno(). Previous Comments: ------------------------------------------------------------------------ [2001-09-07 13:09:52] matthew@ectisp.net oh, and here's the function from my db_tool class: function db_query($query) { return mysql_query($query); } ------------------------------------------------------------------------ [2001-09-07 13:08:03] matthew@ectisp.net 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 this bug report at http://bugs.php.net/?id=13198&edit=1