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 to concatenate two character strings?
How do I drop a database in mysql?
How is data stored in mysql?
What is mysql used for?
What is definer in mysql?
What is blob storage?
What is memory table in mysql?
In the below example, how many String Objects are created? String s1="I am Java Expert"; String s2="I am C Expert"; String s3="I am Java Expert";
What mysql -u john -p command does?
how we can use more then one primary key in Single Table
How to use count function in mysql?
Explain the difference between mysql and mysqli interfaces in PHP?