help with while

[sabret00the]

PHP Code:

             while ($project_info = $DB_site->fetch_array($projects))
                  {
                  $project_info['text'] = nl2br(stripslashes($project_info['text']));
                     extract($project_info);
                  $time_posted = vbdate('n-j-y, g:i:s a', $timestamp);
  //where it started going wrong
                  $number_of_votes = $DB_site->query_first("SELECT COUNT(*) 
                     FROM project_rate
                  WHERE projectid = $project_info[projectid]
                      ");
                  $num_votes = number_format($DB_site->num_rows($number_of_votes)); 


can someone tell me what i'm doing wrong please? :nervous:

i'm now getting this error

 Warning:  mysql_num_rows(): supplied argument is not a valid MySQL result resource in K:\Network\xampp\htdocs\forums\includes\db_mysql.php on line 311

i never touched that file btw it went ok untill i started trying to extract data from the second table.

'project_rate' as the project_info extracts data from 'projects'