Tagged Questions
0
votes
1answer
20 views
PHP MySQL Insert from drop down menu
Just a quick question. I am sure it is not as complicated as I think. I have a page that has 4 drop down menus. These are all populated from a database which is MySQL. Upon a submission I would like ...
0
votes
1answer
28 views
how do i add a scanner so i can insert the values which are then saved on to mysql
basically I need to add another scanner input which after login in to I can add an id and name etc to my database so I don't have to use the set one in the program. the database gets updated when I ...
0
votes
1answer
142 views
Register form with php, mysql
In my register form all fields work fine, but the village field return a 0 in the database.
I used ajax and jquery to create a drop list for governorate and district and village.
The first 2 work ...
0
votes
1answer
95 views
Best way to INSERT from CSV file into two 1 to many related MySQL tables
I'm using PHP & MySQL
I have 2 tables with the following layouts: (there are other fields not relevant to this issue)
QUESTIONS
Q_ID, int, auto incrementing, primary key
Question, varchar(255)
...
0
votes
1answer
34 views
Passing parameters to IdbCommand for mySQL database
I am trying to do something relatively simple using IdbCommand to execute an insert query.
Here's the code:
using (IDbConnection conn = DbHelper.GetConnection(DbConnString))
using ...
0
votes
1answer
48 views
Turn INSERT INTO query into UPDATE
I have a piece of software that runs an INSERT INTO query in my MySQL database. I'd like this software to update a row in the table it is accessing instead of creating a new row. I have no access to ...
0
votes
1answer
133 views
CakePHP 2: How to generate an sql insert script from an array
Can I generate an sql insert statement from an array returned by find methods?
Thanks.
-1
votes
1answer
65 views
insert sql to database not inserting properly
I want to insert my data to database, however, it doesn't work out properly such as, when I have 4 products added to cart, it will only insert two out of four. And the subtotal appears such that it ...
1
vote
0answers
58 views
Insert error 1241
I have two MySQL INNODB tables 'student' and 'instructor'. They are analogous in almost every single way. I can add arbitrary records into the 'student' table, but not the 'instructor' table. Both ...
0
votes
0answers
47 views
SQL Update table from not exists statement
Still new but learning lots.
I have 2 tables AVDMASTER and AVDupdates.
I would like to update the current existing row(s) in AVDMASTER (Fields: OWNER, REG, PREVIOUS) with new data from AVDupdates ...
0
votes
0answers
51 views
Row Being Inserted Twice into MySQL table with one query
I am inserting info into a MySQL table and I'm only running one INSERT query but the record shows up twice in the table when I check. Basically, I store a job in a temp_job table with information ...
0
votes
0answers
46 views
asp.net SQL syntax error with update and insert command
Hi I have a problem trying to update and insert a new record into a table i'm using this update and insert command.
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
...
0
votes
0answers
25 views
mysql.connector.ProgrammingError in Python when insert data to table
I am writing a script to read data from a file by lines and insert each line into MySQL database. I use mysql.connector to do this. Here is a piece of script.
def insert_query(data):
return ...
0
votes
0answers
15 views
adding nonspecific information to existing database in mysql
I am confused about how to create the SQL to insert info into an existing database. I need to add 10 new users by type, 20 new accounts, 1 new location, 3 new employees & 30 activities. Is it ...
0
votes
0answers
51 views
php my sql insert command didn't add the first column
I have this script but mysql insert section I have a problem the script didn't insert the first column "DNS" in sql table but did insert the second and the third one. what is my mistake the reason the ...
