---
title: "Enkel insert"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/112529-enkel-insert"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "K@llen"
published: "2004-09-28T19:30:27.000Z"
updated: "2004-09-28T19:45:31.000Z"
replies: 1
views: 214
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/112529-enkel-insert"
---

# Enkel insert

## #1 — K@llen, 2004-09-28T19:30Z

Hej,

Nu har jag suttit med en busenkel sql-fråga länge nog, men jag ser inte felet. Tycker jag kollat allt. :r 

Alla fält är varchar utom memberStart som är datetime.

```
$sql = "INSERT INTO members (firstName, lastName, phoneNumber, email, homepage, memberStart) 
VALUES('" . $_POST['firstName'] . "', '" . $_POST['lastName'] . "', '" . $_POST['phoneNumber'] . "',
 '" . $_POST['email'] . "', '" . $_POST['homepage'] . "', now()";
```

 

> INSERT INTO members (firstName, lastName, phoneNumber, email, homepage, memberStart) 
> VALUES('kalle', 'knutsson', 'xxxxx-xxxxxxx',
>  'jahhag@hwduhwu.se', 'http://jodu.se', now()

 

> You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

MySQL 4.01

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

## #2 — K@llen, 2004-09-28T19:45Z

Hade glömt en slutparantes. Fanken, så fort man postar här hittar man felet. :d

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/112529-enkel-insert