I have a table named listings. In it, there are n rows.
I need the ‘id’ for each row to randomly update with a unique number between 1 & n.
I have n ($count) as follows, but not sure what to do next.
$sql = "SELECT COUNT(*) FROM listings"; $result = mysqli_query($conn, $sql); $count = mysqli_fetch_assoc($result)['COUNT(*)'];