troy
Posts: 12
|
| Posted: 04/30/2007, 2:35 AM |
|
hi there:
im using mysql, php and ccs 3.1 full edtion.
my question is.
i have 2 databases in the one project and they are both on the same server.
One database is a mailing list database and the other database stores all the records from a user signup form.
I want to be able to have one record form with fields from the user database and one field from the mailing list databese. (being the email field.)
so when the user signs up there email will be stored in th mailing list database and the rest in the user database when they hit the submit button.
i have read its to do with have the right SQL quiery, does anyone no if this is possable to do.
or t do with "stored procedures", witch i dont no much about.
thank you
troy....
|
 |
 |
mamboBROWN
Posts: 1713
|
| Posted: 04/30/2007, 4:05 PM |
|
troy
One way that you can accomplish this is to create a field on the form that will store the one value from the second database. Once the users clicks the submit button you can create code in the After/Before Submit Event that will take that value and automatically submit it (using custom SQL) to the second database (this is transparent to the user).
|
|
|
|
|
