Michael and Reindl
Thank you both for you help and patience. I have inserted the $id =
mysql_insert_id($connection) as well as the code in the INSERT clause and it
seems to be working fine.
One note is it turns out I did have AI on both tables, so that may have been
adding a monkey wrench.
I
- 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 message was checked b
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
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 anything into this field.
if ($_POST['address
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
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 one sequence to worry about with nothing to sync a
I presume you are inserting to both tables always at the same time
inside a transaction? We would need to see the code to see how you
are inserting them..
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
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 is not the same on the two tables. I have
corrected this a couple of times in phpmyadmin by resetting the
auto_increment
11 matches
Mail list logo
