Printing Data In a Loop

[MrBojangle1]

Hey, I need some help. How would I go about printing data using a loop from a certain table? I think Mewtwo's Itemshop uses it, as an example.

Say this is my table structure:

ID(Primary Key) | name | image
1 | archer | archer.gif
2 | archmage | archmage.gif
3 | assasin | assasin.gif

How would I print that data in a loop? Then get it to display all the info? Any help would be appreciated. :dead:

[mr e]

$getinfo = mysql_query("SELECT * FROM table");
while($info = mysql_fetch_array($getinfo)) {
print "$info[id] | $info[name] | $info[image]<br>";
}

[MrBojangle1]

Thanks mr e! You seem to always be the solution to people's problems. ;)

[mr e]

lol no problem :D

[filburt1]

Just remember not to query in a loop. A few hacks do that and their authors should be smacked :)