create tables/insert data via sql file using php

[bluns]

Hi guys, i am trying to make a php script to create tables and insert data into my mysql database via a php script.

heres what i have so far

if($create_tables==yes) 

{ 

$fp = @file($root_dir."/xxxxxx.sql"); 

if(!$fp) 

{ 

$error = "Could not open $root_dir/xxxxxxx.sql.<br> 

     Please ensure file is uploaded with correct permissions"; 

 } 

//elseif($fp) you don't need this 

else { 


mysql_query($fp) or die("error: ".mysql_error()); 

} 

} 

However this does not work :*(

anyone know how i can get this to work?

[devinemke]

[man]file[/man] returns an array, not a string, and as such cannot be fed directly into [man]mysql_query[/man]. you should use [man]file_get_contents[/man] instead.