[PHP & MySQL] Sistema de codigos

<?php
session_start();
echo '<title>Almacenamiento de codes (:</title>';
// AdC - by v3n0m && SneaD - 09/02/2009 (:

$server = "localhost";
$user = "root";
$pass = "password";
$database = "db";

$con = mysql_connect($server,$user,$pass) or die(mysql_error());
mysql_select_db($database,$con) or die(mysql_error());



$pag = $_GET['pag'];
if ($pag == 0) {
$pag = 1;
}
$select = ($pag-1)*5;

$i=1;
$result = mysql_query ("SELECT * FROM `codes` ORDER BY `id` DESC LIMIT $select,5");
$largo = mysql_num_rows($result);

	while($i <= $largo ) {
	
		$row = mysql_fetch_array($resultado);
		
		$fecha = $row[fecha]; 
		$titulo = $row[titulo];
		$code = $row[code];
		
		echo '<h3'.date("d/m/Y","$fecha").'';
		echo '<br><a target="_blank" href="codes/'.date("Y/m","$row[fecha]").'/'.espacio($row[titulo]).'">'.$row[titulo].'</a>';
		echo "<br>Autor: $row[autor]";
		echo '<a target="_blank" href="codes/'.date("Y/m","$row[fecha]").'/'.espacio($row[titulo]).'">Ver codigo</a><br>';
		$i = $i + 1;
		}
// Pequeña tabla para estar un poquito organizados (:
echo "
<center>
<table style='width: 700px; height: 300px;'>
    <tr>
      <td>menu</td>
      <td><center>";
	  $selecode = mysql_query ("SELECT * FROM codes ORDER BY id DESC");
	  $l = mysql_num_rows ($selecode);
	  $p = ceil (l/10);
	  $next = $pag+1;
	  $ante = $pag-1;
	  if ($pag == 1) {
		echo "<span class='nave2'>&lt; Ultimos</span>";
		}else{
		echo "<span class='nave'><a href='index.php?pag=$ante'>&lt; Ultimos</a></span>";
	  }
	  echo "<span class='nave3'> | pagina <code>$pag</code> de $p | </span>";
	   if ($pag == $p) {
  	echo"<span class='nave2'>Anteriores &gt;</span>";
  } else {
  	echo"<span class='nave'><a href='index.php?pag=$next'>Anteriores &gt;</a></span>";
	}
	
	  echo "
	  
	  </td>
    </tr>
</table>
</center>
	";
	
function espacio($word)
	{
	$word=str_replace(" ","-",$word);
	$word=str_replace("?","",$word);
	$word=str_replace("¬","",$word);
	$word=str_replace("=","",$word);
	$word=str_replace("'","",$word);
	$word=str_replace('"',"",$word);
	$word=str_replace("/","",$word);
	$word=str_replace("\\","",$word);
		if(strlen($word)>"15")
		{
		$listo=substr($word, 0, 15);
		}
		else
		{
		$listo=$word;
		}
	return $listo;
}

?>

CREATE TABLE `codes` (
`id` VARCHAR( 100 ) NULL ,
`titulo` VARCHAR( 100 ) NOT NULL ,
`autor` VARCHAR( 100 ) NOT NULL ,
`fecha` VARCHAR( 100 ) NOT NULL ,
`code` VARCHAR( 800 ) NOT NULL
) ENGINE = MYISAM ;