[PHP-DEV] Bug #13198 Updated: mysql_query does not understand result resource from "CREATE TABLE" query

2001-09-07 Thread sander 

ID: 13198
Updated by: sander
Reported By: [EMAIL PROTECTED]
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] [EMAIL PROTECTED]

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] [EMAIL PROTECTED]

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


-- 
PHP Development Mailing List 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DEV] Bug #13198 Updated: mysql_query does not understand result resource from "CREATE TABLE" query

2001-09-07 Thread matthew 

ID: 13198
User updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
Status: Open
Bug Type: MySQL related
Operating System: Linux 2.4.9
PHP Version: 4.0.6
New Comment:

oh, and here's the function from my db_tool class:

 function db_query($query) {
return mysql_query($query);
}

Previous Comments:


[2001-09-07 13:08:03] [EMAIL PROTECTED]

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


-- 
PHP Development Mailing List 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]