paulo@0: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> paulo@0: <HTML> paulo@0: <HEAD> paulo@0: <META NAME="generator" CONTENT="http://txt2tags.sf.net"> paulo@0: <LINK REL="stylesheet" TYPE="text/css" HREF="index.css"> paulo@0: <TITLE>-[pauloang.com]-</TITLE> paulo@0: </HEAD> paulo@0: <BODY> paulo@0: paulo@0: <DIV CLASS="header" ID="header"> paulo@0: <H1>-[pauloang.com]-</H1> paulo@0: </DIV> paulo@0: paulo@0: <DIV CLASS="body" ID="body"> paulo@0: <DL> paulo@0: paulo@0: <?php paulo@0: paulo@0: include('../login.php'); paulo@0: $database = 'pauloang_index'; paulo@0: paulo@0: $link = mysql_connect('localhost', $username, $password); paulo@0: if (!$link) paulo@0: die('Could not connect to MySQL server: ' . mysql_error()); paulo@0: paulo@0: $db_selected = mysql_select_db($database, $link); paulo@0: if (!$db_selected) paulo@0: die('Could not select database: ' . mysql_error()); paulo@0: paulo@50: $query = 'SELECT * FROM Links ORDER BY LastMod DESC'; paulo@0: $results = mysql_query($query); paulo@0: paulo@0: while ($row = mysql_fetch_assoc($results)) { paulo@0: echo '<DT>'; paulo@0: echo '<A HREF="'.$row['URL'].'">'.$row['Title'].'</A>'; paulo@0: echo '</DT>'."\n"; paulo@0: echo '<DD>'; paulo@0: echo '<DIV CLASS="index_date">'; paulo@0: echo 'First added: '.$row['FirstMod'].' '.'<BR>'; paulo@23: if (($row['LastMod'] != '') && ($row['LastMod'] != $row['FirstMod'])) paulo@23: echo 'Last modified: '.$row['LastMod']; paulo@0: echo '</DIV>'; paulo@0: echo '</DD>'."\n"; paulo@0: } paulo@0: paulo@0: mysql_free_result($results); paulo@0: mysql_close($link); paulo@0: ?> paulo@0: paulo@0: </DL> paulo@0: paulo@0: <DIV CLASS="email"> paulo@0: <P><A HREF="mailto:pbba13@gmail.com">pbba13@gmail.com</A></P> paulo@0: </DIV> paulo@0: paulo@0: </DIV> paulo@0: paulo@0: <!-- html code generated by txt2tags 2.4 (http://txt2tags.sf.net) --> paulo@0: <!-- cmdline: txt2tags index.t2t --> paulo@0: </BODY></HTML>