It keeps returning "Resource ID #8"...

[Avimander]

$usrname =  $_POST['uname'];
$queryb = "SELECT id FROM users WHERE username = '$usrname'";
$youridno = mysql_query($queryb);
	mysql_close();
echo "Thank you for registering.";
echo "<br>Your ID is...<br>";
echo $youridno;
echo "<br>You can now log in from the side bar.";

I thought "$youridno" would return whatever the ID was (the auto inreasing one) after you registered. Why does it return "Resource ID #8"?

[drawmack]

you need http://www.php.net/mysql_result to retrieve the data from the query.

[devinemke]

$usrname =  $_POST['uname']; 
extract (mysql_fetch_assoc (mysql_query ("SELECT id FROM users WHERE username = '$usrname'")));
echo 'Thank you for registering.<br>Your ID is...<br>' . $id . '<br>You can now log in from the side bar.';

[Avimander]

Thanks 🙂