Database Not Echoing Properly

[Epiales]

I've spent a few hours and I can't figure out the error. It's so darn simple it's hard

Why won't it echo the database?

[Jackolantern]

If even your test echo is not printing, that means your WHILE loop isn't running. I would start investigating there to see what you are actually getting into the $row. If $row is empty the first time the WHILE runs, it will be skipped.

[Epiales]

If even your test echo is not printing, that means your WHILE loop isn't running. I would start investigating there to see what you are actually getting into the $row. If $row is empty the first time the WHILE runs, it will be skipped.

Well if I take this out of the file:

Code: Select all

while ($row = mysqli_fetch_array($user_query, MYSQLI_ASSOC)) {

Then it will display the first item and all its rows but not the other items. Only the first one. For some reason, the while is just not working and it doesn't make sense. It even displays the items picture, but only for the first item, and if I put the while back in, it removes it all except the headers I created above.

This is the actual echo statement I use to list the items:

Code: Select all

echo "<tr align='left'><td><img src = '".$row['image']."'height='100' width='100'></td><td>$row[name]</td><td>$row[strength]</td><td>$row[defense]</td><td>$row[price]</td><td><A href='buy_item.php?randid=$row[randid]'><font color='red'>Buy Item</font></td></tr>";

So in otherwords, my echo is written correctly, because when I remove the while loop, it does echo the first row in the database, but not the other rows. We need a pull u're hair out emoticon

[Epiales]

Oh Lord.... I had for location : United States..... it's supposed to be United States of America

Thanks for telling me to further dig into the while and see the rows.

[Jackolantern]

No problem! Glad you fixed it