passing $dbcnx to another php script

[Anon]

Hello all, I was hoping someone has the answer to this for me. I currently have a php script that uses a username and password to connect to the MySQL Server as such:
$dbcnx = mysql_connect('localhost', $username, $password);

My question is this:
the value stored in $dbcnx, how can I pass the value in the following scenerio - After connecting to the MySQL server, I SELECT some data and present it as a <A HREF> like such:
<TD><A HREF="component.php?PID=1">Component</A></TD></TR>

Since the user is going to click on a HYPERLINK and is going to pass the PID=1 argument to the component.php script, is there a way to somehow also pass the $dbcnx variable to the component.php script as well?
It appears that <A HREF="component.php?PID=1&dbcnx=$dbcnx">Component</A> does not work. I get the PID=1 in my component.php by using $_GET["PID"], but I cannot get the value of $dbcnx. Is there another way to pass it as hidden with a HYPERLINK? Thanks in advance.

[cheald]

You need to reconnect and query the database on each page. Can you be more specific about what you're trying to do? I have a feeling you're going about it the hard way 🙂

[Anon]

I would like to have a login interface that will allow any unique user to give a username and password. Then a function will call the mysql_connect with that information to get a resourceID for that user. That user then will be presented with data from the mysql database by SELECT and mysql_query. The data is presented to the user as HYPERTEXT links that refer to other php files. Those PHP files will need to run queries as well to present the data as HYPERTEXT links....so one and so forth. So I need to allow a user to get a database connection they can use to navigate the website and have multiple SELECT queries executed on different php files. Any suggestions?