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 to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.

1179

---

Is mysql a distributed database?

1029

---

What is full form of xampp?

1233

---

How do I edit a table in mysql workbench?

894

---

What is delimiter in mysql trigger?

995

---

What is blob datatype in mysql?

986

---

What is delimiter $$?

1021

---

How to use regular expression in pattern match conditions?

1019

---

Is mysql easy to learn?

981

---

Which is better mysql or mssql?

981

---

What are the functions of commit and rollback statements?

1103

---

What is timestamp in mysql?

1047

---

How do I copy a table in mysql?

989

---

Is mongodb faster than mysql?

996

---

Can foreign key have duplicate values?

941

---