[SOLVED] file_get_contents help

[EP]

Hey guys.  I need a little help here.

 

I have a program that spits out a text file with a complete INSERT query to insert data into a mysql database.  After the text file is updated, this php file is supposed to be run using GET instead of POST so it can take the new info from the file and run the command.

 

I tried to call the file up in a web browser and checked the database but it was not updated.

 

Here is the code:

<?

mysql_connect("localhost", "root", "password");
mysql_select_db("database");

$file=file_get_contents("output_file.txt");


mysql_query($file);


mysql_close();
?>

 

 

The final mysql_query result should be something like...

mysql_query("INSERT INTO table VALUES ('value1', 'value2', 'value3', 'value4')");

 

..because that's what the text file contains.

 

 

I don't understand what I am doing wrong.  Any help would be appreciated.

[trq]

Can we see the exact contents of the text file?

[EP]

Ok.

 

" INSERT INTO table VALUES ( 'title', 'artist', 'album', '2008/07/15 03:10:17' ) "

[trq]

Remove the surrounding double quotes so the text file simply reads....

 

INSERT INTO table VALUES ( 'title', 'artist', 'album', '2008/07/15 03:10:17' )

[EP]

Still doesn't work.  :'(

[trq]

What does this ouput?

 

<?php

mysql_connect("localhost", "root", "password");
mysql_select_db("database");

$sql = file_get_contents("output_file.txt");

if (mysql_query($sql)) {
  echo "Success";
} else {
  echo mysql_error() . "<br />$sql";
}

?>

[EP]

Output:

 

$sql"; } ?>

[trq]

Did you use the full <?php as I showed?

[EP]

Oops.

 

Ok, it shows success and the database was updated.

 

 

Thanks alot man. 

[trq]

A lesson learnt. Do not use <? tags.