davelearning Posted February 8, 2011 Share Posted February 8, 2011 I appear to be having a simple simon day! my foreach is only displaying the last result in the table as opposed to each row $num_rows = mysql_num_rows($query); echo "There are $num_rows records.<br>"; while($row = mysql_fetch_row($query)) foreach ($row as $field) { echo '<div class="results">'; echo $field; echo '<br></div>'; } And the source <link href="../styles/clientbox.css" rel="stylesheet" type="text/css"> <body><br> <h3>My Services</h3> <div class="text"> You currently have the following services with us: </div> There are 2 records.<br><div class="results">test1<br></div> </body> </html> My table has 2 rows which the 1st one has a package of test and the second a package of test1 Can anyone help? Thanks Quote Link to comment https://forums.phpfreaks.com/topic/227102-foreach-help/ Share on other sites More sharing options...
Pikachu2000 Posted February 8, 2011 Share Posted February 8, 2011 There wouldn't happen to be another occurrence of mysql_fetch_row() before that code, would there? Quote Link to comment https://forums.phpfreaks.com/topic/227102-foreach-help/#findComment-1171604 Share on other sites More sharing options...
davelearning Posted February 9, 2011 Author Share Posted February 9, 2011 no, but there was a mysql_fetch_assoc($query) ! Thank you once again for pointing me in the right direction Quote Link to comment https://forums.phpfreaks.com/topic/227102-foreach-help/#findComment-1171606 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.