DaniWeb Forum Index > Web Development > PHP

Display Username

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Jan 2008

Posts: 74

Reputation: Vai is an unknown quantity at this point

Solved Threads: 5

Vai

Offline

Junior Poster in Training

Display Username

May 14th, 2008

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....

 Help with Code Tags 
 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]; ?>

•

Join Date: Aug 2007

Posts: 570

Reputation: ryan_vietnow is an unknown quantity at this point

Solved Threads: 71

ryan_vietnow ryan_vietnow is offline

Offline

Posting Pro

Re: Display Username

May 15th, 2008

 Help with Code Tags 
 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; ?>