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

5 votes251 views5 answers
Convert php array to javascript array
PHP
33 votes211 views4 answers
Php unset array key
PHP
6 votes193 views4 answers
Return message in laravel
PHP
0 vote182 views1 answer
Artisan command on live server
PHP
2 votes174 views2 answers
Sleep microseconds php
PHP
0 vote229 views1 answer
Drupal 9 custom access checking for routes
PHP Drupal
1 vote185 views1 answer
Add 1 day php datetime
PHP
-1 vote181 views1 answer
Php download script
PHP
3 votes227 views2 answers
How to check null and empty array in laravel 8
PHP Laravel
0 vote197 views1 answer
Laravel api get controller
PHP Laravel