mySQL function

[Anon]

How would I go about putting the password and essential functions in a remote function that i can just pass SQL to and then get a result back from so it is reusable?

Errr... if that makes any sense 😉

Cheers.

Tony.

[stuartc1]

I think I know what your saying. Is this what you are looking for:

Function RunQuery($r_pass,$r_db,$r_sql,$r_etc)
{
// retrieve the values that are passed in
$dbpass = $r_pass;
$db = $r_db;
$sql = $r_sql;
$etc = $r_etc;

..Put your db connection and query here..

return $results;

}

:->

[Anon]

Err... Not sure - here is what i have come up with so far:

function mySqlConnect($sql) {
$sqlConnect = mysql_connect("host", "user", "pass");
mysql_select_db("database", $sqlConnect);
$query = mysql_query($sql);
return $query;
}

Then Ihave a call to this that I pass the $sql into. The error i get is:

Warning: Supplied argument is not a valid MySQL result resource

The line it refers to has:

while($data = mysql_fetch_row($query)) {
print "<h5>".$data[0]."</h5>";
print $data[5];
print "<br /><div class=\"smallPrint\">Added: ".$data[6]."</div>";
}

That is all I can say really - i'm stuck 🙂

Tony.

[Anon]

If anybody knows how to fix my problem I would be very happy for help...