php mysql_query() issue

[uk_viper]

ok been doing some simple php stuff trying to get a script to import an .sql file from the directory it's inside the error we're getting is "No input file specified."

Suggestions?

<?php 
error_reporting(E_ALL);
include_once '../db.php';
// Perform Query
$result = mysql_query(source './account.sql');
echo($result);
}
?>

 

[Dj_Jestar]

source = ?

 

[uk_viper]

in ssh source is used to excute an sql file, basically i need it to install an sql file into a database

 

[Dj_Jestar]

but in php it contains what value? (assuming it is a constant and not a typo'd variable - $source)

 

[trickards]

I have never seen mysql_query() used like this. Personally, post mysql_connect i declare all the sql in variables which i then call inside mysql_query();

I can't see mysql_query() working with two words seperated with a space and no quotes surrounding it. How i would suggest you run it is mysql_query('source codelocation.sql');

Hope this helps.

 

[robmiller]

You pass an SQL query to mysql_query, not a filename.

 

[Inquisitor]

in ssh source is used to excute an sql file, basically i need it to install an sql file into a database

This is PHP, though, not SSH :/