SQL + PHP - How to?

how to put username no 1 and username no 2 from next table

+-------------+-----------+-----------+--------------+--------+--------+
| korisniciID | username | password | email | status | jacina |
+-------------+-----------+-----------+--------------+--------+--------+
| 1 | username | password | admin@cg.yu | r | a |
| 2 | username1 | password1 | admin1@cg.yu | r | a |
+-------------+-----------+-----------+--------------+--------+--------+
2 rows in set (0.11 sec)

in arrays?

somethjing like this?


$upit = "SELECT username FROM baza_korisnici";
$rezultat1 = mysql_query($upit);
if (mysql_errno())
{
die("<BR>" . mysqlerrno() . ":" . mysql_error() . "<BR>");
}

while ($red = mysql_fetch_row($rezultat1))
{
if (mysql_errno())
{
die("<BR>" . mysqlerrno() . ":" . mysql_error() . "<BR>");
}
foreach ($red as $juzer)
{
$i = 0;
$username["$i"] = $juzer;
$i++;
}
}


??

i found how....

I know this isn't about your question but you might want to
consider using the encryption function for your password field.
Encrypt the password before storing, and when you need to
authenticate someone, run their entered password through the
same function, and compare to the stored value.

yes, i encrypted my passwords. but do you know any way how to authorizate? i made 1st autorization page, but when i type password, i enter the page news.php. But if i enter http://localhost/admin/news.php, i can access that page without autentification. How ti change that?