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 vote328 views1 answer
Php random number generator tool : https://arandomgenerator.com/random-number-generator-decimal/
PHP
0 vote341 views1 answer
Add Empty Cart Button WooCommerce
PHP
0 vote309 views1 answer
Laravel blade image
PHP
0 vote396 views2 answers
WordPress add query string to URL
PHP Wordpress
1 vote292 views1 answer
Prestashop get all products
PHP
7 votes320 views2 answers
Php image to base64
PHP
4 votes371 views1 answer
Laravel relation of relation
PHP Laravel
1 vote357 views2 answers
How to use custom domain name on localhost on linux ubuntu
PHP
13 votes382 views1 answer
Create contoller with model and migration
PHP
0 vote317 views1 answer
Using custom fonts in php
PHP