Connection ID

[fenris_w0lf]

In what (if any) TP/SMF variable do I find my connection id to the mysql database ?

Would be used in something like:

$result_id = mysql_query ($query, $connection_id);

[bloc]

All are in Settings.php. They are called:

$db_server
$db_name
$db_user
$db_passwd

If getting a connection to another databse is the goal. In SMF/TP all you need is to call the table with the query, the connection is already open on the SMF databse.

[fenris_w0lf]

Thanks for the reply Bloc,

but;

thats the server, db-name, user and pw - but not the connection id !? isnt that stored in any global variable ?? (I would think usually a number of some sort...)

The one you would normally do a:

mysql_close ( connection id here )

on....

[fenris_w0lf]

I appologize. This prolly doesnt make any sense.

I'm used to a *very* different environment where most users gets theyre own spid on the database (win/hpux-sybase install) - seems this is not the case with SMF (and similar forums etc).

Ignore this topic please.

* fenris_w0lf blushes lightly 

[bloc]