473,396 Members | 1,859 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Form Filled Input Data to More Than One Database and Table

hai

i want to make the update form for my website, and in my update form there is two combo box for chose where database you want to input the data and where table do you want to fill the field, for eaxample:
_______________
chose database to save |___________|_|
_______________
chose table to save |_____________|_|

if i chose database "example1" table "field1" then it will input to database and table that i chose.

my problem is i don't know mysql query for that update form.

please help me
Nov 18 '10 #1
1 2046
code green
1,726 Expert 1GB
Expand|Select|Wrap|Line Numbers
  1. UPDATE dbname.tablename SET fieldname = formvalue
  2. WHERE .......
Nov 19 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Agnes | last post by:
I use while-loop the show the table content in web page. e.g (bookingno, booking date,customer no) However, the client need me insert one column (confirmdate ) and allow the user input and update...
4
by: Ester | last post by:
I would like to read data from a database table row by row and execute some codes based on the data retrieved from each row. For example, there are 4 fields on a table called Image_Tbl. Those...
4
by: Terry | last post by:
I need some help refining an MS 2000 relational databse. I have created a simple relational database using two tables, 'Student Details', 'Exam Details' and two forms, 'Input/Edit Exam Details',...
1
by: 4 | last post by:
I am having some trouble w/ a school project database that I am doing. The database is used for a ski rental shop. In the rental table I have various customers w/ rentals on different days. I have...
3
by: Agnes | last post by:
Now, i need to query some data from InvoiceTable and then put into one dataset. my way is using store procedure , 1.by passing date,company code to the store procedure) 2. use datarow to loop the...
1
by: amy | last post by:
*** Sent via Developersdex http://www.developersdex.com ***
4
by: tarafinlay | last post by:
Hi all, I am new to access and am finding it a bit unintuitive having worked with SQL server in the past... And I am in a bit of a hurry because my employer wants me to crank something out which...
3
by: pedro8ae | last post by:
If I build a form to input data into a table every time I open the form I am seeing the data I enter the last time my question is how every time I save data in my form I get a clean set of fields...
2
by: SSG | last post by:
In my database table , I have field to store the text,.. I am tryinf to find the length of the filed in ASP like below response.write len(rs("cname1")) It is displaying the value , when the...
1
by: Dean0621 | last post by:
Good morning folks, as with most people on here with their first time question, I have been working on this issue for nearly two weeks, doing some searching on this forum and the internet to assist...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.