Just get first mysql request why?

Question

Hello I have 3 mysql request but just for the first i get a reponse does anyone knoe why

$db_link=mysqli_connect("localhost", "root","", "osteodb") or die("sth went wrong");

$db_res= mysqli_query($db_link, "SELECT * FROM `videos` ORDER BY CAST(`Modul` AS INT)");
$array=array();
while($row=mysqli_fetch_array($db_res)){
array_push($array,$row);
}

$db_res= mysqli_query($db_link, "SELECT * FROM `module` ORDER BY CAST(`modul` AS INT)");
$moduleArray=array();
while($row=mysqli_fetch_array($db_res)){
array_push($moduleArray,$row);
}

$db_res2= mysqli_query($db_link, "SELECT * FROM `lehrveranstaltungen` ORDER BY CAST(`id` AS INT)");
$lehrverArray=array();
while($row=mysqli_fetch_array($db_res2)){
array_push($lehrverArray,$row);
}

Answer 1

solution was just get rid of the json_encode infront of the $row ;-)

while($row=mysqli_fetch_array($db_res)){
if ($row!=false) {
array_push($modulArray, $row);
}

Answer 2

not sure if 'Modul' or 'modul' are in your table. please understand that i dont know how the headers of table are defined, so please check again only to make sure if there's a spelling error

Answer 3

from what i see at the 3rd one you put some extra letters in the table name. try to close the connection to the database at the end of the code.

Answer 4

Found the mistake its cause of the ä ü ö
in every row with some of these öäü I get a false insted of the array in the json.
But dont know realy how to solve that

Answer 5

Seems like my last answer didnt get posted.
so there is a table named: videos
Colums are: id, Modul, Semester, path..
A table named: module
With colums: id, modul, mName
And a table named: veranstaltungen
With colums: id, modul, veranstaltung

Answer 6

No ment lehrveranstaltungen sorry.
Im really dont know anymore what to do

Answer 7

cause i get no error; it seems to work just retursn nothin. if i change the table name wrong ill get an error

Answer 8

the querry with videos was always working fine. But the other two just get nothin back though the tables are filled