Tech Support Guy banner
Status
Not open for further replies.
1 - 1 of 1 Posts

·
Registered
Joined
·
15 Posts
Discussion Starter · #1 ·
i'm making a news script... stuck at news archiving!
my Q is how to make a link which will on the next page select all stories that are posted in january this year for example. i use unix time in the table.

this is the code that i've got:

<?php print "january";?>
on months.php i have the following code:

$result = mysql_query("SELECT * FROM stories where modified between $p and $k ");

this works but i don't like the idea of having to put unix times in links. there has to be a better way to do this.

how can i convert 31-Jan-2005 23:59:59 to unix time format?
 
1 - 1 of 1 Posts
Status
Not open for further replies.
Top