Returning records based on user id

Anon

I'm trying to return records from MySQL database based on user id in this case but I don't think it's written right.

This is what i'm using:

$result=mysql_query("select * from coder where user_id='$profile' order by title",$con);

if (mysql_num_rows($result)){
$row = mysql_fetch_array($result);
{
$author = $row[author];
$title = $row[title];
$coder_id = $row[coder_id];
$user_id = $row[user_id];
$email = $row[email];
$poem = $row[poem];
$year = $row[year];
$comments = $row[comments];
$country = $row[country];

include("links.php3");
echo "$loadfile";

}
mysql_free_result($result);
}

else{
echo "No Result";
exit;

}

Since it's based on user id it's suppose to show all links on that id number, like if you enter 'www.domain.com/page.php3?profile=1' it's going to show all records that's using user id number '1'.

Anyone know how to do this?

Thanks,
Toby

Anon

Your select statment is call ing a profile "I think unless your profile is the users id" you need to reference like

$result=mysql_query("select * from coder where user_id='$user_id' order by title",$con);

where user_id matches user_id

hope that helps

Anon

I tested as you suggested but it returned 'No Result',
when i'm using the script it only shows the first record.

Toby

Anon

Is this a function? Have you declared profile as global as in

function .... {
global $profile;
...
}

Anon

Not what I know of, all I did was having one php file to list all ids then they can click on it's profile records by using the code:

<a href=\"$root/page2.php3?profile=$user_id\" target=\"_blank\">profile</A>

By clicking on this file it will load the second php file (page2.php3) and there I have the codes for showing the records based on ids. I'm not so sure how to write that function you're talking about for this.

Toby