Select randomly from mysqli php

<?php
	require'conn.php';
 
	$query=mysqli_query($conn, "SELECT * FROM `person` ORDER BY rand() LIMIT 6") or die(mysqli_error());
	while($fetch=mysqli_fetch_array($query)){
		echo"<tr>";	
		echo"<td>".$fetch['p_id']."</td>";
		echo"<td>".$fetch['firstname']."</td>";
		echo"<td>".$fetch['lastname']."</td>";
		echo"</tr>";
	}
?>

Source: sourcecodester.com

Similar codes

0 vote185 views1 answer
$mpdf
PHP
-1 vote263 views1 answer
Validate rule if row exist laravel
PHP Laravel
0 vote180 views1 answer
General errorstring fetchAll() php
PHP
-1 vote187 views1 answer
Change the php version in linux
PHP
5 votes195 views2 answers
Laravel group by with where clause
PHP
0 vote177 views3 answers
Laravel disable Logging
PHP
0 vote170 views1 answer
Refresh database tables yii 1
PHP
35 votes176 views5 answers
Remove the Last Character From a String in PHP
PHP
22 votes178 views3 answers
Carbon parse
PHP
0 vote193 views1 answer
Enfold remove debugging info for theme support
PHP