ID: 16277
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
-Status: Bogus
+Status: Open
Bug Type: MSSQL related
Operating System: NT4
PHP Version: 4.1.2
New Comment:
RTFBR ;) it is MS SQL, not mySQL
Previous Comments:
------------------------------------------------------------------------
[2002-03-26 08:01:58] [EMAIL PROTECTED]
RTM! You can only run one query per call to mysql_query()!
------------------------------------------------------------------------
[2002-03-25 22:49:13] [EMAIL PROTECTED]
I am creating tables and indexes in a few places. To make life a
little easier I want to create a table and it's indexes in one go.
The following code fails:
----
$queries[0]["query_string"]="CREATE TABLE objects (
[id] integer IDENTITY (1,1) PRIMARY KEY,
[type] varchar(16) DEFAULT '' NOT NULL,
[object] text,
[vtype] varchar(16) DEFAULT '' NOT NULL,
[lastchanged] TIMESTAMP);
CREATE INDEX objects_lastchanged ON objects (lastchanged);";
$queries[1]["query_string"]="CREATE TABLE nodes (
path varchar(127) DEFAULT '' NOT NULL PRIMARY KEY,
parent varchar(127) DEFAULT '' NOT NULL,
object numeric(11) DEFAULT '0' NOT NULL,
priority numeric(11) DEFAULT '0' NOT NULL
);";
while ((list($key, $query)=each($queries)) && (!$error)) {
echo $query["query_string"];
$exec=mssql_query($query["query_string"]);
}
----
But if I separate out the create index into a separate query it works
fine.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=16277&edit=1
