In how many ways we can retrieve the date in the result set of mysql using PHP?

Categories >> Software >> Programming Languages >> PHP Related >> PHP
Suggest New Category

In how many ways we can retrieve the date in the result set
of mysql using PHP?

Question Posted / phpwizz

5 Answers
18852 Views
Yahoo, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

In how many ways we can retrieve the date in the result set of mysql using PHP?..

Answer / vasan.

4 ways

1. mysql_fetch_rows
2. mysql_fetch_object
3. mysql_fetch_assoc
4. mysql_fetch_array

Is This Answer Correct ?

57 Yes

4 No

In how many ways we can retrieve the date in the result set of mysql using PHP?..

Answer / bijay.behera9911033016@orissa

1. mysqli_fetch_rows
2. mysqli_fetch_object
3. mysqli_fetch_assoc
4. mysqli_fetch_array

Is This Answer Correct ?

22 Yes

4 No

In how many ways we can retrieve the date in the result set of mysql using PHP?..

Answer / naresh

first n second both are right

Is This Answer Correct ?

12 Yes

0 No

In how many ways we can retrieve the date in the result set of mysql using PHP?..

Answer / ankish kumar

What is the difference between all these 4 versions:
1. mysqli_fetch_rows
2. mysqli_fetch_object
3. mysqli_fetch_assoc
4. mysqli_fetch_array

Is This Answer Correct ?

9 Yes

1 No

In how many ways we can retrieve the date in the result set of mysql using PHP?..

Answer / binoyav

1) mysql_result: returns the value of a field in a recordset.
Note: This function is slower than mysql_fetch_row(), mysql_fetch_array(), mysql_fetch_assoc() and mysql_fetch_object()
2) mysql_fetch_array(): function returns a row from a recordset as an associative array and/or a numeric array. Note: Its a misconception that, this function will return all rows. Its completely wrong, it will return only a single row at a time as like mysql_fetch_row
3) mysql_fetch_row(): returns a row from a recordset as a numeric array
4) mysql_fetch_assoc(): returns a row from a recordset as an associative array. No numerical indices available for this
5) mysql_fetch_object(): returns a row from a recordset as an object

Is This Answer Correct ?

2 Yes

2 No

Post New Answer