Re: mysql_num_rows()

On Tuesday 22 February 2011, "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... Are you sure that the table is called counties and not countries? :) > > > > $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 '; > > ?> Best regards, -- Daniel Molina Wegener <dmw [at] coder [dot] cl> System Programmer & Web Developer Phone: +56 (2) 979-0277 | Blog: http://coder.cl/