Displaying a Member Name from a Database
Posted: Sat May 15, 2004 4:14 pm
Ok I have been trying to do this for a week and now I am asking for help.
I have a membership login system running. What i want to do is display 'Welcome (membername) ! if they are logged in. I have a simple script that i have gotten to display:
Welcome Resource Id#4 !
Why won't it display the name instead??
Here is the code:
Code: Select all
<?
session_start();
?>
<?php
include ("db.php");
?>
<?php
$sql_member = mysql_query("SELECT us_name FROM twb_users WHERE us_id = '". $u_id ."'") or die (mysql_error());
echo "Welcome $sql_member !";
?>
Could someone please help me??