Looping Names

[mch987]

trying to write a code that will repeat a name until it gets to the number on the database.

Database Information

Name Number

Mike 2

Oscar 2

Robert 1

 

Wanted to look like

Full Name

Mike

Mike

Oscar

Oscar

Robert

 

 

Here is my Code

<?php
$result = mysql_query("SELECT * FROM `people`");
echo
"<table border='1'>
<tr>
<th>Full Name</th>
<th> </th>
</tr>";
for ($i = 1 , $row = mysql_fetch_array($result) ; $i <= $row['Number'] ; $i++ )
{
echo "<tr>";
echo "<td>" . $row['Name'] . "</td>";
echo "<td> </td>";
echo "</tr>";
}
echo "</table>";
?>

When i run the code it will only show the result like this

Full Name

Mike

Mike

 

and when i put the "for" again in the bottom of the first one it will show like this

Full Name

Mike

Mike

Oscar

Oscar

 

 

<?php
$result = mysql_query("SELECT * FROM `people`");
echo
"<table border='1'>
<tr>
<th>Full Name</th>
<th> </th>
</tr>";
for ($i = 1 , $row = mysql_fetch_array($result) ; $i <= $row['Number'] ; $i++ )
{
echo "<tr>";
echo "<td>" . $row['Name'] . "</td>";

echo "<td> </td>";
echo "</tr>";
}
for ($i = 1 , $row = mysql_fetch_array($result) ; $i <= $row['Number'] ; $i++ )
{
echo "<tr>";
echo "<td>" . $row['Name'] . "</td>";


echo "<td> </td>";
echo "</tr>";
}
echo "</table>";
?>

 

 

i need something to repeat "For" until it finishes all the Names

[Muddy_Funster]

how about

while($row = mysql_fetch_assoc($result)){
$num = $row['Number'];
if($num > 1){
for($i=0;$i<$num;$i++){
echo $row['name'];
}
}
else{
echo $row['name'];
}
}

you'll need to add in your own formatting, and the code is untested - but while loops are the standard (with refference to usage) way of looping through database results.

[mch987]

Thank You!!!

 

It worked

[Muddy_Funster]

glad I could help.

[Christian F.]

I'd use str_repeat () in this instance, no point in using loops if you don't have to.