Queries close session
| From: | Adept-Hosting.Net Administration | Date: | Mon, 14 Mar 2005 21:55:53 +0000 |
| Subject: | Queries close session | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-38901@lists.php.net to get a copy of this message | ||
I am using the following script to maintain a login session on some
pages:
<?php
session_start();
if(empty($_SESSION['username'])) {
die('An error has ocurred. It may be that you have not
logged in,
or that your session has expired.
Please try <a href="index.php">logging in</a> again
or contact the
<a href="mailto:email@address">system
administrator</a>');
}
?>
The sessions are stable and work fine EXCEPT when I run another PHP
script on the web page such as:
<?php
// Make a MySQL Connection
require "db_connect.inc";
// Retrieve all the data from the "example" table
$result = mysql_query("SELECT * FROM members WHERE Status='Inactive'")
or die(mysql_error());
echo "<table border='1' cellpadding='0' cellspacing='1'
align='center'>";
echo "<tr> <th>Certificate #</th><th>Dan rank</th><th>First
Name</th>
<th>Last Name</th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo "<tr><td>";
echo $row['Cert_number'];
echo "</td><td>";
echo $row['Dan_rank'];
echo "</td><td>";
echo $row['First'];
echo "</td><td>";
echo $row['Last'];
echo "</td></tr>";
}
echo "</table>";
?>
I'm assuming that I am either not maintaining the session properly or
not linking the scripts to the session.
Any pointers on how to accomplish what I'm trying to do?
Thanks,
- Ken