On 24-Jan-01 Mark Lipscombe wrote:
> Someone jump in here and correct me if I'm wrong, but by the time you
> get around to executing the second query, LAST_INSERT_ID() from MySQL
> isn't necessarily going to be the desired value, because another record
> may well have been inserted in that time?
EMAIL PROTECTED]>
> To: 'Jacky@lilst' <[EMAIL PROTECTED]>; 'Mark Lipscombe'
> <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Wednesday, January 24, 2001 4:06 AM
> Subject: RE: [PHP] last_insert_id function
>
>
> > I am not really
From: Jacky@lilst [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 25, 2001 7:53 AM
> To: Maxim Maletsky; 'Mark Lipscombe'
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP] last_insert_id function
>
>
> Can we store the value retrieved by last_insert_id for later use? say we
mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 25, 2001 7:53 AM
> To: Maxim Maletsky; 'Mark Lipscombe'
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP] last_insert_id function
>
>
> Can we store the value retrieved by last_insert_id for later use? say we
> want to r
e'
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] last_insert_id function
Can we store the value retrieved by last_insert_id for later use? say we
want to related 3 queries together and under that case, we will then need to
store the first "last_insert_id value" somewhere and the
<[EMAIL PROTECTED]>
Sent: Wednesday, January 24, 2001 3:36 AM
Subject: RE: [PHP] last_insert_id function
> no it will keep it very well. In fact most common errors with this
function
> is that it still keeps the same value when you do something wrong.
>
> This issue is described in m
#x27;Jacky@lilst'; [EMAIL PROTECTED]
Subject: RE: [PHP] last_insert_id function
Yes, except that in the second case you first will have to do the insertion
of $sql and then assign $lastId to mysql_insert_id();
Cheers,
Maxim Maletsky
-Original Message-
From: Jacky@lilst [mailto:[EMAIL P
PROTECTED]
Subject: Re: [PHP] last_insert_id function
So can I do either way as I show below here?
first could be :
$sql = "insert into user (name,email) values('Jack','[EMAIL PROTECTED]')";
$result = mysql_query($sql);
$sql1 = "insert into userFriend (userId
.
Cheers,
Maxim Maletsky
-Original Message-
From: Mark Lipscombe [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 25, 2001 5:28 AM
To: Maxim Maletsky
Cc: 'Jacky@lilst'; [EMAIL PROTECTED]
Subject: RE: [PHP] last_insert_id function
Someone jump in here and correct me if I'
ohn');"
$result1 = mysql_query($sql1);
Are these correct?
Jack
[EMAIL PROTECTED]
"There is nothing more rewarding than reaching the goal you set for
yourself"
- Original Message -
From: Maxim Maletsky <[EMAIL PROTECTED]>
To: 'Jacky@lilst' <[EM
Someone jump in here and correct me if I'm wrong, but by the time you
get around to executing the second query, LAST_INSERT_ID() from MySQL
isn't necessarily going to be the desired value, because another record
may well have been inserted in that time?
On 24 Jan 2001 18:25:27 +0900, Maxim Malets
for example:
$SQL = "INSERT INTO users SET name='Maxim', surname='Maletsky'";
now you have to insert into another table where you need to relate that user
to the entry:
$SQL2 = "INSERT INTO questions SET question='how did you sleep?',
made_by=LAST_INSERT_ID()";
LAST_INSERT_ID() will be here eq
LAST_INSERT_ID() is a mySQL function, non PHP...
in PHP you can use mysql_insert_id() which will return you what you the last
inserted ID.
Cheers,
Maxim Maletsky
-Original Message-
From: Jacky@lilst [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 25, 2001 7:16 AM
To: [EMAIL PROTECTED
13 matches
Mail list logo
