Re: [PHP-DB] sorting on the first 8 digits....

2002-01-16 Thread DL Neil
John, > Ok, I did something stupid and now I am paying the > price... =boy am I glad that I'm not the only one in the world! How come the 'people' who extract these prices don't accept Mastercard? > In an internal database that tracks the time and date > something happens on our site, I mistak

[PHP-DB] sorting on the first 8 digits....

2002-01-15 Thread John Hawkins
Ok, I did something stupid and now I am paying the price... In an internal database that tracks the time and date something happens on our site, I mistakenly forgot to use leading zeros in the 24 hour column(s). So, anything that happens between 1-9 am are all short by one digit. Now, I need to c