 |  |  |  |  |  |  |  |
Update query with syntax error
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
I have the following update code but i keep getting a syntax error.
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 order_id='105'' at line 21
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 order_id='105'' at line 21
PHP Syntax (Toggle Plain Text)
0
#2 Oct 13th, 2009
Couple of things.
1. Why are you sending unchecked POST values to the database? That is just asking for trouble. Look at SQL injection.
Make sure that the values you receive are the ones you expected, that numbers are numbers etc...
2. Try running the query without single quotes on the numeric value.
1. Why are you sending unchecked POST values to the database? That is just asking for trouble. Look at SQL injection.
Make sure that the values you receive are the ones you expected, that numbers are numbers etc...
2. Try running the query without single quotes on the numeric value.
AJAX is not a programming language, scripting language or any other sort of language.
It is acheived by using JavaScript http functions.
So, AJAX = JavaScript.
It is acheived by using JavaScript http functions.
So, AJAX = JavaScript.
0
#3 Oct 13th, 2009
Hi xan we had sql injection in but we had simplified the query just to get it going first. Thanks i will look into you suggestion.
1
#4 Oct 13th, 2009
You have an extra , right before the WHERE
GCS d- s+ a-->? C++(++++) UL+++ P+>+++ L+++ E--- W+++
N+ o K w++(---) O? !M- V PS+>++ PE+ Y+ PGP !t- 5? X- R tv+
b+>++ DI+ D G++>+++ e+ h+>++ r y+
PMs asking for help will not be answered, post on the forums. That's what they're there for.
N+ o K w++(---) O? !M- V PS+>++ PE+ Y+ PGP !t- 5? X- R tv+
b+>++ DI+ D G++>+++ e+ h+>++ r y+
PMs asking for help will not be answered, post on the forums. That's what they're there for.
0
#5 Oct 13th, 2009
•
•
•
•
Originally Posted by ShawnCplus 
You have an extra , right before the WHERE
AJAX is not a programming language, scripting language or any other sort of language.
It is acheived by using JavaScript http functions.
So, AJAX = JavaScript.
It is acheived by using JavaScript http functions.
So, AJAX = JavaScript.
|
Similar Threads
- Syntex error in UPDATE Query C#---MS ACCESS (C#)
- Update query error (PHP)
- Syntax error in UPDATE statement. (VB.NET)
- storing url in variable and query update error (PHP)
- Error while trying the update query (ASP)
- IE Syntax Error and Can´t browse some sites (Viruses, Spyware and other Nasties)
- UPDATE syntax error (MySQL)
Other Threads in the PHP Forum
- Previous Thread: passing varaible between pages ussing sessions
- Next Thread: Display Php echo information on html pages
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest PHP Posts
- Today's Posts
- Unanswered Threads
-xlint 7 64bit 429 2010 activex ajax apple application backup blue browser bsod business c++ char* code collaboration compiler component computer control database datepart design dns eclipse email embedded error errors file firefox firmware floatingpoint gamer gaming gmail google gui input install internet iphone iphone2.1 java javac jni jvm keyword keywords leopard linker list mac management microsoft mistake mozilla mysql news object onreadystatechange osx output parse patch php playstation port problem programming ps3 python reformat remote return ruby screen security server sharepoint small software sony space sqlserver syntax trojan undosend update vb virus vista visual vulnerability windows windowsxp xml xp
