problems sending a text file to mysql

kazlar

hi,
i got a small problem while executing a sql statement.
my code is:

$filename = "sql_create.txt";
$file = fopen($filename,"r");
$str = "";
while (!feof($file))
$str .= fgets($file, 512);
fclose($file);
mysql_query($str ,$db) or die ("ERROR");

and the text file looks like this

DROP TABLE IF EXISTS xref_system_design;
CREATE TABLE xref_system_design (
design_id int(4) unsigned NOT NULL default '0',
system_id int(4) unsigned NOT NULL default '0',
name varchar(20) default NULL
) TYPE=MyISAM COMMENT='Zuordnung Design zu Name';

--------------------------------------------------------

the database connection is alright and when i copy the statement into phpmysql it works fine.

but not in the php-page
what's wrong?

daarius

output mysql_error(); see what it says.

kazlar

hmm, it seems, that mysql can't handle the ';' after the drop statement, cause it writes out a syntax error...

DROP TABLE IF EXISTS design;
CREATE TABLE design (...

but how can that be?
as i said, when i copy the code into phpmysql it works without any problems
also there is this semicolon too

kazlar

ah, ok
i found the problem
first the tool is phpmyadmin, no phpmysql ;-)
with mysql_query() you can only send ONE statement to the database.
the textarea from phpmyadmin is getting parsed after submit, so that every statement is send in an own mysql query.
so i just have to parse the file, find all semicolons and send the single statements to the database.
thanks for your help

kazlar