From: Reindl Harald
Date: April 15 2011 4:41pm
Subject: Re: Out of sync tables
List-Archive: http://lists.mysql.com/mysql/224815
Message-Id: <4DA87554.8030606@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig3F11E5F326767932F98105FC"

--------------enig3F11E5F326767932F98105FC
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable



Am 15.04.2011 18:34, schrieb Gary:
> Michael
>=20
> I'm sorry, I should have removed this code for the post, but this code =
is=20
> part of a "honey pot".  There is no 'address' input visible, it is used=
 so=20
> if a spam bot enters information into this field, it kills the form.  H=
umans=20
> cannot enter anything into this field.

but why somewhere middle in the code instead making
clean verifications at the begin?

> ""Again, I see no reason you could not call last_insert_id() after the
> first insert and use that value explicitly in the second.
> ""
>=20
> I'm not sure I undertand this, could you explain a little further for m=
e

<?php
 mysql_query("insert into table1 (field1, field2) values ('value1', 'valu=
e2')", $conn);
 $id =3D mysql_insert_id($conn);
 mysql_query("insert into table2 (ref_id, data) values (" . $id . ", 'you=
rdata')", $conn);
?>

as long you never use the insert-id from the AI i wonder how
there could be anything out of sync because there never can
be anything in sync



--------------enig3F11E5F326767932F98105FC
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAk2odVQACgkQhmBjz394AnnG5ACeNmWIW+21xHlRzfHgSpPcjFNF
AYAAoIfMwdsTOM9C20+2I7NjOOv5QVZE
=i22U
-----END PGP SIGNATURE-----

--------------enig3F11E5F326767932F98105FC--