How we can retrive the data in the result set of MYSQL using PHP?

Question

I have moderate level PHP programming skills. I am also interested in merging those skills inside of the WordPress app. With their advanced responsive design themes and many other functions it seems like a good idea. I have tried loading some PHP plug-ins in WP – but I don't seem to get them to do more than basics.

Can anybody help me on how I can get started working with PHP/MySQL inside of the WordPress app?

Answer 1

1 ) mysql_fetch_row() : The mysql_fetch_row() function returns a row from a resultset as a numeric array.
This function gets a row from the mysql_query() function and returns an array on success, or FALSE on failure or when there are no more rows.
mysql_fetch_row() fetches one row of data from the result associated with the specified result identifier.
The row is returned as an array.
Each result column is stored in an array offset, starting at offset 0.

2) mysql_fetch_array(): The mysql_fetch_array() function fetches a result row as an associative array or a numeric array or using both the ways.

3) mysql_fetch_object(): The mysql_fetch_object() function fetches a result row as an object.

4)mysql_fetch_assoc(): The mysql_fetch_assoc() function fetches a result row as an associative array.