"Pete Ford" <[email protected]> wrote in message
news:[email protected]...
> On 22/02/11 05:40, Gary 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 ';
>>
>> ?>
>
> The first thing I see is that you do
> $county_total=mysql_num_rows($result)
> twice. Now I'm not to sure, but it is possible that looping over
> mysql_fetch_array($result) moves an array pointer so the count is not
> valid after the operation... that's a long shot.
>
> But since you are looping over the database records anyway, why not just
> count them as you go? Isn't $i the number of counties after all the
> looping?
>
>
> --
> Peter Ford, Developer phone: 01580 893333 fax: 01580
> 893399
> Justcroft International Ltd.
> www.justcroft.com
> Justcroft House, High Street, Staplehurst, Kent TN12 0AH United
> Kingdom
> Registered in England and Wales: 2297906
> Registered office: Stag Gates House, 63/64 The Avenue, Southampton SO17
> 1XS
Peter
Thank you for your reply.
I did notice that I had the $county_total=mysql_num_rows($result) twice. I
had moved and removed it, always getting either a 0 or 1 result.
I put up another test page with
$result = mysql_query("SELECT * FROM `counties` ") or die(mysql_error());
$tot=mysql_num_rows($result);
echo "$tot";
?>
And it worked fine.
I have tried count() as well as mysql_num_rows() but am getting the same
result.
Could you explain what you mean by count them as I go?
Again, Thank you for your reply.
Gary
__________ Information from ESET Smart Security, version of virus signature
database 5895 (20110222) __________
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
