---
title: "Last_insert_id()"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/22375-last-insert-id"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "jonne"
published: "2001-12-07T11:49:00.000Z"
updated: "2002-01-14T20:32:00.000Z"
replies: 6
views: 233
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/22375-last-insert-id"
---

# Last_insert_id()

## #1 — jonne, 2001-12-07T11:49Z

Varför vill inte det senast inlaggda idt "fastna" på $lastID ?

```
@mysql_query("INSERT INTO Question
				(qBody, qDate, qAuthor)
				VALUES ('$ffQuestion', '$ffDate', '$ffAuthor')				
				")
				or die("SQL-fel!<br> <br>" . mysql_error());
	$lastID = mysql_query("SELECT LAST_INSERT_ID()");
	echo "Föregående ID: $lastID";
	for($i = 0; $i <= 4; $i++) { 
		if($ffQ[$i] != "") {

			@mysql_query("INSERT INTO Alts
				(QID, aBody)
				VALUES ('$lastID', '$ffQ[$i]')				
				")
				or die("SQL-fel!<br> <br>" . mysql_error());
				
		}
	}
```

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

## #2 — LarsG, 2001-12-07T12:02Z

```
$result = mysql_query("SELECT LAST_INSERT_ID() as last");
$row = mysql_fetch_array($result);
echo "Föregående ID: " . $row["last"];
```

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

## #3 — jonne, 2001-12-07T12:06Z

Superbt LarsG.. Superbt.
Tack och bock.

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

## #4 — jorgen, 2002-01-14T19:41Z

Hej, jag har en insert som jag skulle vilja lägga in dess Id också med SELECT LAST_INSERT_ID(). Men får inte det att fungera, hur gör man?

Måste jag göra en update också, eller man kan göra allt i ett?

RED: Oj, detta skulle blivit en ny tråd, men den passade ju rätt bra här med :e

mvh Jörgen :)

```
SQLStmt ="INSERT INTO Inlagg "

SQLStmt = SQLStmt & "(Icon, Ip, Subject, Comment, Bevakning, Inlagg_AnvId, IntForumId, dteDate, LastUpdate, Orginal) "

SQLStmt = SQLStmt & "VALUES('" & Trim(Request.Form("Icon")) & "','" & Ip & "','" & Fixatecken(Trim(Request.Form("Subject"))) & "','" & Fixatecken(Trim(Request.Form("Comment"))) & "'," & Trim(Request.Form("Bevakning")) & ", " & AnvId & ", " & Trim(Request.Form("IntForumId")) & ", Now(), '"&strTid&"', 1);SELECT LAST_INSERT_ID()"
set rs = objDB.Execute(SQLStmt)
```

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

## #5 — jorgen, 2002-01-14T20:03Z

Ändrade till detta, vilket funkar, finns det inga genvägar att gå?

```
SQLStmt ="INSERT INTO Inlagg "
SQLStmt = SQLStmt & "(Icon, Ip, Subject, Comment, Bevakning, Inlagg_AnvId, IntForumId, dteDate, LastUpdate, Orginal) "

SQLStmt = SQLStmt & "VALUES('" & Trim(Request.Form("Icon")) & "','" & Ip & "','" & Fixatecken(Trim(Request.Form("Subject"))) & "','" & Fixatecken(Trim(Request.Form("Comment"))) & "'," & Trim(Request.Form("Bevakning")) & ", " & AnvId & ", " & Trim(Request.Form("IntForumId")) & ", Now(), '"&strTid&"', 1) "

objDB.execute SQLStmt,,128

set rs = objDB.execute("SELECT LAST_INSERT_ID()")

sql = "UPDATE Inlagg SET Thread_MessId = "& rs(0) &" WHERE MessId = "& rs(0)

objDB.Execute sql,,128

rs.close()
set rs = nothing
```

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

## #6 — LarsG, 2002-01-14T20:12Z

```

sql = "UPDATE Inlagg SET Thread_MessId = LAST_INSERT_ID() WHERE MessId = LAST_INSERT_ID()"
objDB.Execute sql,,128
```

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

## #7 — jorgen, 2002-01-14T20:32Z

ahh, det var ju en liten förbättring, tackar LarsG :)

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/22375-last-insert-id