473,513 Members | 7,598 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 2056
code green
1,726 Recognized Expert Top Contributor
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
2501
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
23786
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
2125
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
1891
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
1201
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
1464
by: amy | last post by:
*** Sent via Developersdex http://www.developersdex.com ***
4
2358
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
3471
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
3866
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
2102
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
7254
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7153
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
1
7094
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
5677
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,...
1
5079
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4743
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3230
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
1585
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
796
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.