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 vote109 views1 answer
Update query in codeigniter using where condition
PHP
4 votes72 views1 answer
Php session variable
PHP
9 votes108 views4 answers
Datetime format laravel
PHP
3 votes152 views1 answer
Install all necessary php packages for laravel
PHP Laravel
1 vote110 views1 answer
Laravel sprintf span in controller
PHP
5 votes159 views3 answers
Get result count codeigniter
PHP CodeIgniter
1 vote115 views3 answers
Htaccess php version
PHP
2 votes115 views1 answer
Laravel create new request
PHP
0 vote152 views5 answers
Codeigniter.com cart
PHP CodeIgniter
13 votes107 views6 answers
Wordpress get user by id
PHP