Page 1 of 1

Displaying a Member Name from a Database

Posted: Sat May 15, 2004 4:14 pm
by perryp5
:twisted:
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??

Posted: Sat May 15, 2004 4:17 pm
by feyd

Code: Select all

list($name) = mysql_fetch_row($sql_member);
echo "Welcome $name!";

Geeze

Posted: Sat May 15, 2004 4:24 pm
by perryp5
:roll:
OK Feyd You truely are my master. It's like that HUH?

THAT %^&*%## easy??

thanks man

Perry

Posted: Sat May 15, 2004 8:25 pm
by d3ad1ysp0rk

Code: Select all

<?php
$member = mysql_result($sql_member);
echo "Welcome, " . $member;
?>
Works also.

And like I said in your other post, theres no need to go in and out of PHP if you're not printing large amounts of HTML.