Difference between MYSQL_ASSOC,MYSQL_NUM and MYSQL

Difference between MYSQL_ASSOC,MYSQL_NUM and MYSQL_BOTH ?

Question Posted / ram

3 Answers
22160 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Difference between MYSQL_ASSOC,MYSQL_NUM and MYSQL_BOTH ?..

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

Difference between MYSQL_ASSOC,MYSQL_NUM and MYSQL_BOTH ?..

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

Difference between MYSQL_ASSOC,MYSQL_NUM and MYSQL_BOTH ?..

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

Post New Answer

More MySQL Interview Questions

What is max connections in mysql?

0 Answers

How set mysql root password?

0 Answers

What is the difference between SQL and SQL Server?

3 Answers Cognizant, HCL,

Why mysql is open source?

0 Answers

The table tbl_sites contains the following data: ----------------------------------------------------- Userid sitename country ------------------------------------------------------ 1 sureshbabu indian 2 PHPprogrammer andhra 3 PHP.net usa 4 PHPtalk.com germany 5 MySQL.com usa 6 sureshbabu canada 7 PHPbuddy.com pakistan 8. PHPtalk.com austria 9. PHPfreaks.com sourthafrica 10. PHPsupport.net russia 11. sureshbabu australia 12. sureshbabu nepal 13. PHPtalk.com italy Write a select query that will displayed the duplicated site name and how many times it is duplicated?

4 Answers Afixi, GE,

Write a command to list all databases in mysql?

0 Answers

how to take mysql database structure backup

6 Answers

How can a user get the current SQL version?

2 Answers

How to create a new table in mysql?

0 Answers

What is difference between group by and order by clause?

0 Answers

How do I disconnect mysql workbench?

0 Answers

Why we use mysql database?

0 Answers

For more MySQL Interview Questions Click Here