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 vote321 views1 answer
Phpexcel rangetoarray date format
PHP
28 votes280 views4 answers
String remove last two characters php
PHP
8 votes290 views1 answer
How to list out routes
PHP
1 vote308 views1 answer
Var_dump smarty
PHP
0 vote267 views3 answers
Laravel transform object to array
PHP
0 vote298 views1 answer
Convert query result to array php
PHP
1 vote289 views1 answer
Return response array laravel
PHP
0 vote297 views1 answer
Asas
PHP
2 votes278 views1 answer
Wordpress check user against user roles
PHP
5 votes312 views2 answers
Laravel print exception message
PHP Laravel