Good afternoon, I'm trying to capture a value from my database through a query but this gives me an error, the code is as follows:
$consultarRepresentante = mysqli_query($conexion,
"select max(id_representante) from representantes") or die
("Problemas en el query".mysqli_error($conexion));
$registros = mysqli_fetch_array($consultarRepresentante);
echo $registros;
Here is the error:
Keep in mind that $registros refers to all the columns that you extract from a table, if you want to refer to a single column you should do it like this:
echo $registros['id_representante'];
$ records is the arrangement with the result of the query I suggest you do:
$consultarRepresentante = mysqli_query($conexion,
"select max(id_representante) as max_id from representantes") or die
("Problemas en el query".mysqli_error($conexion));
$registros = mysqli_fetch_array($consultarRepresentante);
echo $registros['max_id'];I would do it this way:
SELECT id FROM representantes ORDER BY id DESC LIMIT 1
mysqli_fetch_array: tells you the answer format of your query. There are others such as object, assoc. More info on this link: link