archives with unix_timestamp

scott122

i'm redoing my archives to work with a mysql database. each row in my weblog has a unix_timestamp. i want to know how i can get it through something like this: '/archives/view.php?year=02&month=03&day=25'

so far i've gotten this from a few of my friends.

$date1 = mktime(0,0,0,$month,$day,$year);

$query = mysql_query("select * from weblog where date='$date1'");

it's not working so i know i did something wrong. anyone know what's up?

nnichols

Try -

$date1 = mktime(0,0,0,$month,$day,$year); 
$date2 = mktime(0,0,-1,$month,$day+1,$year); 

$query = mysql_query("select * from weblog where date BETWEEN $date1 AND $date2");

Haven't tested it but it should work.

Hope this helps 😉

scott122

i get this:

Fatal error: Call to undefined function: mysql_query() in x on line 37

line 37 is

'$query = mysql_query("select * from weblog where date between $date1 and $date2");'

nnichols

That probably means you have php installed without the mysql client libraries compiled in.

What platform are you running this on?
Is it your local machine?

scott122

i running this off of my server over at http://www.segpub.com.au.

i'm on a mac with safari v74.

nnichols

What is the server this is running on?

Can you popup a phpinfo() page so I can check the php config?