---
title: "fel i sql"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/21958-fel-i-sql"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "bohlin"
published: "2000-07-12T10:15:00.000Z"
updated: "2000-07-12T11:08:00.000Z"
replies: 1
views: 398
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/21958-fel-i-sql"
---

# fel i sql

## #1 — bohlin, 2000-07-12T10:15Z

```
mysql_connect("localhost","root");
mysql_select_db("bohlin");
..
massa annan kod
..
$sql = "SELECT todo FROM calendar WHERE datum = #$y-$m-$d#";
$result = mysql_query($sql);
if (mysql_num_rows($result) > 0)
echo "NÅTT!!";
```

datum är av typen "date"
när jag skrev ut sql-en blev det
SELECT todo FROM calendar WHERE datum = #2000-06-12#

felmeddelande:
Warning: Supplied argument is not a valid MySQL result resource in C:\\bohlin\\php\\calendar\\index.php on line 148

rad 148:
if (mysql_num_rows($result) \> 0)

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

## #2 — woodi, 2000-07-12T11:08Z

$datum="$y-$m-$d";
SELECT todo FROM calendar WHERE datum='$datum';

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/21958-fel-i-sql