Mysql WHERE Clause
Code
<table>
<thead>
<tr>
<th>Email</th>
<th>Password</th>
<th>Mobile</th>
<th>Date</th>
</tr>
</thead>
<tbody>
<?php
$sql = "SELECT * FROM users WHERE user_type = '1' ";
$result = mysqli_query($con,$sql);
while($row = mysqli_fetch_assoc($result))
{
?>
<tr>
<td><?=$row['email']?></td>
<td><?=$row['password']?></td>
<td><?=$row['mobile']?></td>
<td><?=$row['create_date']?></td>
</tr>
<?php
}
?>
</tbody>
</table>
Leave a Reply