In how many ways we can retrieve the date in the result set
of mysql using PHP?
Answer Posted / 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 View All Answers
Tell me what is needed to be able to use image function?
What is the use of array_count_values() in php?
Why php is used?
Is php object oriented?
Explain the importance of the function htmlentities.
What is scope of variable in php?
What are the 5 types of data?
How to read the entire file into a single string?
What are the different ways to login to a remote server? Explain the me, advantages and disadvantages?
Do you know what are traits?
How to track user logged out or not? When user is idle?
What is difference between include and include_once in php?
What is an array in php?
How would you determine the size of a file in php?
What is the difference between get & post ?