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

24 votes165 views10 answers
Dogecoin
PHP
0 vote148 views2 answers
Smtp server xampp
PHP
0 vote159 views1 answer
Laravel override eloquent all function
PHP Laravel
0 vote167 views2 answers
Woocommerce get user id by email
PHP
0 vote194 views1 answer
Laravel A row must be an array or a TableSeparator instance.
PHP
0 vote145 views1 answer
How to print on console with phpunit
PHP
3 votes136 views3 answers
Php array to csv
PHP
3 votes151 views3 answers
Url in laravel
PHP
8 votes175 views1 answer
Laravel storage not found
PHP Laravel
8 votes158 views2 answers
Laravel storage hard link
PHP