---
title: "wtf är fel?"
type: "forum-thread"
url: "https://www.webforum.nu/amne/php/47828-wtf-är-fel"
topic: "PHP"
topic_url: "https://www.webforum.nu/amne/php"
author: "vippersdomain"
published: "2002-07-13T20:01:39.000Z"
updated: "2002-07-15T07:30:24.000Z"
replies: 23
views: 441
page: 1
pages: 2
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/php/47828-wtf-är-fel"
---

# wtf är fel?

_Sida 1 av 2._

## #1 — vippersdomain, 2002-07-13T20:01Z

Warning: Supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/vippersdomain.com/httpdocs/statistik/stat.php on line 5

Kod: 

```
<? 
include("variabler.php");
$sql = "SELECT * FROM stat_historia WHERE sajt = '$sajtinfo' ORDER BY flest DESC";
$que = mysql_query($sql);
while ($rad = mysql_fetch_array($que)) { //Rad 5
$sajt1 = $rad["sajt"];
$flest = $rad["flest"];
}
?>

<?
include("variabler.php");
$sql = "SELECT * FROM statmember WHERE  sajtnamn= '$sajtinfo'";
$que = mysql_query($sql);
while ($rad = mysql_fetch_array($que)) {
$uid      = $rad["uid"];
$sajtnamn = $rad["sajtnamn"];
$email    = $rad["email"];
$url      = $rad["url"];
$datum_1  = $rad["datum_1"];

}
?>
```

Permalänk: https://www.webforum.nu/p/47828

## #2 — vippersdomain, 2002-07-13T21:20Z

ingen kan alltså?

Permalänk: https://www.webforum.nu/p/720983

## #3 — zOLOz, 2002-07-13T21:53Z

ändra

```php
$sql = "SELECT * FROM stat_historia WHERE sajt = '$sajtinfo' ORDER BY flest DESC";
$que = mysql_query($sql);
```

 till

```php
$que = mysql_query($sql = "SELECT * FROM stat_historia WHERE sajt = '$sajtinfo' ORDER BY flest DESC");
```

Permalänk: https://www.webforum.nu/p/720992

## #4 — zOLOz, 2002-07-13T21:54Z

oj.. fel av mig..

```php
$que = mysql_query("SELECT * FROM stat_historia WHERE sajt = '$sajtinfo' ORDER BY flest DESC");
```

Permalänk: https://www.webforum.nu/p/720993

## #5 — vippersdomain, 2002-07-13T22:01Z

ska testa!

Permalänk: https://www.webforum.nu/p/720995

## #6 — vippersdomain, 2002-07-13T22:05Z

lol=

Warning: Supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/vippersdomain.com/httpdocs/statistik/stat.php on line 5

Warning: Supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/vippersdomain.com/httpdocs/statistik/stat.php on line 15

```
<? 
include("variabler.php");
$sql = "SELECT * FROM stat_historia WHERE sajt = '$sajtinfo' ORDER BY flest DESC";
$que = mysql_query("SELECT * FROM stat_historia WHERE sajt = '$sajtinfo' ORDER BY flest DESC");
while ($rad = mysql_fetch_array($que)) {
$sajt1 = $rad["sajt"];
$flest = $rad["flest"];
}
?>

<?
include("variabler.php");
$sql = "SELECT * FROM statmember WHERE  sajtnamn= '$sajtinfo'";
$que = mysql_query("SELECT * FROM stat_historia WHERE sajt = '$sajtinfo' ORDER BY flest DESC");
while ($rad = mysql_fetch_array($que)) {
$uid      = $rad["uid"];
$sajtnamn = $rad["sajtnamn"];
$email    = $rad["email"];
$url      = $rad["url"];
$datum_1  = $rad["datum_1"];

}
?>
```

Permalänk: https://www.webforum.nu/p/720997

## #7 — vippersdomain, 2002-07-13T22:12Z

stog så när jag bara hade så på den överst kod snutten också

Permalänk: https://www.webforum.nu/p/720999

## #8 — vippersdomain, 2002-07-13T22:23Z

