I have this code that is perfect and everything, but my question is, how would you do to show the data? I mean when I make a simple query, it's enough for me to write:
**while($datosx = mysqli_fetch_array($consulta)){
echo $datosx["fila de la tabla"]; }**
but now my code is as follows:
$consulta= "SELECT publicaciones.usuario, amigos.id_1, amigos.id_2,
publicaciones.id
FROM publicaciones, amigos
WHERE publicaciones.usuario =
amigos.id_1 and amigos.id_2 = '$id' ";
$resultado_consulta = mysqli_query($conexion,$consulta);
I related two tables to be able to filter only elements that I want, but my question is how can I show the data I take?