Show database data that is in another id after the id 0

Question

Show database data that is in another id after the id 0

Navigation

#1 by (0 votes)

0

I want to show data from a database. I already know this, but only everything that is in id 0 of the base table is shown, and now I want to show what is in table 2. For example

 id   dato1   dato2
 0    abc     def
 1    ghi     jkl

Well, what you are "ID: 0" and it will show, but what is "ID: 1" not as shown, this is my method to display:

$sql_dbdatos = "SELECT * from datos";
$result_dbdatos= mysqli_query($conexion,$sql_dbdatos);
$rows_dbdatos = mysqli_fetch_array($result_dbdatos);

And this I put in a table:

<li>  ' . $rows_dbpartidos['dato1'] . '</li>

mysql php

asked by ArthurGibbs 11.07.2018 в 01:22

source

1 answer

How to print from python to a ticket printer Move an item within another SCSS

score 0 · Answer 1

___ erkimt ___ Show database data that is in another id after the id 0 ______ qstntxt ___

I want to show data from a database. I already know this, but only everything that is in id 0 of the base table is shown, and now I want to show what is in table 2. For example

$sql_dbpartidos = "SELECT * from datos";
$result_dbdatos= mysqli_query($conexion,$sql_dbdatos);
echo '<ul>';
while($rows_dbdatos = mysqli_fetch_array($result_dbdatos)) {

    echo '<li>  ' . $rows_dbdatos['dato1'] . '</li>';
}
echo '</ul>';

Well, what you are "ID: 0" and it will show, but what is "ID: 1" not as shown, this is my method to display:

$sql_dbpartidos = "SELECT * from datos";
$result_dbdatos= mysqli_query($conexion,$sql_dbdatos);
echo '<ul>';
while($rows_dbdatos = mysqli_fetch_array($result_dbdatos)) {

    echo '<li>  ' . $rows_dbdatos['dato1'] . '</li>';
}
echo '</ul>';

And this I put in a table:

%pre%

______ ___ azszpr179392

You just have to add a cycle while as follows:

%pre%

___