Help for Profile script

klik

I have just started on my profile script. My first task is to pass a variable through the URL address in the following format

profile.php?user_id=2

A small section of code I currently have is below:

if ((!isset($_SESSION['username'])) || (empty($_SESSION['username'])))
{
     header("Location: /members_only.php");
     exit();
}

$user_id = $_GET['user_id'];

$result = mysql_query("SELECT * FROM cms_users WHERE user_id = '$user_id'");
$result = mysql_result($result, 0);

The error message returns:

Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 4 in blah blah blah

Any ideas?

Am I passing the variable correctly?

vornn

Try this.

$user_id = ".$HTTP_GET_VARS['user_id'].";

It's what I use to get vars.

I'm sure you'll get another ten ways too.

Hope this helps...

🙂

paulnaj

I think it doesn't like the line ...

$result = mysql_result($result, 0);

... change the var name on the LHS to anything but $result ...

$column = mysql_result($result, 0);

That might be it.

Or the query doesn't always return a result! Use mysql_num_rows() to check.

Paul

paulnaj

Just noticed vornn's post ... I don't think that's problem. $HTTP_GET_VARS has been deprecated (can no longer be relied on to work ... depends on the server config.). See the manual for a description.

Paul

ganesh129

I think Paul is right. It doesnt appear to be returning anything, so the problem could be that the variable isnt being passed.

you can use:

echo "User ID: " . $_GET['user_id'];

to see if the variable is in fact being passed through or not.

YappyDog

The original script that klik shows has single quotes around the $user_id variable in the query. Not sure if that would make a difference because we don't know how the user_id column is defined.

klik

Sorry guys.

Just noticed that the example number I chose '2' was erased from my database. Every other id number seems to work fine

Sorry for your wasted efforts, but thanks for the responses. Always apreciated

Klik