[phorm] [Phorm:] MySQL - Two Tables, auto_increment problem
- From: webbbs@xxxxxxxxx
- To: support@xxxxxxxxx
- Date: 14 Apr 2003 16:03:57 -0000
The following new message has been posted on Phorm Support Forum at
<http://www.phorm.com/support/>.
***************************************************************************
MESSAGE: (#2526) MySQL - Two Tables, auto_increment problem
<http://www.phorm.com/support/?rev=2526>
AUTHOR: Joe Davison
DATE: April 14, 2003 at 12:03 p.m. EST
This is my config file:
<?php
$PHORM_PARSPHP = "true";
$PHORM_ACK = "process_payment.php";
$PHORM_MYDBV = "database_config.php";
$PHORM_MYTABLE[1] = "clients";
$PHORM_MYVARS[1] = "email=email, password=password";
$PHORM_MYTABLE[2] = "client_billing_address";
$PHORM_MYVARS[2] = "client_id=PHORM_MYSQLID[1], firstname=firstname,
lastname=lastname, country=country, zip=zip, state=state, city=city,
address1=address1, address2=address2";
$PHORM_VALDEFS = "validation_config.php";
?>
Basically, I need to get the client_id, which is the auto_increment key of the
"clients" table, and use this client_id when I insert into the second table,
client_billing_address. What I did above, client_id=PHORM_MYSQLID[1], is not
working.
I have tried:
$PHORM_MYVARS[2] = "client_id=PHORM_MYSQLID[1] $PHORM_MYVARS[2] =
"client_id=$PHORM_MYSQLID[1]
$PHORM_MYVARS[2] = "client_id=\$PHORM_MYSQLID[1]
$PHORM_MYVARS[2] = "client_id=$$PHORM_MYSQLID[1]
But none of these seem to work. Can anybody help me do this? Is it possible?
Thanks in advance.
Joe Davison
***************************************************************************
This is an automatically-generated notice. If you'd like to be removed from
the mailing list, please visit Phorm Support Forum at
<http://www.phorm.com/support/>, or send your request to webbbs@xxxxxxxxxx If
you wish to respond to this message, please post your response directly to the
board. Thank you!
-------------------------------------------------
You are receiving this message because you are subscribed to the Phorm mailing
list. To send messages to the mailing list, simply send email to
phorm@xxxxxxxxxxxxx from the address you have subscribed. You may unsubscribe
from the list by sending email to phorm-request@xxxxxxxxxxxxx with
'unsubscribe' in the SUBJECT field.
Other related posts:
- » [phorm] [Phorm:] MySQL - Two Tables, auto_increment problem
