---
title: "Efter INSERT få fram Id?"
type: "forum-thread"
url: "https://www.webforum.nu/amne/php/89479-efter-insert-få-fram-id"
topic: "PHP"
topic_url: "https://www.webforum.nu/amne/php"
author: "GrodanBoll"
published: "2003-11-02T15:47:43.000Z"
updated: "2003-11-02T16:01:26.000Z"
replies: 4
views: 266
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/89479-efter-insert-få-fram-id"
---

# Efter INSERT få fram Id?

## #1 — GrodanBoll, 2003-11-02T15:47Z

Hej hej :)

Jag undrar hur man får fram den nya postens nummer efter det att man har insert:at en ny post?
Jag använder MySql

/Grodan

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

## #2 — Skarre, 2003-11-02T15:53Z

> int **mysql_insert_id** ( \[resource link_identifier\])
> 
> mysql_insert_id() returns the ID generated for an AUTO_INCREMENT column by the previous INSERT query using the given link_identifier. If link_identifier isn't specified, the last opened link is assumed. 
> 
> mysql_insert_id() returns 0 if the previous query does not generate an AUTO_INCREMENT value. If you need to save the value for later, be sure to call mysql_insert_id() immediately after the query that generates the value.

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

## #3 — Kent.J, 2003-11-02T15:56Z

Fel forum btw ;)

Denna går också o använda

> Also note that the value of the SQL LAST_INSERT_ID() function always contains the most recently generated AUTO_INCREMENT value, and is not reset between queries because the value of that function is maintained in the server.

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

## #4 — GrodanBoll, 2003-11-02T15:56Z

RTFM? ;)
Tackar  :bire

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

## #5 — mahedel, 2003-11-02T16:01Z

ett annat script...

jag använder mig av detta när jag vill veta id:t från senaste posten...

```php
$open = mysql_connect ("localhost", "$dbu","$dbp");
$sql = "SELECT id FROM tabell order by id desc limit 1";
$result = mysql_db_query("databasnamn","$sql");

while($row=mysql_fetch_array($result)){
$senaste_id = $row['id'];
}
```

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

---

Tråden på webben: https://www.webforum.nu/amne/php/89479-efter-insert-få-fram-id