Please help, odd session problems.

OBCENEIKON

I wrote this verification script, which retrieves data from a MySQL DB, then loads the information into a session. For some reason, the values will not load into the session.

here is my code...

<?php
	session_start();										// start the session
	header("Cache-control: private");								// IE 6 Fix
	error_reporting(E_ALL);

include("./includes/css.php");
?>
<table class="main" height="80%">
	<tr>
		<td align="center" valign="center">
			<table class="custlinks" width="200">
				<tr>
					<td class="custlinkstop">

<?php

if (isset($_POST['vvmlogin']) && ($_POST['vvmpassword'])) {					// Check if all fields were entered.

	include("./includes/db_connect.php");

	$login = $_POST['vvmlogin'];
	$pw = $_POST['vvmpassword'];

	$sql = "SELECT * FROM vvmlogin WHERE username = '$login' AND password = '$pw'";		// query database
	$result=$db->query($sql);								// return result

	if (DB::isError($result = $db->query( $sql ))) {
		echo DB::errorMessage($result);
	}

	if ($result->numRows() == "0") {							// If incorrect, retry.

		echo "Login Failed.</td></tr>";
		echo "<tr><td align=\"center\"><img src=\"./images/stop.gif\"></td></tr>";
		echo "<tr><td align=\"center\">No Matches Found.<br>Please try again.</td></tr>";
		echo "<tr><td align=\"left\"><form action=\"$PHP_SELF\" method=\"post\">Username:</td></tr>";
		echo "<tr><td align=\"left\"><input type=\"text\" name=\"vvmlogin\"></td></tr>";
		echo "<tr><td align=\"left\">Password:</td></tr>";
		echo "<tr><td align=\"left\"><input type=\"password\" name=\"vvmpassword\"></td></tr>";
		echo "<tr><td align=\"center\" colspan=\"2\"><input type=\"submit\" value=\"Login\"></form></td></tr>";

	} else {										// If correct, login.

		$_SESSION['vvmlogin'] = $row['username'];
		while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC)) {
			echo "Login Successful.</td></tr><tr><td align=\"center\">Welcome&nbsp;";
			echo $row['username'] .".</td></tr>";
			echo "<tr><td align=\"center\"><img src=\"./images/status.gif\"></td></tr>";
			echo "<tr><td align=\"center\">You will be redirected<br>to the page you were viewing<br>in 5 seconds...<br></td></tr>";
			echo "<tr><td align=\"center\">(Or <a href=\"layout2.php\">click here</a> if you do not wish to wait)</td></tr>";
		}

	}

	$db->disconnect();

} else {

	echo "Login Failed.</td></tr>";
	echo "<tr><td align=\"center\"><img src=\"./images/exclamation.gif\"></td></tr>";
	echo "<tr><td align=\"center\">You did not fill in all the required fields.<br>Please try again.</td></tr>";
	echo "<tr><td align=\"left\"><form action=\"$PHP_SELF\" method=\"post\">Username:</td></tr>";
	echo "<tr><td align=\"left\"><input type=\"text\" name=\"vvmlogin\"></td></tr>";
	echo "<tr><td align=\"left\">Password:</td></tr>";
	echo "<tr><td align=\"left\"><input type=\"password\" name=\"vvmpassword\"></td></tr>";
	echo "<tr><td align=\"center\" colspan=\"2\"><input type=\"submit\" value=\"Login\"></form></td></tr>";
}

?>
			</table>
		</td>
	</tr>
</table>

mrhappiness

try

$row = $result->fetchRow(DB_FETCHMODE_ASSOC); 
echo "Login Successful.</td></tr><tr><td align=\"center\">Welcome&nbsp;";
echo $row['username'] .".</td></tr>";
echo "<tr><td align=\"center\"><img src=\"./images/status.gif\"></td></tr>";
echo "<tr><td align=\"center\">You will be redirected<br>to the page you were viewing<br>in 5 seconds...<br></td></tr>";
echo "<tr><td align=\"center\">(Or <a href=\"layout2.php\">click here</a> if you do not wish to wait)</td></tr>";
$_SESSION['vvmlogin'] = $row['username'];

you can use $row['username'] only after you did $result->fetchRow

btw: i removed your while since i don't think you have more than one user with the same name?
you can use LIMIT 1 in your sql to tell the database this fact and speed up things a little bit

OBCENEIKON

THANK YOU SOOOOO MUCH!!! I did not know this and from the tutorials I have read to learn this, they did not specify it. You have made my day!! also thanks for the tips on limiting it to 1 and removing my loop 😃