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'

[Xenon]

erm, you are running num_rows on a normal array (query_first's result is always an array, not a mysql result resource.

so the correcter version is:

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(*) AS votes
                    FROM project_rate
                 WHERE projectid = $project_info[projectid]
                      ");
                 $num_votes = number_format($number_of_votes['votes']); 


but stillt a query within a while loop, is not good

[sabret00the]

thanks xenon

i just tested this in phpmyadmin and it works fine, however in the project_bit template

<table class="tborder" cellpadding="5" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
  <tr> 
    <td class="tcat">
		project <a href="index.php?projectid=$projectid" class="projectid">$projectid</a> by confess[username]
    </td>
  </tr>
  <tr>
    <td valign="top" class="alt1">
		$text
	</td>
  </tr>
  <tr> 
    <td class="thead" align="right">
		<smallfont><strong>$report $adminoptions $num_rates votes</strong></smallfont>
	</td>
  </tr>
</table>

it refuses to echo out.

[NTLDR]

Because you have $num_rates and not $num_votes in the template?

[sabret00the]

ahhhhhh, how stupid am i, i'm so so so so so sorry to waste your time

[high]* sabret00the is might ashamed and embarrassed
[/high]

sorry

[NTLDR]

We've all done it, many a time