One slight yet easy problem!

[influx]

hrm, this is odd odd. When I type:

<?php echo $_SESSION['username'];?>

it works perfectly fine and outputs the person's username. However, when I type:

<?php echo $_SESSION['id'];?>

it remains blank!

Hrm, what could be the problem? Both the username and ID are found in the USERS table, but here is the difference:

id: (int, 10 characters max, not null, auto increment, PRIMARY KEY)
username: (varchar, 40 characters max, null)

[LordShryku]

Lets see the code where you're setting them as session vars...

[influx]

hrm, i never register the ID, but each new person that signs up is assigned a unique ID, which automatically increments with each new person. But the username is registered. Haha, I guess that is the problem. But in this case, how on earth should I call the id from the USERS table? I can see everybody's ID, but how do I call it?

but anyways, here is the code:

$insert = "INSERT INTO users (
			first_name,
			last_name,
			username, 
			password, 
			regdate, 
			email, 
			city,
			state,
			zip_code,
			country,
			sex,
			hear_about_us,
			last_login) 
			VALUES (
			'".$_POST['first_name']."',
			'".$_POST['last_name']."',
			'".$_POST['uname']."', 
			'".$_POST['passwd']."', 
			'$regdate', 
			'".$_POST['email']."', 
			'".$_POST['city']."',
			'".$_POST['state']."',
			'".$_POST['zip_code']."',
			'".$_POST['country']."',
			'".$_POST['sex']."',
			'".$_POST['hear_about_us']."',
			'Never')";

$add_member = $db_object->query($insert);

if (DB::isError($add_member)) {
	die($add_member->getMessage());
}

$db_object->disconnect();
?>

[Weedpacket]

[man]mysql_insert_id[/man]?

[influx]

hrm, where would I put that? I have no idea. I dont really understand that.