Reference Citations - HerongYang.com - v2.95, by Herong Yang
how to insert a value in a column with another value
'INSERT INTO - Inserting New Records' tutorial was cited in a DreamInCode forum post in 2009.
The INSERT INTO - Inserting New Records tutorial was cited in a DreamInCode forum post in 2009.
Subject: how to insert a value in a column with another value
Date: 30 Jul, 2009
Author: fallen0ne09
Source: http://www.dreamincode.net/forums/index.php
?&showtopic=117566&hl=
i want to insert a value using mysql query but i cant seem to make it
work... i tried where or be but it does not work here is my code could
anyone help me.
<?php #MySQL-Insert-Into.php
# Copyright (c) 2007 by Dr. Herong Yang, https://www.herongyang.com/
#
$con = mysql_connect("localhost", "root", "");
$ok = mysql_select_db("shimm", $con);
$msg = $_POST['description'];
$date = date("Y-m-d");
$sql = "INSERT INTO data (description) where pid desc limit 1 "
. " VALUES ('$description')";
...
pid is my key... and i want to add some values in a column...
and this error keeps popping out.
Sending statement failed. 1064: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for
the right syntax to use near 'where pid desc limit 1 VALUES ('')' at
line 1
could anyone help me i dont know what to do next... i really
appreciate it..
Table of Contents
Java Database Connectivity (JDBC) Overview
getting database connection in netbeans
Delphi 2010 "£" sign issues and Parameters
Scambio cedrtificati Server/Client
BSOD with win 7 64 bit when playing games
Win7: SYSTEM IGMP 224.0.0.22 connection
Public key in reply and keystore don't match
How do I get rid of SDHelper.dll errors?
Not Another Damn Password! Its the 21st Century After All
insert a photo document in to the oracle database through JDBC
COMS 6998 Search Engine Technology
Using RSA encryption with Java
Setting up SOAP in PHP, why am I getting these errors?
►how to insert a value in a column with another value
Inserir ficheiro numa base de dados MySql com vb.net
Connection String - SQL Server 2005
QLAuthenticator password encryption/decryption
Wweb dynpro application Localization in chinese
C# code for MySql Stored Procedures IN, OUT, and INOUT parameters
What are Scoping Rules in Javascript?
connect two ubuntu computers together using a cable
can not establish a connection with SQL
Conectar Java Con SQL Server 2005 Express
Use of undefined constant SOAP_1_2
Help forming a SOAP client call with PHP
Automatisch einen Benutzer anlegen
Android Developers - SSL client authentication
Insert and reterive the image into BLOB type
Compile error... what's wrong?