[RESOLVED] Loop problem

[dassyka]

Hi people,
I'm new with php and mysql and i have a little problem with a loop!

Here's my code:

<?php

$db = new mysqli('localhost','root','','eurodib');

$query = "select distinct cat_name from categorie";

$result = $db -> query($query);

$row = $result -> fetch_assoc();

echo '<br>Categories:<br/>';
echo $row['cat_name'];

?>

I have the result here:

Categories:
Dishwasher

So my question is, what did i miss in my code for the other categories to appear in the list?😕

thank you very much to help me!

[igorlopez]

Maybe this:

echo '<br>Categories:<br/>';
while($row = $result -> fetch_assoc())
{
   echo $row['cat_name'] ."<br>";
}

[dassyka]

Thank you very much! Working at 90%, i have my categories except for one, the first one! I really don't know how come and what to do?😕

do you have an idea?

[igorlopez]

Yes, you need to remove the first assignment of $row, i.e.

<?php

$db = new mysqli('localhost','root','','eurodib');

$query = "select distinct cat_name from categorie";
echo '<br>Categories:<br/>';
while($row = $result -> fetch_assoc())
{
   echo $row['cat_name'] ."<br>";
} 
?>

Don't forget to mark the thread as resolved

[dassyka]

Thank you, Thank you so much!!! You don't know how you just save me!!!!😃