Dont know whats wrong..

[MrCraig]

Im making a script that automatically resets the HabboSoft UserSystem!

So far, i have this code



<?php
require("config.php");
$dump = @file_get_contents("SQL.txt");
mysql_query($dump);
?>
The SQL.txt file is CHMODDed to 0644

And ive tried running the file in phpmyadmin seperately and it works fine, however, the script doesnt affect the database at all. It just seems to do nothing.

Ive tried print_r'ing the $dump variable and all the SQL is there.

Any suggestions?

Moved by Agesilaus (Forum Moderator) from Designing & Development: Please post in the correct forum next time. :)

[Baving]

Try using file() instead of file_get_contents

[MrCraig]

Made no difference :S

[Baving]

If it is a static file why not just post the SQL into a variable? Then you won't have to mess about with file handling

[MrCraig]

Well surely using


file_get_contents();


OR



file();


is the same as posting it into a variable, without the need to worry about backslashing quotations.?

[Assassinator]

Try having


<?php
include; ("config.php");
$dump = @file_get_contents("SQL.txt");
mysql_query($dump);
?> </span> </span>

[Flisker]

why did you put a ; after include???



<?php
include("config.php");
$dump = @file_get_contents("SQL.txt");
mysql_query($dump);
?>

There sorted Kane's error xD

[MrCraig]

is that not the same as what i posted first..? :S