sql syntax error

tychicus · 10-07-2006

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 'out) as tout from hl_traffic where listing_id = 3 and date + interval 7 day > no' at line 1

anybody knows how to check the error and what is the error?

shavei7 · 10-07-2006

it would help if you would right the whole SQL statement that you were trying to run

tychicus · 10-07-2006

Quote:

Originally Posted by shavei7

it would help if you would right the whole SQL statement that you were trying to run

Can you please guild me how to do that? thanks

Ajay · 10-07-2006

Which page are getting the error etc would help.

We cant really figure out a solution with no adequate data.

tychicus · 10-08-2006

Error

SQL query: Documentation

SELECT *
FROM `hl_listings`
WHERE 1 `id`
LIMIT 0 , 30

MySQL said: Documentation
#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 'id`
LIMIT 0, 30' at line 1

tychicus · 10-08-2006

is this help?

Ajay · 10-08-2006

The syntax is all wrong, what exactly are you trying to search?

PHP Code:


			
SELECT *

FROM `hl_listings`

WHERE `id` = 'something'

LIMIT 0 , 30

would be sample code.
It will find all rows in hl_listings whose id = 'something'

ScottHughes · 10-12-2006

Could the problem be the smart quotes? I've never used smart quotes in SQL. Can SQL read the smart qutoes?

10-07-2006	#1 (permalink)
tychicus Senior Member Join Date: Aug 2006 Age: 29 Posts: 166	sql 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 'out) as tout from hl_traffic where listing_id = 3 and date + interval 7 day > no' at line 1 anybody knows how to check the error and what is the error? __________________ http://humorpic.blogspot.com/ http://swandesignstudio.blogspot.com/

10-07-2006	#2 (permalink)
shavei7 Senior Member Join Date: Jul 2006 Location: Redmond, WA Posts: 1,064	Re: sql syntax error it would help if you would right the whole SQL statement that you were trying to run __________________ NOSH1T/LOSTGIRLWONDERINGV4 the only real mistake is the one from which we learn nothing (John Powell)

10-07-2006	#4 (permalink)
Ajay Senior Member Join Date: Aug 2006 Age: 26 Posts: 755	Re: sql syntax error Which page are getting the error etc would help. We cant really figure out a solution with no adequate data. __________________ Ajay D'Souza Techtites - Your daily dose of all things Tech! Sir Arthur Conan Doyle \| I Sent This WebberZone Domains

10-08-2006	#5 (permalink)
tychicus Senior Member Join Date: Aug 2006 Age: 29 Posts: 166	Re: sql syntax error Error SQL query: Documentation SELECT * FROM `hl_listings` WHERE 1 `id` LIMIT 0 , 30 MySQL said: Documentation #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 'id` LIMIT 0, 30' at line 1 __________________ http://humorpic.blogspot.com/ http://swandesignstudio.blogspot.com/

10-08-2006	#6 (permalink)
tychicus Senior Member Join Date: Aug 2006 Age: 29 Posts: 166	Re: sql syntax error is this help? __________________ http://humorpic.blogspot.com/ http://swandesignstudio.blogspot.com/

10-08-2006	#7 (permalink)
Ajay Senior Member Join Date: Aug 2006 Age: 26 Posts: 755	Re: sql syntax error The syntax is all wrong, what exactly are you trying to search? PHP Code: SELECT * FROM `hl_listings` WHERE `id` = 'something' LIMIT 0 , 30 would be sample code. It will find all rows in hl_listings whose id = 'something' __________________ Ajay D'Souza Techtites - Your daily dose of all things Tech! Sir Arthur Conan Doyle \| I Sent This WebberZone Domains

10-12-2006	#8 (permalink)
ScottHughes Senior Member Join Date: Sep 2006 Age: 22 Posts: 460	Re: sql syntax error Could the problem be the smart quotes? I've never used smart quotes in SQL. Can SQL read the smart qutoes? __________________ Online Book Club

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
What HTTP error is generated when there is an error in an ASP page?	agaba175	ASP	0	08-05-2006 08:25 PM
Incorrect syntax near ')'.	cade	ASP	2	07-13-2006 04:16 PM

	All times are GMT. The time now is 08:10 PM.
	Contact Us - preCharge.Net - Archive - Privacy Statement - Top