Unable to retrieve value from database and echo on screen
| From: | Harlequin | Date: | Sun, 04 Jul 2004 16:14:56 +0000 |
| Subject: | Unable to retrieve value from database and echo on screen | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-189667@lists.php.net to get a copy of this message | ||
I know, I know. Simple stuff to you guys, but I am learning more every day
and believe me - I won't be recommending Bill's software for web development
from now on :)
/* Select User's First Name From Table */
$sql = "SELECT UserFirstName FROM RegisteredMembers WHERE
UserID='$_POST[TXT_UserID]'";
$result5 = mysql_query($sql) or die ("couldn't select UserID from
database");
$num = mysql_num_rows($result);
/* Welcome Registsred Member */
echo "welcome to the registered members area ";
echo ("$result");
I know iit has the data in there as I echoed an entire error statement and
the correct user was selected. I just need to echo a different field value
from those alraedy selected previously in the page.
--
-----------------------------
Michael Mason
Arras People
www.arraspeople.co.uk
-----------------------------