Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resourc

[i4VisualMedia]

Hi guys,
Im quite new to working with PHP and mySQL and am still learning the ropes.
I am getting the following error:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/i4visua/public_html/cmsadmin/editmembers.php on line 84

from this code:
82    $query = "SELECT * FROM 'members'";
83    $result = mysql_query($query);
84    $num_results = mysql_num_rows($result);
85   
86    for ($i=0; $i <$num_results; $i++)
87    {
88    $row = mysql_fetch_array($result);
89    echo '<br /> ';
90    echo stripslashed($row['company']);
91    } 

can anybody help?

cheers
Pete

[Zane]

use backticks instead of quotes for column names or tables
the backtick is to the left of the 1 key

SELECT * FROM `members`