Home › Forums › Back End › Members Page (SELECT) Error! › Re: Members Page (SELECT) Error!
January 28, 2012 at 11:20 pm
#95634
Thoven78Member
The reason why you’re getting “The users are: Resource id #3” is because whenever you do a query you always have to fetch the table. This is what the code should have looked like.
< ?php
$connect = mysql_connect("host", "username", "password");
$select_db = mysql_select_db("database", $connect);
if(!$select_db){
die(mysql_error());
}
$write = mysql_query("SELECT username FROM husers");
$users = "";
while ($row = mysql_fetch_assoc($write)) {
$users = $row;
}
?>
