![Antiguo](http://static.forosdelweb.com/fdwtheme/images/statusicon/post_old.gif)
04/06/2007, 10:56
|
![Avatar de fmb1982](http://static.forosdelweb.com/customavatars/avatar184220_2.gif) | | | Fecha de Ingreso: junio-2007
Mensajes: 128
Antigüedad: 17 años, 8 meses Puntos: 0 | |
Re: Problemas con consulta.. <?php
$dbhost = 'localhost';
$dbuser = 'root';
//$dbpass = 'password';
$conn = mysql_connect($dbhost, $dbuser);
$cad1=$_POST['cad'];
$result = mysql_db_query("cop_dat","select * from usr_dat where usr_ape1=".$cad1."");
while($row = mysql_fetch_array($result)) {
echo "<TABLE BORDER=2><TR>";
echo "<TD><b>Nombre: </b>".$row["usr_nom"]."</TD>";
echo "<TD><b>Apellido Paterno: </b>".$row["usr_ape1"]."</TD>";
echo "<TD><b>Apellido Materno: </b>".$row["usr_ape2"]."</TD>";
echo "</TR>";
echo "<TR>";
echo "<TD><b>RFC: </b>".$row["usr_rfc"]."</TD>";
echo "<TD><b>CURP: </b>".$row["usr_date"]."</TD>";
echo "<TD><b>ID: </b><input name=id type=text id=textfield value=$row[usr_id] size=5 /></TD>";
echo "</TR></TABLE>";
echo "<br><br>";
echo "</form>";
}
mysql_free_result($result);
?>
De todas formas no jala.......
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\xampplite\htdocs\resultado.php on line 9
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resour......... |