Error with SQL Query

[nigel_belanger]

I have a query that I'm using (CREATE TABLE tablename (field1 tinyint...etc

This query is stored in a file and is opened by my application and ran. I have assigned it to a variable and am echoing it out to validate that I'm not crazy. It will not execute correctly.

This works great when I paste it into the myadmin (from the screen where I have it echo'd - however - it doesn't work when I use the following:

$content="sql statement from file";

$result=mysql_query($content);

Not sure what is going on. I have always thought that if the SQL works when it's pasted into myadmin, it will work fine in the code...

thoughts?...

[khaine]

If you post the code it may be easier to find the problem.

Mark.

[nigel_belanger]

np...

here is the query that is returned:

CREATE TABLE mod_auto ( autoid tinyint(4) NOT NULL auto_increment, userid tinytext NOT NULL, year tinytext NOT NULL, make tinytext NOT NULL, model tinytext NOT NULL, vin tinytext NOT NULL, PRIMARY KEY (autoid) ) TYPE=MyISAM; CREATE TABLE mod_auto_action ( actionid tinyint(4) NOT NULL auto_increment, autoid tinyint(4) NOT NULL default '0', date tinytext NOT NULL, mileage tinytext NOT NULL, invoiceid tinytext NOT NULL, vendor tinytext NOT NULL, action tinytext NOT NULL, PRIMARY KEY (actionid) ) TYPE=MyISAM;

This would be assigned to the string $content

then execute this:

$result=mysql_query($content);

Should work, right? Odd that it doesn't...

[Anon]

Hi Nigel,

Try executing one sql-statement at the time.
I think myadmin splits your query at the semicolon, and executes your queries one by one (just a guess).

Rgds,
Keld List-Jensen.

[nigel_belanger]

Correct - I did them individually and realized that the semicolon was the problem. I just stored the statements into an array, semicolon delimited and executed them (foreach) and it worked fine.

Took a bit, but it's done...

thx