PHP 101: Ζήτημα Β2

Καλησπέρα !!

Θα ηθελα την βοηθεια σας γιατι έχω κολλήσει στο Β2...

Ενώ συνδέομαι στον υπολογιστή υπηρεσίας localhost δεν μπορώ να συνδεθώ
στην βάση azulmediadb και να τραβήξω τις εγγραφές...

Παρακάτω παραθέτω τον κώδικα php >>

<?php

DEFINE('DB_HOST','localhost');
$lch = @mysqli_connect(DB_HOST);
if($lch == TRUE )
{
print "the connection to the server was succesful ";
print " ";
}else
{
print "the connection to the server was not succesful ";
print " ";
@mysqli_connect_error();
}

DEFINE('DB_NAME','azulmediadb');
$dbc = @mysqli_select_db($lch,DB_NAME);
if($dbc == TRUE){
print "the connection to the database was succesful ";
print " ";
}else
{
print "the connection to the database was not succesful ";
print " ";
}

$q = "SELECT*FROM style";
$results = @mysqli_query($lch,$q);

if($results) {
$rows = @mysqli_num_rows($results);
print "Υπάρχουν $rows γραμμές αποτελέσματων ";
print " ";
}else{
print "there was an error with the execution of the SQL Query ";
print " ";
}

while($retrec = mysqli_fetch_array($results,MYSQLI_ASSOC))
{
$id = $retrec['id'];
$color = $retrec['color'];
$url = $retrec['URL'];
}

?>

Τι στο καλό κάνω λάθος;;

Τελικά βρήκα τι έκανα λάθος...

<?php

DEFINE('DB_HOST','localhost');
DEFINE('DB_USER','root');
$lch = @mysqli_connect(DB_HOST,DB_USER,NULL);
if($lch == TRUE )
{
print "the connection to the server was successful ";
print " ";
}else
{
print "the connection to the server was not successful ";
print " ";
@mysqli_connect_error();
}

DEFINE('DB_NAME','azulmediadb');
$dbc = @mysqli_select_db($lch,DB_NAME);
if($dbc == TRUE){
print "the connection to the database was successful ";
print " ";
}else
{
print "the connection to the database was not successful ";
print " ";
}

$q = "SELECT*FROM style";
$results = @mysqli_query($lch,$q);

if($results) {
$rows = @mysqli_num_rows($results);
print "There are $rows rows/records in the database ";
print " ";
}else{
print "there was an error with the execution of the SQL Query ";
print " ";
}

while($retrec = @mysqli_fetch_array($results,MYSQLI_ASSOC))
{
$id = $retrec['id'];
$color = $retrec['color'];
$url = $retrec['URL'];
}

?>

Το αποτέλεσμα που μου βγάζει τώρα είναι...

the connection to the server was successful

the connection to the database was successful

There are 3 rows/records in the database

Εμφάνιση γονέα