mySQL LIMIT and ORDER BY Problem???

2004-07-04 Thread Gary Mack
Hi there, I recently learned about LIMIT so that I can page through records on a web page I am creating. However, when coupled with ORDER BY, the sorting does not work anymore. Can someone look at my below query and point out what I am doing wrong? Thanks. This is my first time posting to

converting timestamps to US Date format

2004-07-05 Thread Gary Mack
Hi there, I am having trouble converting a timestamp from mySQL to the US Format mm/dd/. Can someone please help. I am also having trouble converting -mm-dd into a normal mm/dd/ format as well. I am using the following line of code: date('m/d/Y', $row10['modified']); $row10[