Display Username

Expand Post »

Here is what I am trying to accomplish: When a user logs in, their username will be displayed... Trouble is I am unsure how to co-relate the username w/ the id... thanks for any and all help....

PHP Syntax (Toggle Plain Text)
<?php
   require_once('core/db.php');
   require_once('core/secure.php'); 
 
  $query = mysql_query("SELECT username FROM admin WHERE id = 1");
  $username = mysql_fetch_array($query);
 ?>
<?php echo $username[username]; ?>
<?php
   require_once('core/db.php');
   require_once('core/secure.php'); 

  $query = mysql_query("SELECT username FROM admin WHERE id = 1");
  $username = mysql_fetch_array($query);
 ?>
<?php echo $username[username]; ?>

Similar Threads

Simple login (read data through txt file) in Visual Basic 4 / 5 / 6
Forbidden | You don't have permission to access /~username on this server. in Linux Servers and Apache
Change display name? in Geeks' Lounge
PHP Help - Display forum online and total members on main page in PHP
ASP.NET how can i display the logod user Status in ASP.NET

Vai

Reputation Points: 12

Solved Threads: 5

Junior Poster in Training

Offline

74 posts
since Jan 2008

Permalink

May 15th, 2008

Re: Display Username

php Syntax (Toggle Plain Text)
<?php
   require_once('core/db.php');
   require_once('core/secure.php'); 
 
  $query = mysql_query("SELECT username FROM admin WHERE id = 1");
  $result=mysql_query($query);
$username=mysql_result($result,0,"username"); 
?>
<?php echo $username; ?>
<?php
   require_once('core/db.php');
   require_once('core/secure.php'); 

  $query = mysql_query("SELECT username FROM admin WHERE id = 1");
  $result=mysql_query($query);
$username=mysql_result($result,0,"username"); 
?>
<?php echo $username; ?>

Enjoy!

ryan_vietnow

Reputation Points: 28

Solved Threads: 71

Posting Pro

Offline

578 posts
since Aug 2007

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: File Upload Variables

Next Thread in PHP Forum Timeline: browser detect

DaniWeb Message

Cancel Changes

User Name
Password