Difference between MYSQL_ASSOC,MYSQL_NUM and MYSQL_BOTH ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / deepak sakure
difference between MYSQL_NUM AND MYSQL_ASSOC.
MYSQL_NUM returns a numerically indexed array.
MYSQL_ASSOC returns an associative array.
Is This Answer Correct ? | 20 Yes | 3 No |
Answer / test
difference between MYSQL_NUM AND MYSQL_ASSOC.
MYSQL_NUM returns a numerically indexed array.
MYSQL_ASSOC returns an associative array.
Is This Answer Correct ? | 1 Yes | 0 No |
How do you use auto increment?
Why mysql is so popular?
Explain advantages of InnoDB over MyISAM?
Write a query to retrieve a hundred books starting from 20th.
How can you count the total number of records of any table?
Is mysql distributed?
What is ISAM?
How to load data from a text file into a table?
How can we convert between Unix & MySQL timestamps?
What is root password?
How to get data from mysql in php?
How do I view mysql logs?