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 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? 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 Link to comment https://forums.phpfreaks.com/topic/227102-foreach-help/#findComment-1171606 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.