question about mysql_query()

[james2010]

I was just wondering if makes any different, when executing mysql_query, if you include the optional second parameter for the connection.

I've been writing scripts that open a connection with this function:

function db_connect()
{
$result = @mysql_pconnect('localhost', 'username', 'password');
if(!$result)
return(false);
if(!@mysql_select_db($result))
return(false);
return($result);
}

then I call the function like this
$conn = db_connect();

But for some reason I ended up with an error in some scripts if I include $conn as the second parameter for mysql_query(). When I took it out the script worked perfectly.😕

[james2010]

actually I had another question too this time regarding sessions and url strings.

I was just wondering which is faster to pass data between pages, via session or via url query strings.

It seems to me that in many cases you can use either.

[thefury]

Just do..

mysql_pconnect('localhost', 'username', 'password') or die('DB down');
mysql_select_db('database') or die('Cant select db');

And when ever you do a query all it is, is

mysql_query("SELECT...");

As for sessions.. Letting php do everything on it's own is the best. It auto cookies the sessionid, and if it can't cookie it adds it to the link.