SQL statement error

Anon

Dears,

Here is the SQL code with syntax error for PHP webage

$result="select * from news where dates("m")=$month and dates("y")=$year order by dates DESC"

One of the errors I think is that the forms of dates("y") and dates("m") may not correct.

Anyway,please help me how to correct them, thanks

Simon

kpmonroe

please post the table structure for review, as this sql statement doesnt seem logical.

Anon

this is somewhat related, but not the answer to your problem - sometimes when I want to do a query broken down by days on my orders table, I do a to_days() on the orderDate (datetime type) to select out the order for that day.

I believe to_days() works for timestamp types also.

So, this means you can do something like: select * from orders where orderDate between to_days("2001-01-01") and to_days("2001-01-31")

frewuill

OK .. I guess what you are trying to do is something like this..

$result="select * from news where month(datefield)=$month and year(datefield)=$year order by dates DESC"

You should note that datefield should be a date field from news table on your database.

Hope this helps.

P.D.: month() and year() are sql functions to retrieve parts of a data field.