Hello guys,
i created a form and i want to form to serve a dual purpose of sending data to my database contacts and and another database for newsletter.
so the task is as follow:
one form serving two databases at one click on submit.
i need your help. thank
Best regards
nestkojex 0 Newbie Poster
sv3tli0 0 Junior Poster in Training
2 database or 2 tables ?
If its 2 tables (in one database the function is just to do the first query, then the second query - (mysql_query(1); mysql_query(2))).
If you want to do it on 2 databases. you must put select databases queries .
nestkojex 0 Newbie Poster
yeah. this worked perfectly. thanks sv3tli0
diafol
Depending on table structure, you could do a cross-table update - they're a little more complicated though and need to be be tested thoroughly, but could save a few call to the DB:
http://www.electrictoolbox.com/article/mysql/cross-table-update/
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.