![]() For aliased columns, you cannot access the contents with the original column name.Įxample #1 Query with aliased duplicate field names Must use the numeric index of the column or make an alias for the column. ![]() To access the other column(s) of the same name, you ![]() If two or more columns of the result have the same field names, the last column will take precedence. Indices (as mysql_fetch_assoc() works), using MYSQL_NUM, you only get number indices (as mysql_fetch_row() works). Using MYSQL_ASSOC, you only get associative By using MYSQL_BOTH (default), you'll get an array with both associative and number indices. The type of returned array depends on how result_type is defined. Returns an array of strings that corresponds to the fetched row, or false if there are no more rows. It's a constant and can take the following values: MYSQL_ASSOC, MYSQL_NUM, and This result comes from a call to mysql_query(). The result resource that is being evaluated. Mysql_fetch_array( resource $result, int $result_type = MYSQL_BOTH): array Mysql_fetch_array - Fetch a result row as an associative array, a numeric array, or both How do you check if SQL result is empty in PHP?.
0 Comments
Leave a Reply. |