[PHP-DB] timestamp problem

2003-03-13 Thread drparker
I'm using the timestamp column type in a database, and the only problem is that it the stamp is three hours prior to the actual post when I post to a remote server. I'm assuming, since it works fine on my machine, that this is because the remote server I am is in a different time zone. Is there

[PHP-DB] retrieve last n records

2003-03-06 Thread drparker
I need to retrieve the last n records of a table, n will probably be 2 or 3. I know that I can accomplish this by: select * from table order by field DESC Limit n, but i would prefer not to do this way because it interferes with my sorting mechanism on the main page. Is there any other way to do

Re: [PHP-DB] retrieve last n records

2003-03-06 Thread drparker
queries are not related. The second thing I am confused on is: Do you want the last n records that were added to the table or do you want the last n records in a given index? Jim ---Original Message--- From: drparker Date: Thursday, March 06, 2003 13:46:58 To: [EMAIL PROTECTED