synking Posted April 2, 2012 Share Posted April 2, 2012 Hey guys tried to search for this but didn't find anything usefull about the issue. So what i have is mssql_fetch_array in a while loop in the loop i have it assign a specified row as a variable that i can print later on in the page. while($row = mssql_fetch_array($query) { $tables = "<tr>"; $tables .= "<td> {$row['specifiedrow']} </td>"; $tables .= "</tr>"; } Then i call it in the html table as <? php echo $tables; ?> I have done this with mysql_fetch_array before and it would print the entire database row associated with that row in the table. But as it is now it only returns the last row from the database. Is there something i am missing. Thanks for any help Quote Link to comment Share on other sites More sharing options...
cpd Posted April 2, 2012 Share Posted April 2, 2012 It's because your overwriting your $tables variable with the first line after your while line. The correction would be as follows $tables = ""; while(DO STUFF){ $tables .= "<tr>"; $tables .= "<td> {$row['specifiedrow']} </td>"; $tables .= "</tr>"; } also if your using PHP 5.4, or 5.3< with "short open tags" on, you can just do <?=$tables;?> Quote Link to comment Share on other sites More sharing options...
synking Posted April 2, 2012 Author Share Posted April 2, 2012 Thanks i honestly did not see that at all. 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.