Error in mysql_fetch_array

Navigation
0

this is the error:

  

Warning: mysql_fetch_array () expects parameter 1 to be resource,   boolean given in C: \ xampp \ htdocs \ 10-1 \ workshopfinal \ consult1.php on   line 6 

<?php
$documento=$_REQUEST["documento"];
$conexion=mysql_connect("localhost","root","");
mysql_select_db("boutique")or die("No se conecto a la base de datos");
$consulta=mysql_query("select documento,nombre,apellido from anadir1 where DOCUMENTO='".$documento."'");
while($consultax= mysql_fetch_array($consulta)){
echo $consultax ["documento"]."<br>";
echo $consultax ["nombre"]."<br>";
echo $consultax["apellido"]."<br>";
echo $consultax ["telefono"]."<br>";
echo $consultax ["correo"]."<br>";
echo $consultax ["edad"]."<br>";
}
?>
    
asked by Allison Loaiza 19.11.2017 в 01:11
source

1 answer

0

mysql_fetch_array() returns an array, so in order to access the values you should do a foreach and traverse the array. Also another way to access is: 

"; echo $consultax [0] ["nombre"]."
"; echo $consultax[0]["apellido"]."
"; echo $consultax[0] ["telefono"]."
"; echo $consultax [0]["correo"]."
"; echo $consultax[0] ["edad"]";
    
answered by 19.11.2017 в 01:46
how to prevent messsagebox from opening another window? Use UML Diagrams