Scripts - Tutorials - Forum - Downloads - Showcase - Contact

Artikels

VPN vergelijken

Algemeen

Beginpagina

FAQ

Grafische worm (243)

Links

Nieuwsartikels

Nieuwsarchief

Boeken programmeren

Overzicht

Samenwerken

Webhosting

Zoek op Sitemasters

Leden

Registreren

Ledenlijst

Ons team

Links

webhostingtop10.be

Sociale media

Follow @sitemasters

Sitemasters

Adverteren op Sitemasters?

Contacteer ons

RSS

Link naar ons

Donaties

Poll

Je moet ingelogd zijn om te stemmen.

Statistieken

Linkpartners

Forum

Categorieën > PHP & SQL

Error!:S

tomk - 10/07/2005 12:45

ASP interesse

Ej mensen ik krijg deze error:
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/carriere-manager.nl/www/competities.php on line 31

Hier mijn script:

php code - Bekijk de code zonder highlighting - Klap code in

<?
ob_start();
session_start();
include("functies.php");

$var = "iedereen";
$toegang = beveiliging($var);
$ban = ban();

if(!$toegang == 0) {
	if(!$ban == 1) {
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Carriere-Manager :: Competitie's</title>
</head>

<body>
<font size="2"><strong>Competitie's</strong></font> 
<table width="437" cellspacing="0" cellpadding="0">
  <tr>
    <td width="36"><font size="2"><strong>Comp/Beker</strong></font></td>
    <td width="94"><font size="2"><strong>Competitie Naam</strong></font></td>
    <td width="130"><font size="2"><strong>Spelers Kunnen Joinen</strong></font></td>
    <td width="74"><font size="2"><strong>Land 
<?
$tp_sql = "SELECT compnaam, spelers, land FROM competities ORDER BY compnaam DESC LIMIT 1000000";
$tp_res = mysql_query($tp_sql);
while($tp = mysql_fetch_assoc($tp_res)) {
?>
      </strong></font></td>
  </tr>
</table>
<table width="437" height="18" cellpadding="0" cellspacing="0">
  <tr> 
    <td width="81"><strong><font size="2"><strong><? echo $tp['type']; ?></strong></font> 
      </strong></td>
    <td width="108"><font size="2"><strong><? echo $tp['compnaam']; ?></strong></font></td>
    <td width="154"><font size="2"><strong><? echo $tp['spelers']; ?></strong></font></td>
    <td width="92"><font size="2"><strong><img src="<? echo $tp['compland']; ?>" alt="image" name="button" width="18" height="12" /> 
      <?
}
?>
      </strong></font></td>
  </tr>
</table>
<p>&nbsp; </p>
<p>&nbsp;</p><p>&nbsp;</p></body>
</html>
<?
	} else {
		$sql = "SELECT * FROM ban WHERE ip='".$_SERVER['REMOTE_ADDR']."'";
		$res = mysql_query($sql);
		$fet = mysql_fetch_assoc($res);
		$mes = $fet['mes'];
		echo $mes;
	}
} else {
echo "U bent niet bevoegd om deze pagina te bekijken";
}
ob_end_flush();
?>

<?
ob_start();
session_start();
include("functies.php");
 
$var = "iedereen";
$toegang = beveiliging($var);
$ban = ban();
 
if(!$toegang == 0) {
	if(!$ban == 1) {
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Carriere-Manager :: Competitie's</title>
</head>
 
<body>
<font size="2"><strong>Competitie's</strong></font> 
<table width="437" cellspacing="0" cellpadding="0">
  <tr>
    <td width="36"><font size="2"><strong>Comp/Beker</strong></font></td>
    <td width="94"><font size="2"><strong>Competitie Naam</strong></font></td>
    <td width="130"><font size="2"><strong>Spelers Kunnen Joinen</strong></font></td>
    <td width="74"><font size="2"><strong>Land 
<?
$tp_sql = "SELECT compnaam, spelers, land FROM competities ORDER BY compnaam DESC LIMIT 1000000";
$tp_res = mysql_query($tp_sql);
while($tp = mysql_fetch_assoc($tp_res)) {
?>
      </strong></font></td>
  </tr>
</table>
<table width="437" height="18" cellpadding="0" cellspacing="0">
  <tr> 
    <td width="81"><strong><font size="2"><strong><? echo $tp['type']; ?></strong></font> 
      </strong></td>
    <td width="108"><font size="2"><strong><? echo $tp['compnaam']; ?></strong></font></td>
    <td width="154"><font size="2"><strong><? echo $tp['spelers']; ?></strong></font></td>
    <td width="92"><font size="2"><strong><img src="<? echo $tp['compland']; ?>" alt="image" name="button" width="18" height="12" /> 
      <?
}
?>
      </strong></font></td>
  </tr>
</table>
<p>&nbsp; </p>
<p>&nbsp;</p><p>&nbsp;</p></body>
</html>
<?
	} else {
		$sql = "SELECT * FROM ban WHERE ip='".$_SERVER['REMOTE_ADDR']."'";
		$res = mysql_query($sql);
		$fet = mysql_fetch_assoc($res);
		$mes = $fet['mes'];
		echo $mes;
	}
} else {
echo "U bent niet bevoegd om deze pagina te bekijken";
}
ob_end_flush();
?>

4 antwoorden

Gesponsorde links

smoos - 10/07/2005 12:57

PHP gevorderde

php code - Bekijk de code zonder highlighting - Klap code in

<?
$tp_sql = "SELECT `compnaam`, `spelers`, `land` FROM `competities` ORDER BY `compnaam` DESC LIMIT 1000000";
$tp_res = mysql_query($tp_sql);
while($tp = mysql_fetch_assoc($tp_res)) {
?>

<?
$tp_sql = "SELECT `compnaam`, `spelers`, `land` FROM `competities` ORDER BY `compnaam` DESC LIMIT 1000000";
$tp_res = mysql_query($tp_sql);
while($tp = mysql_fetch_assoc($tp_res)) {
?>

probeer eens

Joel - 10/07/2005 12:59
Eigenaar		SELECT compnaam, spelers, land FROM competities ORDER BY compnaam DESC LIMIT 1000000 voer deze query is in, in phpmyadmin of een ander program. Misschien is de query fout? Bestaat er een kolomnaam niet ofzoiets

tomk - 10/07/2005 12:59
ASP interesse		Nope werkt niet krijg nog steeds zelfde error als ik dat doe.

tomk - 10/07/2005 13:01
ASP interesse		Heb de errror al.. land moest compland zijn^^. Bedankt!

Gesponsorde links

Dit onderwerp is gesloten.

Actiefste leden van de maand

Actieve forumberichten