RE: [PHP-DB] Queries close session

Thanks for the quick reply. That doesn't seem to be the problem, though, as I can't seem to find any additional spaces being sent in the headers. > -----Original Message----- > From: adept@server145.cpanelx.com > [mailto:adept@server145.cpanelx.com] On Behalf Of Calvin Lough > Sent: March 14, 2005 3:07 PM > To: Adept-Hosting.Net Administration; php-db@lists.php.net > Subject: Re: [PHP-DB] Queries close session > > > Because the session you are using probably uses a cookie to remember > the session, it is required that you call session_start before you > output anything to the screen(aka: send any headers). So if you place > the session start at the very top of your page before you include any > files or output anything, the session should work. Beware of any > whitespace before the <?php tags because that will also send headers. > > Calvin > > On Mon, 14 Mar 2005 14:55:53 -0700, Adept-Hosting.Net Administration > <admin@adept-hosting.net> wrote: > > 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 > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > >