i have a mysql database and table, db is called "users" and the table is called "login" im running the scripts on my local computer through a local apache server ect.. so i have no username or password set up. im trying to retrieve the data from one of the feilds in the table and all i keep getting out is "resource id #2" and not the data that the feild contains. the php script is like this.
<?
// feilds of the databse "users" table "login"
// "NUMBER"(8) (primary) , username(25) , password(20) , email(50) , status(50)
mysql_connect(localhost);
@mysql_select_db(users) or die( "Unable to select database");
$query = "SELECT status FROM login WHERE number='1'";
$resource = mysql_query($query);
echo "$resource";
the actually data in the table that i want to get is "admin" but it jus gives me "resource id #2" why???
