mch987 Posted January 3, 2013 Share Posted January 3, 2013 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 Quote Link to comment Share on other sites More sharing options...
Muddy_Funster Posted January 3, 2013 Share Posted January 3, 2013 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. Quote Link to comment Share on other sites More sharing options...
mch987 Posted January 3, 2013 Author Share Posted January 3, 2013 Thank You!!! It worked Quote Link to comment Share on other sites More sharing options...
Muddy_Funster Posted January 3, 2013 Share Posted January 3, 2013 glad I could help. Quote Link to comment Share on other sites More sharing options...
Christian F. Posted January 7, 2013 Share Posted January 7, 2013 I'd use str_repeat () in this instance, no point in using loops if you don't have to. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.