sort links by date with PHP ? - GoFuckYourself.com

Alessandro · 11-23-2003, 03:54 AM

hi ,
I need a script that sorts my links (thumbs + text) by date .
Anyone knows a good one ?

ppk · 11-23-2003, 03:59 AM

What format is the raw data in?

Alessandro · 11-23-2003, 04:02 AM

Quote:

Originally posted by ppk
What format is the raw data in?

can you ICQ me ? #132818937

pornanza · 11-23-2003, 06:25 AM

SELECT title, url FROM links ORDER BY date DESC;

ryan

wsjb78 · 11-23-2003, 06:36 AM

Quote:

Originally posted by pornanza
SELECT title, url FROM links ORDER BY date DESC;

ryan

And for entering the date:

PHP Code:


			
$time_now = mkdate();

$sql = "INSERT INTO link SET title='$title', url='$url', date='$time_now'";

if(mysql_query($sql) {

  echo "New link successfully added";

} else {

  echo "Could not add new link";

}

assistant27 · 11-26-2003, 12:45 AM

hyper · 11-26-2003, 12:53 AM

select * from table order by date desc

11-23-2003, 03:59 AM	#2
ppk Confirmed User Join Date: Dec 2002 Location: Near a computer Posts: 214	What format is the raw data in? __________________ Buy Quality Gallery Traffic for as little as $0.85/K! Sell Quality Gallery Traffic!

11-26-2003, 12:45 AM	#6
assistant27 So Fucking Banned Join Date: Mar 2003 Posts: 256	....

11-26-2003, 12:53 AM	#7
hyper Confirmed User Join Date: Mar 2002 Location: Mass Ass Posts: 5,294	select * from table order by date desc __________________

11-23-2003, 03:54 AM	#1
Alessandro Confirmed User Join Date: Oct 2002 Posts: 283	sort links by date with PHP ? hi , I need a script that sorts my links (thumbs + text) by date . Anyone knows a good one ? __________________ suck my sig

11-23-2003, 06:25 AM	#4
pornanza Confirmed User Join Date: Jul 2003 Location: East Village Posts: 238	SELECT title, url FROM links ORDER BY date DESC; ryan