View Single Post
  #1 (permalink)  
Old 2007-04-18, 02:01 AM
chaucheefui chaucheefui is offline
Junior Member
 
Join Date: Apr 2007
Posts: 1
chaucheefui is on a distinguished road
Default How to resolve "You have an error in your SQL syntax; check the manual..."?

I am new to all of this stuff and Please help me to resolve this.

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 = 1 and date + interval 7 day > no' at line 1

First of all, I don't know what that mean.

My host provide :PHP version 4.4.6, MySQL version 5.0.27-standard

Here is the table I created.

id bigint(20) UNSIGNED No auto_increment
date date Yes NULL
listing_id bigint(20) UNSIGNED No 0
in bigint(20) UNSIGNED No 0
out bigint(20) UNSIGNED No 0

If you need more info about the problem, I will provide it for you.

If you know the problem, can you teach me step by step?

Thank You in advance.
Reply With Quote
Sponsored Links