Current location: Hot Scripts Forums » Programming Languages » PHP » Need Help on error in SQL syntax


Need Help on error in SQL syntax

Reply
  #1 (permalink)  
Old 02-12-04, 08:18 AM
eric1328 eric1328 is offline
New Member
 
Join Date: Feb 2004
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Need Help on error in SQL syntax

Hey, I used MyQry Generator EE from http://www.myqry-generator.com to make a php webpage to show a table and search form hooked to my MySQL database. In the program I did something, think created a query, because I want the dates from the table to shown be from earliest to latest. When I load the page at

http://www.wireless-nets.com/database/news2.php

It shows the descended dates and titles right when you first load the page, but when I use the search it errors out and says:

You have an error in your SQL syntax near 'WHERE Date LIKE '%wireless%' OR Title LIKE '%wireless%'' at line 8

My code is attached as a .txt file

What could be wrong?

Please help!
Thank you!
Attached Files
File Type: txt news2.txt (7.5 KB, 361 views)
Reply With Quote
  #2 (permalink)  
Old 02-14-04, 12:08 AM
blaw's Avatar
blaw blaw is offline
Junior Code Guru
 
Join Date: Dec 2003
Location: Vancouver, BC, Canada
Posts: 550
Thanks: 0
Thanked 0 Times in 0 Posts
Hello,

You WHERE clause doesn't seem to be incorrect, but this type of MySQL error gives you the SQL statement from the point where it encounters a problem, and as such, it's easier if you could post here the entire SQL statement you are trying to run.
__________________
Blavv =|
Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
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 Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with ASP & FORMS blessedrub ASP 0 01-23-04 10:22 AM
ERROR in SQL syntax near DATE_FORMAT() bitesize PHP 1 01-09-04 09:22 PM
SQL Code Syntax error...need help...missing operator geneane ASP 3 09-02-03 07:39 PM
ASP Calendar..HELP...pls jimthepict ASP 1 07-31-03 05:01 PM
change my field in this example sal21 ASP 3 07-14-03 02:49 AM


All times are GMT -5. The time now is 08:48 AM.
vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.