Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,194,566 members, 7,955,097 topics. Date: Saturday, 21 September 2024 at 04:48 PM |
Nairaland Forum / Science/Technology / Webmasters / Find The Error In This Mysql Statement. (555 Views)
If You Are Using /blogger, Then You Must Read This Latest Error / How To Manage 403 Forbidden Error In Wordpress / Error "Com.digitalpersona.onetouch.jni.jniexception" (2) (3) (4)
Find The Error In This Mysql Statement. by Nipeks(m): 6:19pm On Jun 11, 2015 |
I ran this MySQL query:
NB: The emoticon in the query is actually a closing bracket followed by a semi-colon. And I get this error: [b]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 '' at line 1[/b] I have been trying for some hours now and still couldn't find the syntax error. Pls, what am I doing wrong? |
Re: Find The Error In This Mysql Statement. by JackOfAllTrades: 7:09pm On Jun 11, 2015 |
Just assign them(MySql_real_string() ) to a variable, the you can use double quotes without having to concatenate |
Re: Find The Error In This Mysql Statement. by Adesege(m): 7:14pm On Jun 11, 2015 |
Instead of echo mysql_error(), immediately after the closing bracket of the query, put: or die(mysql_error()); That should give you more error reporting |
Re: Find The Error In This Mysql Statement. by Nipeks(m): 7:27pm On Jun 11, 2015 |
Thanks guys but I figured it out. This is this correct version:
The VALUES() was missing a closing bracket. 1 Like |
(1) (Reply)
I Need Help For My Blog / Http://59a19vlqi9oskf44qkmtjgu51j./ / Giveaway: Win 25,000 naira
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 25 |