[Resolved] SQL Query Not Working in PHP

[Avochelm]

Why does the SQL below work fine in the phpMyAdmin console but when I run it below it does not work unless I take away one of the create table commands?

$sql = "create table nnblog_posts
(
id		tinyint(10),
title		varchar(70) null,
date		varchar(20) null,
content		text null,
author		varchar(20) null
);
create table nnblog_users
(
userid		tinyint(10),
rank		tinyint(2) null,
username	varchar(10) null,
password	varchar(30) null,
firstname	varchar(30) null,
lastname	varchar(30) null,
email		varchar(70) null,
location	varchar(50) null,
options		varchar(50) null
);";
mysql_query($sql);

[drawmack]

you can't spserate the queries with a semi-colon in php. put one query into a variable and execute it then put the other query into a variable and execute it.

[Avochelm]

sigh+cry I was afraid of that. I seperated them and they worked, but that is messy. Thanks for explaining why this was happening.

[drawmack]

actually it's not all that messy.

store them in a file exactly as you have them read and write a little function that reads the file into an array and splits to a new array entry everytime it sees a line ending in a ;