Resource id # error

[Muffo]

Hi.

I have been trying to get this to work for hours...

The key part of the code is...

$editlogin = $HTTP_POST_VARS['editlogin'];
include("dbconnect.inc");
echo $editlogin;

$current_nick = mysql_query("SELECT nick FROM members WHERE login ='$editlogin'");

$editlogin is working as required, and the dbconnect.inc also works, however the response i get when i echo $current_nick is...

Resource id #4

I have no idea what is wrong, but any help would be much apprecated.

[willybfriendly]

You are getting back the resource ID (just like it says!)

Try:
$result = mysql_query("SELECT * FROM members WHERE login ='$editlogin'");
$row = mysql_fetch_array($result);
$current_nick = $row[nick];

WBF

[Muffo]

Works brilliantly, thanks :)