gegevens ophalen probleem

Hoi phphulp!

Ik heb een code gemaakt die gegevens moet ophalen uit een database voor later gebruik... Hierbij zit geen foutafhandeling, omdat ik die niet nodig heb...
Als ik het test krijg ik deze fout:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\gegevensophalen.php on line 18

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\gegevensophalen.php on line 28


mysql_fetch_assoc zou sneller zijn dan mysql_fetch_array.. Maar een paar miliseconde ofzoo, maar het is wel sneller en daarom gebruik ikhet.. Ik heb ook mysql_fetch_array geprobeerd, maar dan krijg ik dezelfde fout met mysql_fetch_array...

Weet iemand het..?

Code:

<?php
/* Errors weergeven */
error_reporting(E_ALL | E_STRICT);
ini_set("display_errors", 1);

$host = 'xxx';
$gb = 'xxx';
$ww = 'xxx';

$db = 'xxx';

$conn = mysql_connect($host, $gb, $ww);
mysql_select_db($db) or die(mysql_error());

$query = "SELECT * FROM dierenarts ORDER BY bezoeken DESC LIMIT 5";
$uitvoeren = mysql_query($query);

while($rij = mysql_fetch_assoc($uitvoeren));

$db1 = 'leden';

$conn1 = mysql_connect($host, $gb, $ww);
mysql_select_db($db1) or die(mysql_error());

$query1 = "SELECT * FROM leden ORDER BY geld DESC LIMIT 5";
$uitvoeren1 = mysql_query($query1);

while($rij1 = mysql_fetch_assoc($uitvoeren1));

$db2 = 'paarden';

$conn2 = mysql_connect($host, $gb, $ww);
mysql_select_db($db2) or die(mysql_error());

$query2 = "SELECT * FROM paarden ORDER BY sdg DESC LIMIT 5";
$uitvoeren2 = mysql_query($query2);

while($rij2 = mysql_fetch_assoc($uitvoeren2));

$db3 = 'leden';

$conn3 = mysql_connect($host, $gb, $ww);
mysql_select_db($db3) or die(mysql_error());

$query3 = "SELECT * FROM leden ORDER BY klusjes DESC LIMIT 5";
$uitvoeren3 = mysql_query($query3);

while($rij3 = mysql_fetch_assoc($uitvoeren3));

$db4 = 'leden';

$conn4 = mysql_connect($host, $gb, $ww);
mysql_select_db($db4) or die(mysql_error());

$query4 = "SELECT * FROM leden ORDER BY Marathon DESC LIMIT 5";
$uitvoeren4 = mysql_query($query4);

while($rij4 = mysql_fetch_assoc($uitvoeren4));

$db5 = 'leden';

$conn5 = mysql_connect($host, $gb, $ww);
mysql_select_db($db5) or die(mysql_error());

$query5 = "SELECT * FROM leden ORDER BY gefokt DESC LIMIT 5";
$uitvoeren5 = mysql_query($query5);

while($rij5 = mysql_fetch_assoc($uitvoeren5));

$db6 = 'leden';

$conn6 = mysql_connect($host, $gb, $ww);
mysql_select_db($db6) or die(mysql_error());

$query6 = "SELECT * FROM leden ORDER BY mendressuur DESC LIMIT 5";
$uitvoeren6 = mysql_query($query6);

while($rij6 = mysql_fetch_assoc($uitvoeren6));

$db7 = 'medewerkers';

$conn7 = mysql_connect($host, $gb, $ww);
mysql_select_db($db7) or die(mysql_error());

$query7 = "SELECT * FROM medewerkers ORDER BY bwvragen DESC LIMIT 5";
$uitvoeren7 = mysql_query($query7);

while($rij7 = mysql_fetch_assoc($uitvoeren7));

$db8 = 'leden';

$conn8 = mysql_connect($host, $gb, $ww);
mysql_select_db($db8) or die(mysql_error());

$query8 = "SELECT * FROM leden ORDER BY menvaardigheid DESC LIMIT 5";
$uitvoeren8 = mysql_query($query8);

while($rij8 = mysql_fetch_assoc($uitvoeren8));

$db9 = 'hoefsmid';

$conn9 = mysql_connect($host, $gb, $ww);
mysql_select_db($db) or die(mysql_error());

$query9 = "SELECT * FROM hoefsmid ORDER BY bezoeken DESC LIMIT 5";
$uitvoeren9 = mysql_query($query9);

while($rij9 = mysql_fetch_assoc($uitvoeren9));

