abase 6045 (20110415) __
The message was checked by ESET Smart Security.
http://www.eset.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
- Original Message -
> From: "Gary"
>
> I'm not sure I undertand this, could you explain a little further for
> me.
This is what they're talking about:
http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_last-insert-id
--
Bier met grenadyn
Is als mosterd by den
Am 15.04.2011 18:52, schrieb Gary:
> I'm sorry, I am unfamliar with an asc file, so I have not opened them.
>
> GAry
>
>
> "Reindl Harald" wrote in message
> news:4da87554.8030...@thelounge.net...
you should not open them
if your mail client would have gpg you would see a signed message
and
I'm sorry, I am unfamliar with an asc file, so I have not opened them.
GAry
"Reindl Harald" wrote in message
news:4da87554.8030...@thelounge.net...
__ Information from ESET Smart Security, version of virus signature
database 6044 (20110415) __
The mess
Am 15.04.2011 18:34, schrieb Gary:
> Michael
>
> I'm sorry, I should have removed this code for the post, but this code is
> part of a "honey pot". There is no 'address' input visible, it is used so
> if a spam bot enters information into this field, it kills the form. Humans
> cannot enter
rt_id() or LAST_INSERT_ID() - what should this code do?
>
> * insert in main table
> * fetch mysql_insert_id() what is thread-safe
> * use that value in the second table
>
>
> and please do not use such ugly hacks as in the begin of your code
> addslashes() has no
The first thing I notice browsing your code is this block stuck
immediately between your 2 insert statements:
if ($_POST['address'] != '' ) {
die("Changed field");
}
This guarantees that your 2 auto_increment sequences will fall out of
sync any time any client POSTs (and perhaps all gets?
Am 15.04.2011 17:59, schrieb Gary:
> Michael, thank you for your reply
>
> ""Might I suggest, instead of the 2 part juggling act, you drop the
> auto-increment property on your second table, and just use the value
> derived from the first as the joining key in the second. Then there
> is only o
e to worry about with nothing to sync against
- michael dykman
On Fri, Apr 15, 2011 at 10:33 AM, Gary wrote:
> I have a innodb with a join on two tables. The foreign key is the id
> column which is set to AI. I have been having an issue of the tables being
> out of sync in that the id
I would be appreciative.
>
>
> --
> Gary
>
>
>
> __ Information from ESET Smart Security, version of virus signature
> database 6044 (20110415) __
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>
>
>
>
meone could direct me to what to
post I would be appreciative.
--
Gary
__ Information from ESET Smart Security, version of virus signature
database 6044 (20110415) __
The message was checked by ESET Smart Security.
http://www.eset.com
--
MySQL General Mailing Lis
11 matches
Mail list logo
