php - My table is not populating correctly -


i trying grab mysql table throw table. reason, it's throwing 1 row instead of creating new rows more data.

i have code here:

 <?php         //display current users asc on view         $q="select * users order id asc";         $r=mysqli_query($dbc,$q);          ?>  <div class="panel panel-default">   <!-- default panel contents -->   <div class="panel-heading">user manager</div>   <div class="panel-body">     <p>some default panel content here. nulla vitae elit libero, pharetra augue. aenean lacinia bibendum nulla sed consectetur. aenean eu leo quam. pellentesque ornare sem lacinia quam venenatis vestibulum. nullam id dolor id nibh ultricies vehicula ut id elit.</p>   </div>    <!-- table --> <div class="table-responsive">             <table class="table table-striped">               <thead>                 <tr>                   <th>userid</th>                   <th>first name</th>                   <th>last name</th>                   <th>email</th>                   <th>status</th>                   <th>role</th>                 </tr>               </thead>               <tbody>                 <?php  echo "<tr>"; // display users onto table     while (($list= mysqli_fetch_assoc($r))){             echo"<td>".$list['id']."</td>";             echo"<td>".$list['fname']."</td>";             echo"<td>".$list['lname']."</td>";             echo"<td>".$list['email']."</td>";             echo"<td>".$list['status']."</td>";             echo"<td>".$list['role']."</td>";      }                 echo"</tr>";?>                       </tbody>             </table>           </div>  </div> 

all tr tags out of loop.


Comments

Popular posts from this blog

PHPMotion implementation - URL based videos (Hosted on separate location) -

c# - Unity IoC Lifetime per HttpRequest for UserStore -

I am trying to solve the error message 'incompatible ranks 0 and 1 in assignment' in a fortran 95 program. -