Output of SQL query as variable PHP

manpreet Best Answer 2 years ago

I have a PHP script that connects to one of my SQL databases and runs a select command. I'm then trying to see what the output is of command but when I f="https://forum.tuteehub.com/tag/echo">echo my results to a file I get "Resource id #f="https://forum.tuteehub.com/tag/5">5" and not a path like I'm expecting. Can anyone tell me where I'm going wrong, I suspect it is the query or the result variable but I'm pretty new to php.

$connection = mysql_connect("127.0.0.1", "user", "f="https://forum.tuteehub.com/tag/password">password");

if(!$connection) {
    system("f="https://forum.tuteehub.com/tag/echo">echo 'ERROR! Unable to connect to MYSQL' >> /Reports/sqlerror");
}

$dbselect = mysql_select_db("mydatabase");


$query = "select p.path from path as p f="https://forum.tuteehub.com/tag/join">join file as f on p.pathid=f.pathid where f.filename like '$xfilename' and p.path like '/Data/original%'";

$result = mysql_query($query);


mysql_close($connection);

system("f="https://forum.tuteehub.com/tag/echo">echo '$result' >> /Report/sqloutput");

manpreet 2 years ago