en esta pagina debo de ver los reultados la imagen la guardo en un tabla y el campo es de tipo blob
Código PHP:
<?php require_once('Connections/atabasco.php'); ?><?php
$maxRows_DetailRS1 = 10;
$pageNum_DetailRS1 = 0;
if (isset($_GET['pageNum_DetailRS1'])) {
$pageNum_DetailRS1 = $_GET['pageNum_DetailRS1'];
}
$startRow_DetailRS1 = $pageNum_DetailRS1 * $maxRows_DetailRS1;
mysql_select_db($database_atabasco, $atabasco);
$recordID = $_GET['recordID'];
$query_DetailRS1 = "SELECT * FROM `local` WHERE titulo = '$recordID'";
$query_limit_DetailRS1 = sprintf("%s LIMIT %d, %d", $query_DetailRS1, $startRow_DetailRS1, $maxRows_DetailRS1);
$DetailRS1 = mysql_query($query_limit_DetailRS1, $atabasco) or die(mysql_error());
$row_DetailRS1 = mysql_fetch_assoc($DetailRS1);
if (isset($_GET['totalRows_DetailRS1'])) {
$totalRows_DetailRS1 = $_GET['totalRows_DetailRS1'];
} else {
$all_DetailRS1 = mysql_query($query_DetailRS1);
$totalRows_DetailRS1 = mysql_num_rows($all_DetailRS1);
}
$totalPages_DetailRS1 = ceil($totalRows_DetailRS1/$maxRows_DetailRS1)-1;
?>
<html>
<head>
<title>Documento sin título</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<table border="1" align="center">
<tr>
<td>titulo</td>
<td><?php echo $row_DetailRS1['titulo']; ?> </td>
</tr>
<tr>
<td>sumario</td>
<td><?php echo $row_DetailRS1['sumario']; ?> </td>
</tr>
<tr>
<td>texto</td>
<td><?php echo $row_DetailRS1['texto']; ?> </td>
</tr>
<tr>
<td>imagen</td>
<td><img src="<?php echo '../imagenes/$row_table[imagen]' ;?>" >
</tr>
</table>
</body>
</html><?php
mysql_free_result($DetailRS1);
?>