help with one error

Anon

i have this code in my page:
<?php
echo "<title>Prijava Administratora</title>";
echo "<body bgcolor=#000000 text=#ffffff link=#cccccc vlink=#cccccc alink=#cccccc>";
require ('konfiguracija.php');
$baza = mysql_connect("$adresabaze","$userbaze","$sifrabaze");
mysql_select_db("$bazapodataka",$baza);
$rezultat = mysql_query("SELECT * FROM admin",$baza);
while ($red = mysql_fetch_array($rezultat)) {
if($admininistrator==$red["admin_ime"] && ($administratorsifra==$red["admin_sifra"]))
{
setcookie("korisnik", "glavni");
echo "Uspjesno ste prijavljeni, prosljedjivanje je u toku! Ukoliko ne budete proslijedjeni za nekoliko sekundi, kliknite <a href=\"administrator.php\">ovdje</a>.";
} else {
echo "Pogresno korisnicko ime ili sifra! Kliknite <a href=\"logovanje.php\">ovdje</a> da pokusate ponovo!";
}
}
?>

and i get this error every time i try to load that page:

Warning: Supplied argument is not a valid MySQL result resource in c:\program files\apache group\apache\wwwroot\novosti\prijava.php on line 8

and line 8 is this:
while ($red = mysql_fetch_array($rezultat)) {

can anyone help me fix the problem?

Anon

Must be something wrong with the query. Try echoing out the error from mysql:

$rezultat = mysql_query("SELECT * FROM admin") or die("Query failed: " . mysql_error());

rajtpd

Your problem is here:

$rezultat = mysql_query(\"SELECT * FROM admin\",$baza);

put a single \' \' around $baza and it should work.

Try this:
$rezultat = mysql_query(\"SELECT * FROM admin\",\'$baza\');

Anon

I don't think so. $baza is the link identifier, not part of the query.

http://www.phpbuilder.com/manual/function.mysql-query.php