On Tuesday 22 February 2011,
"Gary" <[email protected]> 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/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
