---
title: "valid MYSQL result"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/77188-valid-mysql-result"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "sneeze"
published: "2003-05-16T21:39:10.000Z"
updated: "2003-05-17T08:40:44.000Z"
replies: 2
views: 156
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/databaser-sql/77188-valid-mysql-result"
---

# valid MYSQL result

## #1 — sneeze, 2003-05-16T21:39Z

Hej alla!
Något är inte som jag vill ha det :OO 

```php
 <?php
$server   = "localhost"; // MySQL hostname
$username = "***"; // MySQL username
$password = "***"; // MySQL password
$dbname   = "***"; // MySQL db name

$db = mysql_connect($server, $username, $password) or die(mysql_error());
      mysql_select_db($dbname) or die(mysql_error());

$sql = "SELECT ip2nationCountries.country FROM ip2nationCountries,ip2nation WHERE ip2nation.ip < INET_ATON('".$_SERVER['REMOTE_ADDR']."') AND ip2nationCountries.code = ip2nation.country ORDER BY ip2nation.ip DESC LIMIT 0,1";

$countryName = mysql_result(mysql_query($sql), 0, 0);

// Output full country name
echo $countryName;
?>
```

Resultat:

```
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /export/vol1/unix/s/sneeze/public_html/test/test.php on line 40
```

 

Nån som vet vad jag har gjort för fel??

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

## #2 — sneeze, 2003-05-16T21:45Z

Oj.. rad 40 = 
$countryName = mysql_result(mysql_query($sql), 0, 0);

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

## #3 — sneeze, 2003-05-17T08:40Z

Ooops!
Fixade det själv.
Hade 'glömt' lite saker.. \*host\*  :OO

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/77188-valid-mysql-result