[SOLVED] How do I Extract data from the Members only section

[stuart7398]

Hi.

I have a members area.

When the member logs in, they see links to their respective pages – 'My Profile', and so on.

 

I want the user to view their own personal profile / space / settings taken from the database.

What do I use to achieve this?

 

Thanks,

Stuart.

 

 

<?php
require_once('auth.php');
?>

<?php $page_title = 'My Profile'; @ require_once ('../includes/head.php'); ?>
<div class="members_nav"><a href=" member-homepage.php">My Homepage</a>  | <a href=" member-profile.php">My Profile</a> | <a href=" member-pictures.php">My Pictures</a> | <a href=" logout.php">Logout</a></div>
<?php
require '../conn/config.php';
require '../conn/opendb.php';
$data = mysql_query("SELECT * FROM `members` ORDER BY member_id") OR DIE (mysql_error());
$info = mysql_fetch_array( $data );
{
Print "<p><br /><h1>Welcome Back ".$info['firstname']."</h1></p>";
}
?>

</div></div>
<?php 
@ require_once ('../includes/leftnav.php'); 
@ require_once ('../ includes /rightnav.php'); 
@ require_once ('../ includes /foot.php'); 
?>

[fenway]

Um, no where clause?

[stuart7398]

Hi.

An example would be appreciated. the code presented is for someone already logged in.

 

thanks.

stuart.

[fenway]

An example would be appreciated. the code presented is for someone already logged in.

Then where is the member ID in your SQL query?

[stuart7398]

Im honestly not sure. I've been learning only for about 12 weeks.

Any help appreciated.

thanks.

 

WHERE added below

 

<?php

require '../connect/config.php';

require '../connect/opendb.php';

$data = mysql_query("SELECT * FROM members WHERE member_id = '$id'") OR DIE (mysql_error());

$info = mysql_fetch_array( $data );

{

Print "<p><br /><h1>Welcome Back ".$info['firstname']."</h1></p>";

}

?>

[stuart7398]

I think I have the WHERE

but how do i identify the user who is logged in

SELECT * FROM members WHERE '?????' = '????' "

 

 

thanks,

 

[stuart7398]

Thanks.

The WHERE was the key.

 

Stu.