:: Σαν Σήμερα
1939:
Ιδρύεται η Εθνική Ακαδημία Σωματικής Αγωγής

1959:
Αναχωρεί από τον Πειραιά για την Κορέα το ελληνικό εκστρατευτικό σώμα, προκειμένου να ενταχθεί στις δυνάμεις του ΟΗΕ, που προσπαθούν να αποτρέψουν την κατάληψη της Ν. Κορέας από τα βορειοκορεατικά και τα κινεζικά στρατεύματα

1993:
Ο Κληρίδης και ο Παπανδρέου αποφασίζουν στην Αθήνα για τη δημιουργία του δόγματος του ενιαίου αμυντικού χώρου Ελλάδας και Κύπρου.










mysqli_fetch_row

mysqli_fetch_row

(PHP 5)

mysqli_fetch_row

(no version information, might be only in CVS)

result->fetch_row -- Get a result row as an enumerated array

Description

Procedural style:

mixed mysqli_fetch_row ( mysqli_result result )

Object oriented style (method):

class mysqli_result {

mixed fetch_row ( void )

}

Returns an array that corresponds to the fetched row, or NULL if there are no more rows.

mysqli_fetch_row() fetches one row of data from the result set represented by result and returns it as an enumerated array, where each column is stored in an array offset starting from 0 (zero). Each subsequent call to the mysqli_fetch_row() function will return the next row within the result set, or FALSE if there are no more rows.

Return Values

mysqli_fetch_row() returns an array that corresponds to the fetched row or NULL if there are no more rows in result set.

Note: This function sets NULL fields to PHP NULL value.

Examples

Example 1. Object oriented style

<?php
$mysqli
= new mysqli("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 = $mysqli->query($query)) {

    
/* fetch object array */
    
while ($row = $result->fetch_row()) {
        
printf ("%s (%s)\n", $row[0], $row[1]);
    }

    
/* free result set */
    
$result->close();
}

/* close connection */
$mysqli->close();
?>

Example 2. Procedural style

<?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 = mysqli_query($link, $query)) {

    
/* fetch associative array */
    
while ($row = mysqli_fetch_row($result)) {
        
printf ("%s (%s)\n", $row[0], $row[1]);
    }

    
/* free result set */
    
mysqli_free_result($result);
}

/* close connection */
mysqli_close($link);
?>

The above example will output:

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