---
title: "Gillar inte min fetch_array"
type: "forum-thread"
url: "https://www.webforum.nu/amne/php/131106-gillar-inte-min-fetch-array"
topic: "PHP"
topic_url: "https://www.webforum.nu/amne/php"
author: "oskob"
published: "2005-07-07T21:14:51.000Z"
updated: "2005-07-07T22:15:50.000Z"
replies: 2
views: 228
page: 1
pages: 1
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/131106-gillar-inte-min-fetch-array"
---

# Gillar inte min fetch_array

## #1 — oskob, 2005-07-07T21:14Z

Har ett underligt problem.

Dessa två snuttar kod fungerar på min egna server men inte på webhotellet. 
Why oh why?

Har använt själva kommandot förr i andra databaser men nu helt plötsligt säger den ifrån.

```
$soka_ip = mysql_fetch_array(mysql_query("SELECT * FROM Counter WHERE IP='" . $_SERVER["REMOTE_ADDR"] . "'"));

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/oskob/beta.oskarart.net/oskarart/index.php on line 18

------------------------

$total_result = mysql_query("SELECT SUM(Counting) AS totalcount FROM Counter");

$besokare_totalt = mysql_result($total_result, 0);

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/oskob/beta.oskarart.net/oskarart/index.php on line 40
```

Hela koden:

```php

<?
$startmicrotime=microtime();

$pos = strpos($_SERVER["HTTP_USER_AGENT"], 'MSIE');

if ($pos === false) {
	$usingie = 'false';
} else {
	$usingie = 'true';
}

require('sidor/conn.php'); 

if (!isset($_COOKIE["counted"])) {

	$soka_ip = mysql_fetch_array(mysql_query("SELECT * FROM Counter WHERE IP='" . $_SERVER["REMOTE_ADDR"] . "'"));
	
	$denna_besokare = $soka_ip['Counting'];
	
	if ( $denna_besokare == "" ) {
		
		mysql_query("INSERT INTO Counter (Counting, IP) VALUES ('1', '" . $_SERVER["REMOTE_ADDR"] . "')");
		setcookie("counted", yes, time()+1600);
		
	}else{
		$denna_besokare ++;
		mysql_query("UPDATE Counter SET Counting='" . $denna_besokare . "' WHERE IP='" . $_SERVER["REMOTE_ADDR"] . "'") or die(mysql_error());
		setcookie("counted", yes, time()+1600);
	}
}

$result = mysql_query("SELECT COUNT(*) FROM counter");

$unika_besokare = mysql_result($result, 0);

$total_result = mysql_query("SELECT SUM(Counting) AS totalcount FROM Counter");

$besokare_totalt = mysql_result($total_result, 0);
```

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

## #2 — Peeer, 2005-07-07T21:46Z

Ersätt 

```
$soka_ip = mysql_fetch_array(mysql_query("SELECT * FROM Counter WHERE IP='" . $_SERVER["REMOTE_ADDR"] . "'"));
```

med

```
$resource = mysql_query("SELECT * FROM Counter WHERE IP='" . $_SERVER["REMOTE_ADDR"] . "'") or die(mysql_error());
$soka_ip = mysql_fetch_array($resource) or die(mysql_error());
```

För att få lite bättre felmeddelande.

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

## #3 — oskob, 2005-07-07T22:15Z

Mein gut... Hade skrivit med litet c i databasen på webservern...
Det verkar som om min inte är case sensetive för den reagerade intepå att vissa hette counter och vissa Counter.
Skummt.

Tack i alla fall!

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

---

Tråden på webben: https://www.webforum.nu/amne/php/131106-gillar-inte-min-fetch-array