Need Help on error in SQL syntax

eric1328

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!

LordShryku

Nothing is attached...

eric1328

Here it is

icaro

not a clue...
it would be easier if you print entire query after you execute it and take a look on it. if you cant see whats wrong, post it here so we can help.

dont take me wrong, but read your code and realize whats going on and where is the problem may take hours...

LordShryku

I'd say the problem lies here:

 $query = "SELECT
                                       Date,
                                       Title
                                 FROM      

                                       news
                                 ORDER BY

                                   Date DESC";

You're putting the order by in front of your where clause.

icaro

Originally posted by LordShryku
I'd say the problem lies here:

 $query = "SELECT
                                       Date,
                                       Title
                                 FROM      

                                       news
                                 ORDER BY

                                   Date DESC";

You're putting the order by in front of your where clause. [/B]

there is no where clause on this query..

LordShryku

It checks for where and adds it later in the code.

icaro

hummm
so you are right...

eric1328

I have found out the problem, thanks