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"];

Answer / deepak sakure

difference between MYSQL_NUM AND MYSQL_ASSOC.
MYSQL_NUM returns a numerically indexed array.
MYSQL_ASSOC returns an associative array.

Answer / test

difference between MYSQL_NUM AND MYSQL_ASSOC.
MYSQL_NUM returns a numerically indexed array.
MYSQL_ASSOC returns an associative array.

Where is mysql used?

0 Answers  

---

can you tell what are the different set operations available in mysql? : Mysql dba

0 Answers  

---

How we can create index in mysql?

0 Answers  

---

What are the objects can be created using CREATE statement?

0 Answers  

---

What is the use of mysqli_query?

0 Answers  

---

Is mysql free download?

0 Answers  

---

How to create and drop view in mysql?

0 Answers  

---

What are the features of Stored Procedures in MYSQL?

1 Answers  

---

What is blob datatype in mysql?

0 Answers  

---

Which one of the following is the correct way to select all columns and all rows from "vtable"? Choice 1 SELECT FROM vtable SELF JOIN vtable Choice 2 SELECT ALL COLUMNS FROM vtable WHERE ALL ROWS = * Choice 3 SELECT EVERYTHING FROM vtable Choice 4 SELECT vtable.* WHERE vtable = vtable Choice 5 SELECT * FROM vtable WHERE 1 = 1

3 Answers  

---

What is the usage of regular expressions in mysql?

0 Answers  

---

How do I view data in mysql workbench?

0 Answers  

---