$db10 = 'instructeurdressuur';

$conn10 = mysql_connect($host, $gb, $ww);
mysql_select_db($db1) or die(mysql_error());

$query10 = "SELECT * FROM instructeurdressuur ORDER BY bezoeken DESC LIMIT 5";
$uitvoeren10 = mysql_query($query10);

while($rij10 = mysql_fetch_assoc($uitvoeren10));

$db11 = 'instructeurspringen';

$conn11 = mysql_connect($host, $gb, $ww);
mysql_select_db($db2) or die(mysql_error());

$query11 = "SELECT * FROM instructeurspringen ORDER BY bezoeken DESC LIMIT 5";
$uitvoeren11 = mysql_query($query11);

while($rij11 = mysql_fetch_assoc($uitvoeren11));

$db12 = 'instructeurwestern';

$conn12 = mysql_connect($host, $gb, $ww);
mysql_select_db($db12) or die(mysql_error());

$query12 = "SELECT * FROM instructeurwestern ORDER BY bezoeken DESC LIMIT 5";
$uitvoeren12 = mysql_query($query12);

while($rij12 = mysql_fetch_assoc($uitvoeren12));

$db13 = 'zadelmaktrainer';

$conn13 = mysql_connect($host, $gb, $ww);
mysql_select_db($db4) or die(mysql_error());

$query13 = "SELECT * FROM zadelmaktrainer ORDER BY bezoeken DESC LIMIT 5";
$uitvoeren13 = mysql_query($query13);

while($rij13 = mysql_fetch_assoc($uitvoeren13));

$db14 = 'leden';

$conn14 = mysql_connect($host, $gb, $ww);
mysql_select_db($db14) or die(mysql_error());

$query14 = "SELECT * FROM leden ORDER BY dressuurwinstpunten DESC LIMIT 5";
$uitvoeren14 = mysql_query($query14);

while($rij14 = mysql_fetch_assoc($uitvoeren14));

$db15 = 'leden';

$conn15 = mysql_connect($host, $gb, $ww);
mysql_select_db($db6) or die(mysql_error());

$query15 = "SELECT * FROM leden ORDER BY springwinstpunten DESC LIMIT 5";
$uitvoeren15 = mysql_query($query15);

while($rij15 = mysql_fetch_assoc($uitvoeren15));

$db16 = 'leden';

$conn16 = mysql_connect($host, $gb, $ww);
mysql_select_db($db7) or die(mysql_error());

$query16 = "SELECT * FROM leden ORDER BY eventingwinstpunten DESC LIMIT 5";
$uitvoeren16 = mysql_query($query16);

while($rij16 = mysql_fetch_assoc($uitvoeren16));

$db17 = 'leden';

$conn17 = mysql_connect($host, $gb, $ww);
mysql_select_db($db8) or die(mysql_error());

$query17 = "SELECT * FROM leden ORDER BY barrelwinstpunten DESC LIMIT 5";
$uitvoeren17 = mysql_query($query17);

while($rij17 = mysql_fetch_assoc($uitvoeren17));

$db18 = 'leden';

$conn18 = mysql_connect($host, $gb, $ww);
mysql_select_db($db) or die(mysql_error());

$query18 = "SELECT * FROM leden ORDER BY reingwinstpunten DESC LIMIT 5";
$uitvoeren18 = mysql_query($query18);

while($rij18 = mysql_fetch_assoc($uitvoeren18));

$db19 = 'leden';

$conn19 = mysql_connect($host, $gb, $ww);
mysql_select_db($db1) or die(mysql_error());

$query19 = "SELECT * FROM leden ORDER BY forumpost DESC LIMIT 5";
$uitvoeren19 = mysql_query($query19);

while($rij19 = mysql_fetch_assoc($uitvoeren19));

$db20 = 'manege';

$conn20 = mysql_connect($host, $gb, $ww);
mysql_select_db($db2) or die(mysql_error());

$query20 = "SELECT * FROM manege ORDER BY geld DESC LIMIT 5";
$uitvoeren20 = mysql_query($query20);

while($rij20 = mysql_fetch_assoc($uitvoeren20));

$db21 = 'club';

$conn21 = mysql_connect($host, $gb, $ww);
mysql_select_db($db3) or die(mysql_error());

$query21 = "SELECT * FROM club ORDER BY hoeveelleden DESC LIMIT 5";
$uitvoeren21 = mysql_query($query21);

while($rij21 = mysql_fetch_assoc($uitvoeren21));

?>