Profile page

[Colourtheory]

So I tried to make a profile page.. it's not working out so well. Here is the profile page's source, and note: the address bar when you click the link comes out to be ?id= and even if I type the ?id=1 it still doesn't work <?phpsession_start();require_once 'db.php'; $id = $_GET['id'];$user = mysql_query("SELECT name FROM users WHERE id='$id'"); echo "<h1>User Info</h1>"; echo "<p>Username:" . $user['name'] . "<br>";echo "Email:" . $user['email'] . "<br>"; ?>

[nitesh]

Hiyou are only quering not fetching value from the database do something like this after quering $user = mysql_query("SELECT name FROM users WHERE id='$id'");$result = mysql_fetch_assoc($user);echo "<p>Username:" . $result['name'] . "<br>";echo "Email:" . $result['email'] . "<br>";

Edited December 23, 2012 by nitesh

[Colourtheory]

Still doesn't work.

[Colourtheory]

Wait, I made the username load but not the email. Confusing me..

[Colourtheory]

 <?phpsession_start();require_once 'db.php';$id = $_GET['id'];$user = mysql_query("SELECT name FROM users WHERE id='$id'");$result = mysql_fetch_assoc($user);$email = $result['email'];echo "<p>Username: " . $result['name'] . "<br>";echo "Email:" . $result['email'] . "<br>"; ?>

Still not working.. hmm..

Edited December 23, 2012 by Colourtheory

[Colourtheory]

Got it, forgot to fetch email. My bad.