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:
<?
$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);