Go Back   DevHunters.com l Webmaster Forum - Web Advertising - Web Design - SEO Forums > Webmaster / Coding / Web Design Discussion > PHP, CGI, ASP, Server-Side Programming

PHP, CGI, ASP, Server-Side Programming Discuss server-side programming such as PHP, CGI, ASP, and others.

Reply
 
LinkBack Thread Tools Display Modes
Old 03-23-2008, 11:37 AM   #1 (permalink)
New Hunter
 
Join Date: Mar 2008
Posts: 3
HB$ Balance: 5.00
Callme is on a distinguished road
iTrader: (0)
Default Php Error advice

Im using a script to carryout a search on a mysql database and im getting the following 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"

Can anyone provide some info on this, is this something to do with the sql query i am using? Any advice would be must appreciated.
Callme is offline   Reply With Quote
Old 03-23-2008, 12:01 PM   Tweet this post! #2 (permalink)
Senior Staff
 
Hunter1's Avatar
 
Join Date: Mar 2007
Location: Indiana USA
Posts: 2,443
HB$ Balance: 18,026.33
Hunter1 has a brilliant futureHunter1 has a brilliant futureHunter1 has a brilliant futureHunter1 has a brilliant futureHunter1 has a brilliant futureHunter1 has a brilliant futureHunter1 has a brilliant futureHunter1 has a brilliant futureHunter1 has a brilliant futureHunter1 has a brilliant futureHunter1 has a brilliant future
iTrader: (9)
Default

What kind of script is it??

Smarty database in it?

Are you using php 4 or 5 on your server?
Hunter1 is offline   Reply With Quote
Old 03-23-2008, 08:04 PM   #3 (permalink)
Sharp Shooter
 
weblord's Avatar
 
Join Date: Mar 2007
Location: Philippines
Posts: 1,322
HB$ Balance: 611.00
weblord has much to be proud ofweblord has much to be proud ofweblord has much to be proud ofweblord has much to be proud ofweblord has much to be proud ofweblord has much to be proud ofweblord has much to be proud ofweblord has much to be proud of
iTrader: (1)
Send a message via ICQ to weblord Send a message via AIM to weblord Send a message via MSN to weblord Send a message via Yahoo to weblord Send a message via Skype™ to weblord
Default

you need to provide at least the url or how you created the myql database you might have missed something.

Quote:
Originally Posted by Callme View Post
Im using a script to carryout a search on a mysql database and im getting the following 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"

Can anyone provide some info on this, is this something to do with the sql query i am using? Any advice would be must appreciated.
weblord is offline   Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Forum Jump


All times are GMT -5. The time now is 04:29 PM.


Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0
vBCredits v1.4 Copyright ©2007 - 2008, PixelFX Studios