Answer Posted / 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"];

How do I create a mysql database?

858

---

What is difference between schema and table?

865

---

What is unsigned in mysql?

867

---

What are the different tables present in MySQL?

1046

---

How is mysql database stored?

1008

---

What does it mean to be case sensitive?

929

---

Is mysqli secure?

834

---

How can you count the total number of records of any table?

875

---

What are the steps required to view your mysql database?

1034

---

Why mysql is used with php?

919

---

How do you determine the location of mysql data directory?

884

---

How to store values to array from mysql database in php?

875

---

Which is faster innodb or myisam?

920

---

What is the datatype of image in mysql?

868

---

How to determine the location of the data directory?

904

---