how to display data from mysql db

[edkuan]

Hi guys
im new to php so i hope u guys could help me
i've created a table in my sql listing the diners name and rating given :

diner name rating (star)
Diner A 4
Diner B 6
Diner C 2
Diner D 3
what I want to do is displaying it like this in the page
diner name rating (star)
Diner A *
Diner B
Diner C
Diner D **
the astrix here could be a gif of a star , how do I do this so that php would dynamicly create the star
im using php , dmx
thanks

[devinemke]

just guessing here at your exact data structure:

$result = mysql_query('SELECT * FROM ratings') or exit(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
	echo $row['name'] . ' ' . str_repeat('*', $row['rating']) . '<br>';
}

[edkuan]

thanks for your reply ! The code works 🙂 . what if i want to put in gif such as a star instead of an astrixs(*)?

thanks