<http://www.vippersdomain.com/statistik/stat.php?sajtinfo=Carlzon.com>

värkar inte fuka alls :/

Permalänk: https://www.webforum.nu/p/721001

## #9 — Batboy, 2002-07-14T07:08Z

Använd alltid:

```
$que = mysql_query($sql)
[b]	or die ("Query misslyckades");[/b]
```

Felet kan även ligga tidigare i din kod, återigen använd **or die** så får du enkelt reda på vad som är fel:

```
mysql_connect ("$mysql_host", "$mysql_u", "$mysql_p")
	[b]or die ("Ingen kontakt med MySQL");[/b]

mysql_select_db ("$mysql_db")
	[b]or die ("Kan inte välja DB");[/b]
```

Permalänk: https://www.webforum.nu/p/721048

## #10 — prey, 2002-07-14T07:50Z

Har du databasanslutningen i "variabler.php"?

```php
<?
$länk = mysql_connect('host','user','pass');   //Inte säker på parameterordningen
$db = mysql_select_db("mindatabas");

$sql = "SELECT * FROM stat_historia WHERE sajt = '$sajtinfo' ORDER BY flest DESC";
$resultat = mysql_query("$sql");
while($rad = mysql_fetch_array($result)){
     $sajt1 = $rad["sajt"];
     $flest = $rad["flest"];
     //Lägg in en "echo" för att se om det funkar:
    echo "$sajt1, $flest...";
}
mysql_close($länk);
```

Om detta inte fungerar, kontrollera om tabellen "stat_historia" finns, och att kolumnerna "flest" och "sajt" finns... Annars vette fan.. =)

Permalänk: https://www.webforum.nu/p/721051

## #11 — vippersdomain, 2002-07-14T11:48Z

ja

Permalänk: https://www.webforum.nu/p/721112

## #12 — vippersdomain, 2002-07-14T11:50Z

ska kolla, är säker på att dom finns..

Permalänk: https://www.webforum.nu/p/721113

## #13 — vippersdomain, 2002-07-14T13:20Z

jag kom på en grej, i stat.php så finns inte en enda kod snutt som kopplar upp til mySQL databasen, hehe visst kan det vara felet?

Permalänk: https://www.webforum.nu/p/721153

## #14 — vippersdomain, 2002-07-14T13:21Z

stat.php:

\<? 
include("variabler.php");
$sql = "SELECT \* FROM stat_historia WHERE sajt = '$sajtinfo' ORDER BY flest DESC";
$que = mysql_query($sql);
while ($rad = mysql_fetch_array($que)) {
$sajt1 = $rad\["sajt"\];
$flest = $rad\["flest"\];
}
?\>

\<?
include("variabler.php");
$sql = "SELECT \* FROM statmember WHERE  sajtnamn= '$sajtinfo'";
$que = mysql_query($sql);
while ($rad = mysql_fetch_array($que)) {
$uid      = $rad\["uid"\];
$sajtnamn = $rad\["sajtnamn"\];
$email    = $rad\["email"\];
$url      = $rad\["url"\];
$datum_1  = $rad\["datum_1"\];

}
?\>

Permalänk: https://www.webforum.nu/p/721154

## #15 — vippersdomain, 2002-07-14T13:22Z

resteN:

\<html\>
\<head\>
\<title\>Statistik\</title\>
\<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"\>
\<link rel="stylesheet" href="http://www.vippersdomain.com/vdstyle1.css" type="text/css"\>
\</head\>

