Get a result row as an enumerated array (original) (raw)

`<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}$query = "SELECT Name, CountryCode FROM City ORDER by ID DESC LIMIT 50,5";

if ( result=mysqliquery(result = mysqli_query(result=mysqliq​uery(link, $query)) {/* fetch associative array /
while ($row = mysqli_fetch_row($result)) {
printf ("%s (%s)\n", row[0],row[0], row[0],row[1]);
}/ free result set /
mysqli_free_result($result);
}/ close connection */
mysqli_close($link);
?> `

Pueblo (USA) Arvada (USA) Cape Coral (USA) Green Bay (USA) Santa Clara (USA)