[SOLVED] Need help getting an id for a profile or whatever, help please!

[Terukio]

Okay look, you can even try yourself...

http://www.smashandtaxes.mildrum.net/register.php

then

http://www.smashandtaxes.mildrum.net/login.php

 

Now when you try to go to look at your profile it says no user specify because for some reason I can't get the ID of the person you're trying to find.

 

$sql = "SELECT * FROM user
WHERE user.id='$_GET[id];'";
$result = mysql_query($sql);
$result2 = mysql_fetch_assoc($result);
$user = $result2[username];
$email = $result2[email];
$desc = $result2[profile];
$desc2 = $result2[history];
$tag = $result2[tag];
$call = $row['id'];
?>
<?
if($_COOKIE[auth] == yes){
?>
<?
if($_GET[id] == false){
echo "No user specify";
}else {
?>
<?php
echo"<h3>$user // Tag: $tag</h3><br>";
echo"$desc";
echo"<br><br>";
echo"<h3>History</h3>";
echo"$desc2";
echo"<br><br>";
echo"<h3>Personal Videos</h3>";
echo"$desc3";
}
}
?>

 

I did the database connection already...I just don't see what I need to do...help

[Terukio]

I mean, I got it to work on the main site, mildrum.net , but I used inc files, and I wish to use php files in this subdomain...I can't get it to work though, so I need someone's help

[.josh]

$sql = "SELECT * FROM user WHERE user.id='{$_GET['id']}'";

 

I'm also curious why you are running this query and then later checking to see if it exists in the first place?

[Terukio]

Wait nevermind!  I got it!