Hello, a bit of help please

Edit: I thought of an algorithm not 5 seconds after I made the post, so I will post back later if it works for me or not. If you don't mind though, post your codes


I am trying to create a query that will collect all users out of the database that have their status field set to 1.

So basically, if I had

User - Status
User1 - 0
User2 - 0
User3 - 1
User4 - 1

I would like to create an array variable that has User3 and User4 stored into it.

Thanks!

 

$result = mysql_query("SELECT * FROM tabale_name WHERE status=1")
or die(mysql_error());

 

Well I wanted to put them into an array, but i'v got my code for this.

I am using the mysql_fetch_array function, this should have came to my head first thing when I needed to code this.

Anyways, thanks guys.