WHERE session, doing something wrong

[stu7398]

Hi.
I'm trying to retrieve someone's profile details and having trouble getting the data.
Would someone let me know what it is i'm doing wrong?
I'm assuming it's to do with the 'WHERE' clause

Thanks,
Stu.

<?php
session_start();
if($_SESSION['s_logged_n'] == 'true'){
include 'process.php';
?>

<?php
$data = mysql_query("SELECT * FROM Users WHERE id = '$_SESSION_id'") OR DIE (mysql_error());
$info = mysql_fetch_array( $data );

[NogDog]

Is it dieing with the mysql_error() message, or is something else happening that indicates a problem? Have you echoed out the $data query to see if it looks right?

[stu7398]

Hi.
No, it's not dying.
I'm receiving no errors.
I can retrieve data, but not data from each individual id member.

[leatherback]

ghm.. unless you are really storing the $_SESSIOND_id in your users table as an ID (Which would not make sense), you might be looking for something like this:

$data = mysql_query("SELECT * FROM Users WHERE id = ".$_SESSION['id']." limit 1") OR DIE (mysql_error());

Which is assuming that at login you stored the users.id in $_SESSION['id']