hice una tabla para que me aparezcan los resultados de la consulta en mysql y en mysql todo corre bien y normal de hecho desde desde myadmin me muestra los resultados, pero en la pagina solo me arroja un cuadro vacio..... aqui esta mi codigo
<?php require_once('Connections/localhost.php'); ?>
<?php
$nom= $_POST['nombre'];
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$colname_consulta = "-1";
if (isset($_GET['nom'])) {
$colname_consulta = $_GET['nom'];
}
mysql_select_db($database_localhost, $localhost);
$query_consulta = sprintf("SELECT * FROM resultcam WHERE nom = '$nom'", GetSQLValueString($colname_consulta, "var"));
$consulta = mysql_query($query_consulta, $localhost) or die(mysql_error());
$row_consulta = mysql_fetch_assoc($consulta);
$totalRows_consulta = mysql_num_rows($consulta);
?>
<table width="990" border="1">
<tr>
<td>NUMERO</td>
<td>CATEGORIA</td>
<td>LUGAR</td>
<td>NOMBRE</td>
<td>TIEMPO TOTAL</td>
<td>TIEMPO CHIP</td>
<td>PASO</td>
<td>POS. G.</td>
<td>POS. SEX.</td>
</tr>
<tr>
<td><?php echo $row_consulta['num']; ?></td>
<td><?php echo $row_consulta['raceg']; ?></td>
<td><?php echo $row_consulta['divpl']; ?></td>
<td><?php echo $row_consulta['nom']; ?></td>
<td><?php echo $row_consulta['guntime']; ?></td>
<td><?php echo $row_consulta['chiptime']; ?></td>
<td><?php echo $row_consulta['pace']; ?></td>
<td><?php echo $row_consulta['overal']; ?></td>
<td><?php echo $row_consulta['sexpl']; ?></td>
</tr>
</table>
<?php
mysql_free_result($consulta);
?>
