[SOLVED] Fetching data from a mysql database...

[cwncool]

(Please keep in mind this is my first script I've written using MySQL)
I have this code, trying to fetch the user's first name from the database and displaying it.
[code]<?php
session_start();
if(!isset($_SESSION['username'])) {
header("location:index.php");
}
include 'connect.php';
$user = $_SESSION['username'];

$name = mysql_query("SELECT first FROM users WHERE user='$user'");
echo $name;
?>[/code]
Instead of echoing the name, it says
Resource id #3.  Can someone please tell me how I can echo the name please?  Thanx!

[fert]

http://us2.php.net/manual/en/function.mysql-fetch-array.php

[HoTDaWg]

[code]
<?php
session_start();
if(!isset($_SESSION['username'])) {
header("location:index.php");
}
include 'connect.php';
$user = $_SESSION['username'];

$name = mysql_query("SELECT first FROM users WHERE user='$user'");
mysql_fetch_array($name);
echo $name;
?>
[/code]

[fert]

that code won't work

[cwncool]

Yeah, that code doesn't work.  Anyone else?

[cwncool]

Yay, I got it to work with this...
[code]<?php
session_start();
if(!isset($_SESSION['username'])) {
header("location:index.php");
}
include 'connect.php';
$user = $_SESSION['username'];

$data = mysql_query("SELECT * FROM users WHERE user='$user'");
$data = mysql_fetch_array($data);
echo $data['first'];
?>[/code]