Go Back   DevHunters Webmaster Forum > 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.

Php Error advice

This is a discussion on Php Error advice within the PHP, CGI, ASP, Server-Side Programming forums, part of the Webmaster / Coding / Web Design Discussion category; Im using a script to carryout a search on a mysql database and im getting the following error: "You have ...

Reply
 
LinkBack Thread Tools Display Modes
Old 03-23-2008, 11:37 AM   #1
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
Senior Staff
 
Hunter1's Avatar
 
Join Date: Mar 2007
Location: Indiana USA
Posts: 2,618
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?
__________________
AdBlurps.com Directory l
Hunter1 is offline   Reply With Quote
Old 03-23-2008, 08:04 PM   #3
Sharp Shooter
 
weblord's Avatar
 
Join Date: Mar 2007
Location: Philippines
Posts: 1,319
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



All times are GMT -5. The time now is 04:58 AM.


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