Difference between MYSQL_ASSOC,MYSQL_NUM and MYSQL_BOTH ?
Answer Posted / avanthi g
Fetch a result row as an associative array, a numeric array, or both
Returns an array that corresponds to the fetched row and moves the internal data pointer ahead.
Example:
MYSQL_NUM returns a numerically indexed array.
$row = mysql_fetch_array($result, MYSQL_NUM);
echo $row[0];
MYSQL_ASSOC returns an associative array.
$row = mysql_fetch_array($result, MYSQL_ASSOC);
echo $row["student_id"];
MYSQL_BOTH returns both.
$row = mysql_fetch_array($result, MYSQL_BOTH)
echo $row[0]." ".$row["name"];
| Is This Answer Correct ? | 46 Yes | 4 No |
Post New Answer View All Answers
What is 'mysqlimport'?
How do I install mysql on windows 10?
How to use case expression?
What is meant by decimal (5,2)?
How to use triggers to track changes in mysql?
What are the advantages of MySQL when compared with Oracle?
What is offset limit?
Is mysql a server or database?
How to filter data from a mysql database table with php?
table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases
What is the full meaning of mysql?
What is mysql enterprise edition?
What is the hostname for mysql database?
what is database black box testing? : Mysql dba
How do I find mysql database?