php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #13198 mysql_query does not understand result resource from "CREATE TABLE" query
Submitted: 2001-09-07 13:08 UTC Modified: 2001-09-07 14:29 UTC
From: matthew at ectisp dot net Assigned:
Status: Not a bug Package: MySQL related
PHP Version: 4.0.6 OS: Linux 2.4.9
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: matthew at ectisp dot net
New email:
PHP Version: OS:

 

 [2001-09-07 13:08 UTC] matthew at ectisp dot 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);

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-09-07 13:09 UTC] matthew at ectisp dot net 
oh, and here's the function from my db_tool class:

 function db_query($query) {
                return mysql_query($query);
        }
 [2001-09-07 14:29 UTC] sander@php.net 
Not a bug. CREATE TABLE doesn't return a result-set. Check for errors with mysql_error() and mysql_errno().
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Tue Sep 17 20:01:27 2024 UTC