what is a mysql resource exactly

[dazzyweb]

What exactly is a mysql Resource?

What is meant by a mysql resource

This is a quote from tizag

'When you perform a SELECT query on the database it will return a MySQL Resource that holds everything from your MySQL table, "example". We want to use this Resource in our PHP code, so we need to store it in a variable, $result.'

'$result = mysql_query("SELECT * FROM example")'

'$row = mysql_fetch_array( $result );'

Does exactly is the difference between $result and $row

Are they both holding a MySQL resource

I am a little confused

[johnj]

http://www.php.net/manual/en/language.t ... source.php

[johnmacd]

The value that mysql_query returns and stores into $result, it is a MySQL Resource.
Additional PHP functions are required to extract the data from this Resource.
The mysql_fetch_array function takes a MySQL query resource as an argument ($result) and returns the first row of data returned by the mysql_query.