Stealth549

Thanks for your help, I got the results I was looking for using the time() function.

I wasn't sure where to post this either this section or the mysql section. Anyway I have a automated timestamp within mysql. Now when I use the date function I dont get the result that I was expecting. Getting the incorrect date. this is the code that I am using and the results can be seen at the url below. date("Y-m-d",$row['date']) http://stealth549.com/dev/news/customer/php/includes/datetest.php Thanks for any help.

ah, thanks.

I still get the error if I take that out, The field is varchar( and it stores numbers

there is still an error with all that. I have another query that is similar but works, all that is different is that i dont have newspaper.cost. $sql = "SELECT subs.news_id, subs.cust_id, subs.sub_id, newspaper.name, newspaper.$day, newspaper.id FROM subs , newspaper WHERE subs.news_id = newspaper.id AND newspaper.$day = 'on'";

Hey everyone, getting a sql error that I cannot pin down. sql query $sql = "SELECT subs.news_id, subs.cust_id, subs.sub_id, newspaper.name, newspaper.$day, newspaper.cost, newspaper.id FROM subs , newspaper WHERE subs.news_id = newspaper.id AND newspaper.$day = 'on'";