Session and redirection problem.

[nomz]

Can any one help me.

I am using this page to login the user and want to insert his name, date of login, IP and time for complete lOg.

when i user headers() for redirect, it does not redirect and when i do it through meta tag, the session variables do not contain any value???????????????????????????????????

somebody help meeeeeeeeeeeeeeeeeeeeeeeeeeeeee

<?php
include 'conn.php';
$username=$POST['login'];
$password=$POST['passwd'];

$result = mysql_query("select * from main_login where login= '$username' and passwd = '$password';", $db);

$myrow = mysql_fetch_array($result);

if ($myrow)
{
// echo 'User OK. ';

session_start();

$_SESSION['login']=$myrow['login'];
$_SESSION['name']=$myrow['name'];

$ndate=date("y-m-d");

mysql_query("INSERT INTO main_log (loginid, logindate, logintime, logoutdate, logouttime, loginip) VALUES ($SESSION['loginid'], '$SESSION['logindate']', '$SESSION['logintime']', '$SESSION['logoutdate']', '$SESSION['logouttime']', '$SESSION['loginIP']')

header("Location: main.php");

[tuf-web_co_uk]

ok when i ran your code in my debugger, i found a few problems

your mysql_query on line 21 wasnt closed properly with "); at the end

ur location(); also seemed to give some errors and you didnt end your if statement

probably because you have posted the whole code anyways

heres what i've done, see if works

<?php 
include 'conn.php'; 
$username=$_POST['login']; 
$password=$_POST['passwd']; 

$result = mysql_query("select * from main_login where login= '$username' and passwd = '$password';", $db); 

$myrow = mysql_fetch_array($result); 

if ($myrow) 
{ 
	// echo 'User OK. '; 

session_start(); 

$_SESSION['login']=$myrow['login']; 
$_SESSION['name']=$myrow['name']; 

$ndate=date("y-m-d"); 

mysql_query("INSERT INTO main_log (loginid, logindate, logintime, logoutdate, logouttime, loginip) VALUES ('".$_SESSION['loginid']."', '".$_SESSION['logindate']."', '".$_SESSION['logintime']."', '".$_SESSION['logoutdate']."', '".$_SESSION['logouttime']."', '".$_SESSION['loginIP']."')");

$url = "main.php";

header('Location: ' . $url);
}
else {

// did not log in

}
?>

hth

[olaf]

Hi,

Is there an another Id-field (with an unique value) in your log-table?