Retro video games delivered to your door every month!
Click above to get retro games delivered to your door ever month!
dbx_fetch_row
OuSob Home Page
PrevNext

dbx_fetch_row

(PHP 5 <= 5.0.4)

dbx_fetch_row -- Fetches rows from a query-result that had the DBX_RESULT_UNBUFFERED flag set

Description

mixed dbx_fetch_row ( object result_identifier )

dbx_fetch_row() fetches rows from a result identifier that had the DBX_RESULT_UNBUFFERED flag set.

When the DBX_RESULT_UNBUFFERED is not set in the query, dbx_fetch_row() will fail as all rows have already been fetched into the results data property.

As a side effect, the rows property of the query-result object is incremented for each successful call to dbx_fetch_row().

Parameters

result_identifier

A result set returned by dbx_query().

Return Values

Returns an object on success that contains the same information as any row would have in the dbx_query() result data property, including columns accessible by index or fieldname when the flags for dbx_query() were set that way.

Upon failure, returns 0 (e.g. when no more rows are available).

Examples

Example 1. How to handle the returned value

&#60;?php
$result = dbx_query($link, 'SELECT id, parentid, description FROM table', DBX_RESULT_UNBUFFERED);

echo "&#60;table&#62;\n";
while ($row = dbx_fetch_row($result)) {
    echo "&#60;tr&#62;\n";
    foreach ($row as $field) {
        echo "&#60;td&#62;$field&#60;/td&#62;";
    }
    echo "&#60;/tr&#62;\n";
}
echo "&#60;/table&#62;\n";
?&#62;

See Also

dbx_query()

PrevHomeNext
dbx_escape_stringUpdbx_query