\<body text="#000000" topmargin ="0" leftmargin="0" bgcolor="#FFFFFF"\>
\<table width="100%" border="0" cellspacing="0" cellpadding="0" height="512" class="gr&aring;tjock"\>
  \<tr align="left" valign="top"\> 
    \<td width="87%" align="center"\> 
      \<table width="627" border="0" cellspacing="0" cellpadding="0" height="517" class="tinatabelllinje"\>
        \<tr align="left" valign="top"\>
          \<td width="2" class="tinavit" height="10"\>&nbsp;\</td\>
          \<td width="625" class="tinavit" height="10"\>Hitta din egen gratis r&auml;knare 
            p&aring; \<a href="http://www.vippersdomain.com/" target="\_blank"\><http://www.vippersdomain.com/>\</a\>\</td\>
        \</tr\>
        \<tr align="left" valign="top"\> 
          \<td width="2" class="tinavit" height="10"\>&nbsp;\</td\>
          \<td width="625" class="tinavit" height="10"\> 
            \<?// här börjar koden
						include("variabler.php");
						$sql = "SELECT \* FROM stat WHERE sajt = '$sajtnamn'";
						$que = mysql_query($sql);
						while($rad = mysql_fetch_array($que)) {
						$id              = $rad\["id"\];
						$sajt            = $rad\["sajt"\];
						$besökare_idag   = $rad\["besökare_idag"\];
						$flest_besökare  = $rad\["flest_besökare"\];
						$tot_visningar   = $rad\["tot_visningar"\];
						$sista_klockan   = $rad\["sista_klockan"\];
						$sista_lev       = $rad\["sista_lev"\];
						$member_id       = $rad\["member_id"\];
						$cool            = $rad\["cool"\];
						$datu2            = $rad\["datu"\];
						$ru = mysql_num_rows($que);
						$rue = $ru - 1;
						
						?\>
          \</td\>
        \</tr\>
        \<tr align="left" valign="top"\> 
          \<td width="2" class="tinavit"\>&nbsp;\</td\>
          \<td width="625" class="tinavit"\> \<span class="tinatjock"\> 
            \<?=$sajt?\>
            \</span\>\<span class="tinatjocksvart"\>'s Statistiksida \</span\> 
            \<table width="110%" border="0" cellspacing="0" cellpadding="0"\>
              \<tr align="left" valign="top"\> 
                \<td height="16"\>&nbsp;\</td\>
                \<td height="16"\>&nbsp;\</td\>
              \</tr\>
              \<tr align="left" valign="top"\> 
                \<td height="100"\> 
                  \<table width="245" border="0" cellspacing="0" cellpadding="0" class="tinatabelllinjevitext"\>
                    \<tr\> 
                      \<td width="244" align="left" valign="middle" class="tinavit"\>\<b\>Sajtinfo\</b\>\</td\>
                    \</tr\>
                  \</table\>
                  \<table width="245" border="0" cellspacing="0" cellpadding="0" class="tinavit"\>
                    \<tr\> 
                      \<td width="245" height="87" align="left" valign="top"\> 
                        \<table width="245" border="0" cellspacing="0" cellpadding="0" class="tinavit"\>
                          \<tr align="left" valign="middle"\> 
                            \<td width="108"\>\<b\>\</b\>\</td\>
                            \<td width="125"\>&nbsp;\</td\>
                          \</tr\>
                          \<tr align="left" valign="middle"\> 
                            \<td width="108"\>\<b\>Tj&auml;nsten startades:\</b\>\</td\>
                            \<td width="125" class="tinavit"\> 
                              \<?=$datum_1?\>
                            \</td\>
                          \</tr\>
                          \<tr align="left" valign="middle"\> 
                            \<td width="108"\>\<b\>Totala visningar:\</b\>\</td\>
                            \<td width="125" class="tinavit"\> 
                              \<?=$rue?\>
                            \</td\>
                          \</tr\>
                          \<tr align="left" valign="middle"\> 
                            \<td width="108"\>\<b\>Bes&ouml;kare idag:\</b\>\</td\>
                            \<td width="125" class="tinavit"\> 
                              \<? include("variabler.php");
										$date_y = date("y-m-d");
										$kkk = "SELECT \* FROM stat WHERE sajt = '$sajtnamn' AND datu = '$date_y'";
										$ppp = mysql_query($kkk);
										
										$sss = mysql_num_rows($ppp); ?\>

Permalänk: https://www.webforum.nu/p/721155

## #16 — vippersdomain, 2002-07-14T13:22Z

resten igen :D

  \<? echo"$sss "; ?\>
                            \</td\>
                          \</tr\>
                        \</table\>
                        \<table width="100%" border="0" cellspacing="0" cellpadding="0" class="gr&aring;"\>
                          \<tr\> 
                            \<td align="left" valign="top"\>&nbsp;\</td\>
                          \</tr\>
                          \<tr\> 
                            \<td align="left" valign="top"\>\<span class="gr&aring;tjock"\>Direct 
                              Access\</span\> = Direkttr&auml;ff\</td\>
                          \</tr\>
                        \</table\>
                      \</td\>
                    \</tr\>
                  \</table\>
                \</td\>
                \<td height="100"\>&nbsp;\</td\>
              \</tr\>
            \</table\>
            \<table width="624" border="0" cellspacing="0" cellpadding="0" class="tinatabelllinjevitext"\>
              \<tr\> 
                \<td width="624" align="left" valign="top" class="tinavit" bgcolor="#EFEFEF"\> 
                  \<b\>Senaste 20 bes&ouml;karna\</b\>\</td\>
              \</tr\>
            \</table\>
            \<?// här börjar koden
						include("variabler.php");
						$sql = "SELECT \* FROM stat WHERE sajt = '$sajtnamn' ORDER BY id DESC LIMIT 20";
						$que = mysql_query($sql);
						while($rad = mysql_fetch_array($que)) {
						$id              = $rad\["id"\];
						$sajt            = $rad\["sajt"\];
						$besökare_idag   = $rad\["besökare_idag"\];
						$tio_sista       = $rad\["tio_sista"\];
						$tot_visningar   = $rad\["tot_visningar"\];
						$sista_klockan   = $rad\["sista_klockan"\];
						$sista_lev       = $rad\["sista_lev"\];
						$member_id       = $rad\["member_id"\];
						$cool            = $rad\["cool"\];
						$x++;
                        if ($x%2) { $bgcolor = "#EFEFEF"; } else { $bgcolor = "#FFFFFF"; }
						
						?\>
            \<table width="623" border="0" cellspacing="0" cellpadding="0" class="tinavit" bgcolor="\<?=$bgcolor?\>"\>
              \<tr\> 
                \<td width="526" align="left" valign="top" class="gr&aring;tjock"\> 
                  \<?
				  if (empty($tio_sista)) {
				 echo"Direct Access";
				  }
				  else {				  
				  echo"\<a href=$tio_sista\>$tio_sista\</a\>";
				  }
				   ?\>
                \</td\>
                \<td width="97" align="left" valign="top" class="gr&aring;tjock"\> 
                  \<?
				  if (empty($sista_klockan)) {
				  echo"";
				  }
				  else {				  
				  echo"$sista_klockan";
				  }
				   ?\>
                \</td\>
              \</tr\>
            \</table\>
            \<?}?\>
            \<table width="100%" border="0" cellspacing="0" cellpadding="0"\>
              \<tr\> 
                \<td\>&nbsp;\</td\>
              \</tr\>
            \</table\>
            \<table width="624" border="0" cellspacing="0" cellpadding="0" class="tinatabelllinjevitext"\>
              \<tr\> 
                \<td width="624" align="left" valign="top" class="tinavit" bgcolor="#EFEFEF"\> 
                  \<b\>B&auml;sta Referenserna\</b\>\</td\>
              \</tr\>
            \</table\>
            \<?// här börjar koden
						include("variabler.php");
						$sql = "SELECT DISTINCT tio_sista FROM stat WHERE sajt = '$sajtnamn' ORDER BY antal DESC";
						$que = mysql_query($sql);
						while($rad = mysql_fetch_array($que)) {
						$id              = $rad\["id"\];
						$sajt            = $rad\["sajt"\];
						$besökare_idag   = $rad\["besökare_idag"\];
						$tio_sista       = $rad\["tio_sista"\];
						$tot_visningar   = $rad\["tot_visningar"\];
						$sista_klockan   = $rad\["sista_klockan"\];
						$sista_lev       = $rad\["sista_lev"\];
						$member_id       = $rad\["member_id"\];
						$cool            = $rad\["antal"\];
		$x++;
                        if ($x%2) { $bgcolor = "#EFEFEF"; } else { $bgcolor = "#FFFFFF"; }
						
						
						?\>
            \<?
						include("variabler.php");
						$asp = "SELECT \* FROM stat WHERE tio_sista = '$tio_sista' AND sajt = '$sajtnamn' ORDER BY antal DESC";
						$psa = mysql_query($asp);
						$antal = mysql_num_rows($psa);
						
						$sss = "UPDATE stat SET antal = $antal WHERE tio_sista = '$tio_sista' AND sajt = '$sajtnamn'";
						$ooo = mysql_query($sss);
						
						?\>
            \<table width="623" border="0" cellspacing="0" cellpadding="0" class="tinavit" bgcolor="\<?=$bgcolor?\>"\>
              \<tr\> 
                \<td width="526" align="left" valign="top" class="gr&aring;tjock"\> 
                  \<?                
				  if (empty($tio_sista)) {
				 echo"Direct Access";
				  }
				  else {				  
				  echo"$tio_sista";
				  }
				   ?\>
                \</td\>
                \<td width="97" align="left" valign="top" class="gr&aring;tjock"\> 
                  \<?              
				  if (empty($tio_sista)) {
				 echo"$antal";
				  }
				  else {				  
				  echo"$antal";
				  }
				   ?\>
                \</td\>
              \</tr\>
            \</table\>
            \<?}?\>
            \<table width="100%" border="0" cellspacing="0" cellpadding="0" class="tinavit"\>
              \<tr\> 
                \<td\>&nbsp;\</td\>
              \</tr\>
            \</table\>
            \<table width="624" border="0" cellspacing="0" cellpadding="0" class="tinatabelllinjevitext"\>
              \<tr\> 
                \<td width="624" align="left" valign="top" class="tinavit" bgcolor="#EFEFEF"\> 
                  \<b\>Sk&auml;rmuppl&ouml;sningarna\</b\>\</td\>
              \</tr\>
            \</table\>
            \<?// här börjar koden
						include("variabler.php");
						$sql = "SELECT DISTINCT storlek FROM stat WHERE sajt = '$sajtnamn' ";
						$que = mysql_query($sql);
						while($rad = mysql_fetch_array($que)) {
						$id              = $rad\["id"\];
						$sajt            = $rad\["sajt"\];
						$besökare_idag   = $rad\["besökare_idag"\];
						$tio_sista       = $rad\["tio_sista"\];
						$tot_visningar   = $rad\["tot_visningar"\];
						$sista_klockan   = $rad\["sista_klockan"\];
						$sista_lev       = $rad\["sista_lev"\];
						$member_id       = $rad\["member_id"\];
						$storlek         = $rad\["storlek"\];
		$x++;
                        if ($x%2) { $bgcolor = "#EFEFEF"; } else { $bgcolor = "#FFFFFF"; }
						
						
						?\>
            \<?			include("variabler.php");
						$asp1 = "SELECT \* FROM stat WHERE storlek = '$storlek' AND sajt = '$sajtnamn' ORDER BY antal DESC";
						$psa1 = mysql_query($asp1);
						$antal_stor = mysql_num_rows($psa1);
						
						
						$sss1 = "UPDATE stat SET storlek_antal = $antal_stor WHERE storlek = '$storlek' AND sajt = '$sajtnamn'";
						$ooo1 = mysql_query($sss1);
						
						?\>
            \<table width="623" border="0" cellspacing="0" cellpadding="0" class="tinavit" bgcolor="\<?=$bgcolor?\>"\>
              \<tr\> 
                \<td width="526" align="left" valign="top" class="gr&aring;tjock"\> 
                  \<?=$storlek?\>
                \</td\>
                \<td width="97" align="left" valign="top" class="gr&aring;tjock"\> 
                  \<?=$antal_stor?\>
                \</td\>
              \</tr\>
            \</table\>
            \<?}?\>
            \<table width="100%" border="0" cellspacing="0" cellpadding="0" class="tinavit"\>
              \<tr\> 
                \<td\>&nbsp;\</td\>
              \</tr\>
            \</table\>
            \<table width="624" border="0" cellspacing="0" cellpadding="0" class="tinatabelllinjevitext"\>
              \<tr\> 
                \<td width="624" align="left" valign="top" class="tinavit" bgcolor="#EFEFEF"\> 
                  \<b\>Typ Av Browsers\</b\>\</td\>
              \</tr\>
            \</table\>
            \<?// här börjar koden
						include("variabler.php");
						$sql = "SELECT DISTINCT browser FROM stat WHERE sajt = '$sajtnamn' ORDER by brows_antal DESC ";
						$que = mysql_query($sql);
						while($rad = mysql_fetch_array($que)) {
						$id              = $rad\["id"\];
						$sajt            = $rad\["sajt"\];
						$besökare_idag   = $rad\["besökare_idag"\];
						$tio_sista       = $rad\["tio_sista"\];
						$tot_visningar   = $rad\["tot_visningar"\];
						$sista_klockan   = $rad\["sista_klockan"\];
						$sista_lev       = $rad\["sista_lev"\];
						$browser         = $rad\["browser"\];
						$storlek         = $rad\["storlek"\];
						$brows_antal        = $rad\["brows_antal"\];
		$x++;
                        if ($x%2) { $bgcolor = "#EFEFEF"; } else { $bgcolor = "#FFFFFF"; }
						
						
						?\>
            \<?			include("variabler.php");
						$asp11 = "SELECT \* FROM stat WHERE browser = '$browser' AND sajt = '$sajtnamn' ORDER BY brows_antal DESC";
						$psa11 = mysql_query($asp11);
						$antal_stor1 = mysql_num_rows($psa11);
						
						
						$sss1 = "UPDATE stat SET brows_antal = $antal_stor1 WHERE browser = '$browser' AND sajt = '$sajtnamn' ORDER BY brows_antal DESC";
						$ooo1 = mysql_query($sss1);
						
						?\>
            \<table width="623" border="0" cellspacing="0" cellpadding="0" class="tinavit" bgcolor="\<?=$bgcolor?\>"\>
              \<tr\> 
                \<td width="526" align="left" valign="top" class="gr&aring;tjock"\> 
                  \<?=$browser?\>
                \</td\>
                \<td width="97" align="left" valign="top" class="gr&aring;tjock"\> 
                  \<?=$antal_stor1?\>
                \</td\>
              \</tr\>
            \</table\>
            \<?}?\>
            \<table width="100%" border="0" cellspacing="0" cellpadding="0" class="tinavit"\>
              \<tr\> 
                \<td\>&nbsp;\</td\>
              \</tr\>
            \</table\>
          \</td\>
        \</tr\>
      \</table\>
      \<?}?\>
    \</td\>
  \</tr\>
\</table\>
\</body\>
\</html\>

Permalänk: https://www.webforum.nu/p/721156

## #17 — vippersdomain, 2002-07-14T13:22Z

vart skall jag sätta uppkopplingen till databasen och hur?

Permalänk: https://www.webforum.nu/p/721157

## #18 — vippersdomain, 2002-07-14T13:35Z

kom på att uppkopplingen låg i variablar.ph oooppsss :/

men vad kan vara fel?

Permalänk: https://www.webforum.nu/p/721161

## #19 — vippersdomain, 2002-07-14T13:46Z

dom tabellerna man fick till scriptet var stat och statmember, dom andra finns ej :/

Permalänk: https://www.webforum.nu/p/721166

## #20 — vippersdomain, 2002-07-14T13:48Z

kolla: <http://www.vippersdomain.com/statistik/stat.php?sajtinfo=Carlzon.com%20&emailinfo=nille@carlzon.com>

Permalänk: https://www.webforum.nu/p/721168

---

Tråden på webben: https://www.webforum.nu/amne/php/47828-wtf-är-fel  
Nästa sida: https://www.webforum.nu/amne/php/47828-wtf-är-fel/page2.md