Re: repeating data from one column until data from another column changes

> 'SELECT * FROM table WHERE YEAR(date) = ' . date('Y') . ' AND > MONTH(date) = > ' . date('m') . ' ORDER BY SORT DESC' > > What column type is your date column of? I know that the above statement > works with the MySQL date (YYYY-MM-DD) and datetime column types. > > Regards, Torsten > > > > > does this help? 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!!