"Marek Kilimajer" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > msa wrote: > > My date format is as above....I am getting the following error message: > > > > 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 'Y') . ' AND > > MONTH(date) = ' . date('m') . ' ORDER BY sort DESC' > > > > > > I changed your code to fit my table name and "sort" to be lower case, as it > > is in the database: > > > > "SELECT * FROM NewsArchive WHERE YEAR(date) = ' . date('Y') . ' AND > > MONTH(date) =' . date('m') . ' ORDER BY sort DESC"; > > > > any ideas? > > > > thanks again!! > > > > date('m') was not parsed by php as it was in the string. Syntax > highlighting would help you see it. Try: > > "SELECT * FROM NewsArchive WHERE YEAR(date) = '" . date('Y') . "' AND > MONTH(date) ='" . date('m') . "' ORDER BY sort DESC";
Hi Marek, just tested it in phpMyAdmin: you don't need single quotes around the two date values and therefore don't need double quotes around the whole string - using single quotes around the string makes parsing the string faster (at least that's what I frequently read about single vs. double quotes). Regards, Torsten -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
