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>