2 Queries

Hey,

Ik ben bezig met een bellijn, alleen ik heb nu dit:

[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/session_start"]session_start[/URL][COLOR= #007700]();[/COLOR]

[COLOR= #0000BB]$checkopen[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM radio WHERE bel=open"[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$checkopen[/COLOR][COLOR= #007700]) ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]) {[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<strong>Helaas de Huidige DJ heeft de Bellijn gesloten.</strong>"[/COLOR][COLOR= #007700];
}[/COLOR] [URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$checkopen[/COLOR][COLOR= #007700]) ==[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700])[/COLOR]
                        [COLOR= #0000BB]$rijsql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM bellen"[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
[URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$rijen[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_object"]mysql_fetch_object[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$rijsql[/COLOR][COLOR= #007700])) {{[/COLOR]
                        [COLOR= #0000BB]$rijsql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM djzegt"[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
[URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$rijen[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_object"]mysql_fetch_object[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$rijsql[/COLOR][COLOR= #007700])) {{[/COLOR]

[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<a href=skype:"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$rijen[/COLOR][COLOR= #007700]->[/COLOR]skypenaam[COLOR= #007700].[/COLOR][COLOR= #DD0000]"?call >Bel de draaiende DJ: "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$rijen[/COLOR][COLOR= #007700]->[/COLOR]djnaam[COLOR= #007700].[/COLOR][COLOR= #DD0000]"</a>"[/COLOR][COLOR= #007700];
}
}[/COLOR]

?>

Ik wil de 2 Queries gebruiken, maar dit werkt niet, hoe moet ik het doen?:

$rijsql = mysql_query("SELECT * FROM bellen") or die(mysql_error());
while($rijen = mysql_fetch_object($rijsql)) {{
                        $rijsql = mysql_query("SELECT * FROM djzegt") or die(mysql_error());
while($rijen = mysql_fetch_object($rijsql)) {{

$checkopen = mysql_query("SELECT * FROM radio WHERE bel=open");

if(mysql_num_rows($checkopen) == 1)
{
    $rijsql = mysql_query("SELECT * FROM bellen b, djzegt d") or die(mysql_error());
    while($rijen = mysql_fetch_assoc($rijsql)) 
    {

        echo <a href=skype:.$rijen[skypenaam].?call >Bel de draaiende DJ: .$rijen[djnaam].</a>;
    }
}
else
    echo "<strong>Helaas de Huidige DJ heeft de Bellijn gesloten.</strong>";

Works, dankje!

Geen probleem