Welcome, Guest. Please login or register.
Forums
« previous next »
Pages: [1]   Go Down

Author Topic: How to search the Archive?  (Read 3967 times)

Description:

0 Members and 1 Guest are viewing this topic.

Offline Karlos

  • Sockologist
  • Global Moderator
  • Hero Member
  • *****
  • Join Date: Nov 2002
  • Posts: 16879
  • Country: gb
  • Thanked: 5 times
    • Show all replies
Re: How to search the Archive?
« on: April 06, 2011, 07:27:46 PM »
@bloodline

Try:

SELECT FROM_UNIXTIME(dateline) AS date_posted, title, pagetext FROM post WHERE userid=298 ORDER BY dateline ASC LIMIT 100;

voila:

http://www.amiga.org/forums/showpost.php?p=459470&postcount=1
« Last Edit: April 06, 2011, 07:39:01 PM by Karlos »
Logged
int p; // A
 
Pages: [1]   Go Up
« previous next »