Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

Difference between MYSQL_ASSOC,MYSQL_NUM and MYSQL_BOTH ?

Question Posted / ram

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

How to filter data from a mysql database table with php?

0 Answers  

can you tell how can you display the maximum salary in sql? : Mysql dba

0 Answers  

How to show table names with 'mysqlshow'?

0 Answers  

what is constraints? Also explain the different types of constraints?

0 Answers  

How to do login in mysql with unix shell.

0 Answers  

Can you tell the difference between mysql_connect and mysql_pconnect? : Mysql dba

0 Answers  

I want to start and stop mysql on windows? How do I do that?

0 Answers  

What data type is money?

0 Answers  

can you tell the order of sql select statement? : Mysql dba

0 Answers  

How much does mysql enterprise cost?

0 Answers  

What is the difference between myisam dynamic and myisam static in mysql?

0 Answers  

How do I restore a mysql database?

0 Answers  

For more MySQL Interview Questions Click Here
Categories