[insert] Forum Topics

I need some help with radio button data and how to code it in PHP to insert the data into MySQL. Here is my [B]Form Code[/B]: [CODE]<form method="post" action="update.php"> First Name: <br /> <input type="text" name="fname" size="35" /><br /> Last Name: <br /> <input type="text" name="lname" size="35" /><br /> Phone …

Hi! Im new to MySQL RDMBS. I know the basic CRUD if you know what i mean. Create Read Update Delete. I have 2 tables: Category table and Product Table Products should be categorized. Product table has PK as an ID and FK to Category Table How to INSERT INTO …

Hi community First I want to thank everyone who will look through this, because it's a longer post. I'm currently reading a book on AI by Mat Buckland. I'm re-building Mats entitymanager, though I just copied it. He used std::map to collect all entities as pointers which are cross referenced …

Hi , I want to copy the selected fields, eg:SELECT * FROM table1 where flag='1'; to another table ,table2 can anyone plz help me

Hi all. I come from an MS SQL background and a newbie in MY SQL. Im trying to run a simple query to populate a table: [CODE]Declare @I As Int Select @I = 1 While (@I < 100) Begin Insert into tbWhatEva Select @I Select @I = @I + 1 …

I was just about to post asking how to do this when I stumbled across the solution. All my research on the web suggests that the only way is to use stored procedures with an output parameter. Unfortunately, my queries are necessarily dynamically generated, and output parameters do not work …

Hello, I am having trouble inserting data from a XML file into a table in a SQL data base. The worst thing is it isn't coming up with an error but nothing is being inserted into the database Here is the condensed version of the XML code I am using …

hi; I'm trying to program a circular link list with a head node , I have a problem with insert function . wanting to do it like this but with a head node >> [url]http://geeksforgeeks.org/wp-content/uploads/cll1.gif[/url] this is my function :: [CODE] struct node{ int data; node *next; node(int x,node *n=NULL){ …

