Re: mysql_num_rows()

I tried your script locally. Its working for me. On Tue, Feb 22, 2011 at 11:10 AM, Gary <gpaul@paulgdesigns.com> wrote: > Can someone tell me why this is not working? I do not get an error > message, > the results are called and echo'd to screen, the count does not work, I get > a 0 for a result... > > > > $result = mysql_query("SELECT * FROM counties WHERE name = > 'checked'") or > die(mysql_error()); > > if ( isset($_POST['submit']) ) { > for($i=1; $i<=$_POST['counties']; $i++) { > if ( isset($_POST["county$i"] ) ) { > echo "You have chosen ". $_POST["county$i"]." <br/>"; > } > } > } > > $county_total=mysql_num_rows($result); > > while($row = mysql_fetch_array($result)) > {$i++; > echo $row['name']; > } > $county_total=mysql_num_rows($result); > echo "$county_total"; > > echo 'You Have ' . "$county_total" . ' Counties '; > > ?> > -- > Gary > > > > __________ Information from ESET Smart Security, version of virus signature > database 5894 (20110221) __________ > > The message was checked by ESET Smart Security. > > http://www.eset.com > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- :DJ