Re: mysql_num_rows

Hi John, "John Taylor-Johnston" wrote in message: > I use $mycounter, not saying it is pretty. But if you have a whole bunch of stuff deleted, your last id might be worth a lot more than the actual number of rows. > > $myconnection = mysql_connect($server,$user,$pass); > mysql_select_db($db,$myconnection); > > $news = mysql_query('select * from '.$table.' where '.$where.' order > by id asc'); > $mycounter = 0; > while ($mydata = mysql_fetch_object($news)) > { > $mycounter++; > } Have you ever considered just doing a count()? $count = @mysql_query("select count(*) from [table(s)] where [criteria [group by something]]"); $total = mysql_result($count, 0); That will return the number of rows in your table(s). It's also much quicker and less resource intensive, particularly with large datasets. :) James