PDA

View Full Version : Query wont run???



Romanity
30-03-2008, 10:48 AM
if ($_SESSION['username'] && $_SESSION['pass'])
{
echo "ONLINE"; //Added to see if sessions were active

$logge = mysql_query("SELECT * FROM `users` WHERE `username` = '$_SESSION[username]' AND `password` = '$_SESSION[pass]'") or die(mysql_error());
$logged = mysql_fetch_array($logge);

if($logged[username])
{
echo "<br>ONLINE2";
} // Added to see if query worked
}


Now according to this, when logged in... the sessions are active (it comes up with online) however... the query wont run to creat $logged???

Any suggestions?
+Rep

Blob
30-03-2008, 11:27 AM
if ($_SESSION['username'] && $_SESSION['pass'])
{
echo "ONLINE"; //Added to see if sessions were active

$logge = mysql_query("SELECT * FROM `users` WHERE `username` = '$_SESSION[username]' AND `password` = '$_SESSION[pass]'") or die(mysql_error());
$logged = mysql_fetch_array($logge);

if($logged[username])
{
echo "<br>ONLINE2";
} // Added to see if query worked
}


Now according to this, when logged in... the sessions are active (it comes up with online) however... the query wont run to creat $logged???

Any suggestions?
+Rep



if ($_SESSION['username'] && $_SESSION['pass'])
{
echo "ONLINE"; //Added to see if sessions were active

$logge = mysql_query("SELECT * FROM `users` WHERE `username` = '" . $_SESSION["username"] . "' AND `password` = '" . $_SESSION["pass"] . "'") or die(mysql_error());
$logged = mysql_fetch_array($logge);

if($logged[username])
{
echo "<br>ONLINE2";
} // Added to see if query worked
}

Want to hide these adverts? Register an account for free!