Returns a numerical array that corresponds to the fetched row and moves the internal data pointer ahead.
dbarraynum
Docs
PHPFusion Development
Core Functions verify_image uncompressIPv6 trimlink theme_exists stripslash stripinput stripget showdate set_admin_pass redirect profile_link preg_check phpentities parseubb parsesmileys parsebytesize make_captcha makepagenav makefileopts makefilelist isnum highlight_words hide_email groupaccess getuserlevel getusergroups getgroupname formatcode displaysmileys descript dbrows dbresult dbquery dbcount dbconnect dbarraynum dbarray cleanurl check_captcha check_admin_pass checkrights checkgroup censorwords cache_smileys cache_groups cache_bbcode addslashTheme FunctionsOther FunctionsMail FunctionsComments and RatingsPhoto Gallery FunctionsInfusions FunctionsOutput HandlingForum FunctionsBBCodesCustom includesJavascript Functionsdbarraynum
Quote
dbarraynum ( resource $query )
Parameters
query
The result resource that is being evaluated. This result comes from a call to dbquery().
Return Values
Returns an numerical array of strings that corresponds to the fetched row, or FALSE if there are no more rows.
dbarraynum() fetches one row of data from the result associated with the specified result identifier.
The row is returned as an array.
Each result column is stored in an array offset, starting at offset 0.
Example
Code
<?php
$result = dbquery("SELECT id, email FROM people WHERE id='42'");
if (dbrows($result)) {
$data = dbarraynum($result);
echo $data[0]; // 42
echo $data[1]; // the email value
} else {
echo "No data in table.";
}
?>