global question.

[seby]

say i have:

$dbconnection = mysql_connect($dbhost,$dbuser,$dbpass) or die  ('Unable to connect to database');
mysql_select_db('db') or die('Unable to select database');


/*
some other functions....
*/

if($_POST['submit'] && !$_POST['search']) 
{
	mysql_query("INSERT INTO ...");
}

How do i access the database connection without repeating the mysql connection function more than once? I tried using global $dbconnection; but it still wont let me use that connection..

i'm trying to aviod making custom connect class functions.

[intenz]

$GLOBALS['dbconnection']

[laserlight]

You dont have to access the DB connection that way.

Your queries should still work as long as you do not call mysql_close() prematurely.

Under normal circumstances, you dont even need to call mysql_close().

[seby]

Originally posted by laserlight
You dont have to access the DB connection that way.

Your queries should still work as long as you do not call mysql_close() prematurely.

Under normal circumstances, you dont even need to call mysql_close().

i know that, but i meant it wont use that connection that is already open...

intenz: that still doesn't work, no matter where i put it it won't do the query.. only if i put the mysql_connect inside the $_POST ..

[laserlight]

Test with a smaller scale script, e.g.

<?php
mysql_connect($dbhost,$dbuser,$dbpass)
	or die('Unable to connect to database');
mysql_select_db('db')
	or die('Unable to select database');

if (!empty($_POST['submit']))
{
	mysql_query("SELECT * FROM tablename")
		or die('Unable to select data');
	echo "All ok\n";
}
?>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<input type="submit" name="submit" value="Submit">
</form>