Answers for "select randomly from mysqli php"

PHP

0

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>";
	}
?>

Posted by: Guest on January-25-2022

Source

Code answers related to "select randomly from mysqli php"

Code answers related to "PHP"

PHP Answers by Framework

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#