PHP Array Help (I have a coders block)

[JREAM]

I don't know what my problem is today.

I have this working, print_r($admin) works.

 

but I have to do this to retrieve a value:

$admin[0]['title'];

Is there a way I can do this without the digit?

$admin['title'];

since im only getting one result back?

$sql = "SELECT * FROM users WHERE `id` = 0 LIMIT 1";
$result = mysql_query($sql);

$admin = array();
while ($query = mysql_fetch_array($result)) {
$admin[] = $query;
}

if(empty($admin))
{
$admin = NULL;
}

[play_]

You are retrieving only 1 row. You dont need that while loop.

 

$admin = mysql_fetch_array($result)