• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 242
  • Last Modified:

Retrieving user information from database - help

Right, my code that I have written will retrieve the records from the database table containing the users
but I only want to display the details of the user logged in rather than all of the users.

I can't seem to work out how to change it so it only displays the logged in user.

<?php
include("database.php");

$query = "SELECT * FROM user ";
$result = mysql_query($query);
$num = mysql_num_rows ($result);
mysql_close();

if ($num > 0 ) {
$i=0;
while ($i < $num) {
$FirstName = mysql_result($result,$i,"FirstName");
$Surname = mysql_result($result,$i,"Surname");
$DOB = mysql_result($result,$i,"DOB");
$City = mysql_result($result,$i,"City");
$Postcode = mysql_result($result,$i,"Postcode");
$WebAddress = mysql_result($result,$i,"WebAddress");
$USER_ID = mysql_result($result,$i,"USER_ID");

echo "<b>First Name:</b> $FirstName<br>";
echo "<b>Surname:</b> $Surname<br>";
echo "<b>Date of Birth:</b> $DOB<br>";
echo "<b>City:</b> $City<br>";
echo "<b>Postcode:</b> $Postcode<br>";
echo "<b>Website:</b> $WebAddress<br>";
echo "<a href=\"account_save.php?id=$USER_ID\">Update</a>";
echo "<br><br>";

++$i; } } else { echo "The database is empty"; }

?>

Open in new window


Your help is much appreciated.
Thank you.
0
PSTCAT
Asked:
PSTCAT
  • 4
  • 2
2 Solutions
 
maeltarCommented:
Why not use a while loop to run though and put it within an if statement :

Obviously the $row array elements need to be adjusted to suit.
if ( $num > 0)
{
while ($row = mysql_fetch_array($result)
{
echo "<b>First Name:</b> {$row[0]}<br>";
echo "<b>Surname:</b> {$row[1]}<br>";
echo "<b>Date of Birth:</b>{$row[2]}<br>";
echo "<b>City:</b> {$row[3]}<br>";
echo "<b>Postcode:</b> {$row[4]}<br>";
echo "<b>Website:</b>{$row[5]}<br>";
echo "<a href=\"account_save.php?id=$id\">Update</a>";
echo "<br><br>";

}

} // end if

Open in new window

0
 
maeltarCommented:
NOTE  Line 3 should read
while ( $row = mysql_fetch_array($result) )

Open in new window

0
 
PSTCATAuthor Commented:
Hi,

Thanks for your reply,

That code works for displaying the user's information
but I am still getting the other users in the table being displayed on the page.

0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
maeltarCommented:
how do you know what user is logged in ?
As in is there a variable set to a value ?
0
 
maeltarCommented:
If the user id is set in a variable you could adjust the sql to something similar to :

$query = "SELECT * FROM user where <user id field> = <variable holding user id>";

Open in new window

0
 
PSTCATAuthor Commented:
I see where you are going with that.

Thank you.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now