mysql problem

Haktar

Hi i am trying to retrive a rank or a player from a database, but all i get back is Resource id #5 instead of the rank. heres what i have for the code

echo mysql_query("SELECT rank FROM user WHERE user='$user'");

bradgrafelman

Okay, then you need to retrieve the data that was selected, probably using [man]mysql_result/man in this case.

Haktar

thanks for the reply but im pretty new to mysql and php so imm sure i did this wrong, i put

echo mysql_result("SELECT rank FROM user WHERE user='$user'");

and in place of the result i got

Warning: Wrong parameter count for mysql_result() in /home/thephoen/public_html/Serenity/main.php on line 65

bradgrafelman

Look at the manual for [man]mysql_result/man and see how they gave examples.

Haktar

thanks for the reply, that seems to be used if you have quereied alot of results, but i only want to 'fetch' one

laserlight

Typically, you would do something like this:

// construct the SQL statement
$query = "SELECT rank FROM user WHERE user='$user'";

// run the query using the SQL statement
$result = mysql_query($query);

// retrieve a row from the result set returned by the query
$row = mysql_fetch_assoc($result);

echo $row['rank'];

In your case, since only one column is involved, you can do:

$result = mysql_query("SELECT rank FROM user WHERE user='$user'");

// retrieve a field from the result set returned by the query
// the 0 is the row number, i.e. the first row
echo mysql_result($result, 0);

Haktar

ah excellent thanks very much

Haktar

hey thanks for that i got it to work for one, but i actually need it for more than one, this is what i have

echo "Rank: ";
// construct the SQL statement
$query = "SELECT rank FROM user WHERE user='$user'";
// run the query using the SQL statement
$result = mysql_query($query);
// retrieve a row from the result set returned by the query
$row = mysql_fetch_assoc($result);
echo $row['rank'];
echo " | ";
echo "Turns: "
echo $row['turns'];
echo " | ";
echo "Credits: "
echo $row['credits'];
echo " | ";
echo "Holding Cell: "
echo $row['bankcredits'];
echo " | ";
echo "Messages: "
echo $row['messages'];

but its erroring on the bold line with
Parse error: syntax error, unexpected T_ECHO, expecting ',' or ';' in /home/thephoen/public_html/Serenity/main.php on line 74

do the results clear or something?

Haktar

hi, sorry just noticed that i didnt change the query i changed it to
$query = "SELECT rank FROM user WHERE user='$user'";

but it still comes up with the same error

laserlight

That is because you only select the rank column.

// construct the SQL statement
$query = "SELECT rank, turns, credits, bankcredits, messages
	FROM user
	WHERE user='$user'";
// run the query using the SQL statement
$result = mysql_query($query);
// retrieve a row from the result set returned by the query
$row = mysql_fetch_assoc($result);
echo "Rank: " . $row['rank'] . " | "
	. "Turns: " . $row['turns'] . " | "
	. "Credits: " . $row['credits'] . " | "
	. "Holding Cell: " . $row['bankcredits'] . " | "
	. "Messages: " . $row['messages'];

Blulagoon

The error though was caused by a missing ';'

echo "Turns: "
echo $row['turns'];

at the end of the line "Turns: "

Blu