Hi, I want to insert and select the data from the same table.I am using following query to insert and select the data from the same table. However, I am not able to insert the data. Is there any method to do this? $sql=mysql_query("INSERT INTO users (name,ref_no) VALUES( '$name', (SELECT …

I cannot believe how loooooong i have been searching the internet for this. However i have a form that i have created in Visual studio 2010. I have 3 text boxes for FIRST NAME, LAST NAME and NOTES. I have 1 button to submit data. When i click the button …

Hey All, Been banging my head into the wall on this one. I have 2 tables one for users 'myMembers' and one for products 'products'. Each table has a auto increment id. The myMembers id is the user id and the products table id is for the product id. I …

plz explain complete step by step procedure to insert update and delete for asp.net2008 with c# and in built sql server. plz tell me where to make object & class. I am confused.

Hi all. As a hobby I've been working on making a website with PHP and MySQL, both of which I am new to. I'm having some trouble with the comments system as I can't seem to be able to insert a date into the database. After the "insert", when I …

I'm a new member and this is my first post, so be gentle ;) It's been a while since I've gotten a chance to practice with recursion so to say I'm a bit rusty is an understatement. Not to mention I've never implemented it with a linked list. My current …

Hello to all java programmers I have a java database problem specifically the auto increment. In my MSAccess I have a table named "[B][COLOR="Red"]Confirm[/COLOR][/B]" and in that table I got two fields, the "[B][COLOR="Red"]confirm[/COLOR][/B]" which is set to text and the "[B][COLOR="Red"]id[/COLOR][/B]" which is set to auto number or auto …

I am making a program in which the program assigns a variable to the numbers 1 - 10. I am suppose to use wait and notify. I put them in but I don't know how to assign the variables to the numbers. My code is and could someone tell me …

I want to insert data from the textBox to MySQL Database. Here is the code snipped that I have created. [CODE]private void button6_Click(object sender, EventArgs e) { string connectionSQL = "server=localhost;database=db_junisman_kulit;uid=root;password=;"; MySqlConnection conn = new MySqlConnection(); double no_simpan = 0; try { conn.Open(); MySqlCommand cmd = new MySqlCommand("INSERT INTO tb_backorder …

this is the code to email confirm. The user clicks on the link in the email, passing the code through url to this page. Then the data is transferred from a tmp table to main one. I have queried in phpmyadmin and it works fine. But when i actually use …

Hi there all, I am trying to get data from a sql view and bound it into the datagridview, after that, I add 4 more colums into the datagridview which are editable, finally pass the entered data into a new database and call that data in the future in the …

[code]<% String UN=request.getParameter("un"); String pw=request.getParameter("pw"); String FN=request.getParameter("FN"); String LN=request.getParameter("LN"); String L1=request.getParameter("L1"); String L2=request.getParameter("L2"); String L3=request.getParameter("L3"); String ccn=request.getParameter("ccn"); Class.forName("com.mysql.jdbc.Driver").newInstance(); java.sql.Connection myConn; myConn = DriverManager.getConnection ("jdbc:mysql://localhost:3306/train_resev","root", "3866" ); PreparedStatement ps=myConn.prepareStatement("insert into user values('" + un + "','" + pw + "','" + FN + "','" + LN + "','" + L1 + …

[CODE]<script type="text/javascript"> function populateHarga() { var x=document.getElementById("barang").value; document.getElementById("harga").value=x; var y=document.getElementById('barang')[document.getElementById('barang').selectedIndex].innerHTML; document.getElementById('nama_brg').value=y; } function populateTotal() { var y=document.getElementById("jumlah").value; var x=document.getElementById("harga").value; document.getElementById("totalnya").value=x*y; } </script> <body> &nbsp;<p> <?php mysql_connect("localhost","root",""); mysql_select_db("stageco"); ?> <table border="1" cellpadding="0" cellspacing="0"> <?php $nama_b=$_GET['nama_brg']; $harga_b=$_GET['harga']; $jumlah_b=$_GET['jumlah']; $total_b=$_GET['totalnya']; if($nama_b!="") { mysql_query("INSERT INTO temp('t_nama','t_harga','t_jumlah','t_total') VALUES('$nama_b','$harga_b','$jumlah_b','$total_b')"); } $result=mysql_query("SELECT * FROM temp"); $i = …

Hello Everyone For a project from skool, I been in charge of development, and we already have the system, but they wanted to add images to the project, and since i been using the TableAdapter.Insert commando to add records to the database, I need to know how to send an …

Hello, Could someone help me with this question that I need to complete within 4 days? I have a problem with the insert statment on the code below. This code is working fine by inserting the ststement, but the problem is that the DATE is not being inserted into the …

Hey guys, As you can see below I am trying to add row of data to a table called tblOut. When i execute the code, it works without a single error message but the problem is I dont see any new record when i preview my table data. Can anyone …

Hi folks, this is my first post in danniweb, please excuse me if I am in the wrong place or the thread title lacks self explanation. I am very disoriented in the field since im new in MS SQL. Before going into the problem, I'm going to give some context: …

I'm having trouble with a MySQL INSERT query. I've used this exact code in many places, and even in different pages on the same web server. I feel like I've tried every variation of INSERT query with no luck. Here are a couple that I've tried so far: [CODE] $name …

In my current project (homework), I am storing a pair of values in a map. The ID is an integer, and the value is a string (name of a movie) and an integer (rating of the movie on a 1-5 scale). I need to get the elements into the map …

I'm a totally beginner in javascript. i need some chunks of code of it. i have a form. i'm going to store the field into mysql. there are 2 conditions : one or all fields empty OR none is empty. when there's no empty field, the data will be stored. …

I keep getting the following error when I try to add new record into database (Access 2007) "The INSERT INTO statement contain unknown field name:'login'." I dont whats wrong as the coding looks fine and the field login does exist in the database. Spent whole day trying to find the …

Hi, I was given the following problem, I've almost got it but I've hit a roadblock and having no luck getting past it. Here is the problem im supposed to solve... The function insert of the class orderedLinkedList does not check if the item to be inserted is already in …