mysql_num_rows inside of while

[darkecho]

ive been trying this for a while and still cannot get it to work. I am trying to put $rows = mysql_num_rows($sql) inside a while loop...

Basically
$num_rows = array();
$query = mysql_query("select * from sometable");
while ($results = mysql_fetch_array($query)) {
$sql = mysql_query("select * from somefield where somefield1 = somefield_query");
$rows = mysql_num_rows($sql);
$num_rows[] = $rows;
}
now when i do print_r($num_rows); the array is empty... so any help on getting this to work would be muchly appreciated

[Mitch]

Try defining an integer variable ($x = 0; )

use a loop, foreach() i think or something,

$num_rows[$x] = $rows;

[NedreN]

 $num_rows = array();
$results = mysql_query("SELECT * FROM `blah`");
 
   while ($row = mysql_fetch_array($results)) {
      $nrRes = mysql_query("SELECT * FROM `blah` WHERE `blah` = '$blah'");
      $totalRows = mysql_num_rows($nrRes);
      $num_rows[] = $totalRows;
   } 
  

I don't see why that wouldn't work... I haven't tested it, but I really don't see why it wouldn't.

[cached]

Print the queries and then try some of them just to make sure its not the query thats bad because I see nothing wrong.

[darkecho]

thanks guys.. i figured it out.. i left somethin out now it works great. thnx guys..

[Atolar]

for reference for other coders, you can't count rows if what you're searching isn't an array.


hense you need:

 $asdf = mysql_query("select * from *");
$asdf2 = mysql_fetch_array($asdf);
$asdf3 = mysql_num_rows($asdf2);
$asdf4 = mysql_num_rows($asdf); // WILL NOT WORK 
  

[Mau]

Sorry, but I do this ALL the time with no problems what so ever:

 $result = mysql_query("
SELECT name
FROM users
");
print mysql_num_rows($result); 
  

[darkecho]

i agree with Mau, I do stuff like that all the time, especially with the forum I am making.

[niallj]

Me too- either that or 'SELECT COUNT(`whatever`) FROM ...'

[php]

hmm i think its best to use Maus solution..