Mysqli: Select

<?php

$sql = 'select field1, field2 from my_table';

$query = $mysqli->query($sql) or die($mysqli->error);

$row = $query->fetch_object();

$row = $query->fetch_assoc();

$row = $query->fetch_array();

$row = $query->fetch_array(MYSQLI_NUM);

$row = $query->fetch_array(MYSQLI_ASSOC);

$row = $query->fetch_array(MYSQLI_BOTH);

$query->free();

?>

 

Related Snippets

•	Mysqli: Update from array
•	Mysqli: Update
•	Mysqli: Insert from array