PHP Count

Seachmall

I'm trying to count how many rows I have in a table that have similar likes. This is my script:
[PHP]$getdays = mysql_query("SELECT day FROM archive WHERE day='$_POST[day]'");
$dayarr = mysql_fetch_array($getdays);
$totalday = count($dayarr);
echo $totalday;[/PHP]
The echo isn't giving me the correct number.

e.g. I have 4 rows where the days are the same and I being told there are 2?!

Is my script A-wall?

Thanks,
S.

nude_hamster

Seachmall wrote:

I'm trying to count how many rows I have in a table that have similar likes. This is my script:
[PHP]$getdays = mysql_query("SELECT day FROM archive WHERE day='$_POST[day]'");
$dayarr = mysql_fetch_array($getdays);
$totalday = count($dayarr);
echo $totalday;[/PHP]
The echo isn't giving me the correct number.

e.g. I have 4 rows where the days are the same and I being told there are 2?!

Is my script A-wall?

Thanks,
S.

I know this is kinda obvious question but...
Have you tested that SQL statement, maybe the query is incorrect?

seamus

mysql_fetch_array() returns a single row from the result, not the entire result. In this case, the count() function returning 2 is completely correct.

There are a number of things you can do for this, but my personal favourite is mysql_affected_rows()

This function will return the number of rows returned/changed/deleted in the last query.

egan007

or...

$totalday=mysql_num_rows($getdays)

danbhala

or...

$totalday=sizeof($getdays)

seamus

sizeof() won't work. It's just an alias for count().

Seachmall

So what do I use to count the number of unaffected rows? I'm trying to count all the rows in the table before I change them. Will mysql_affected_rows work for this?

Thanks,
S.

Seth Brundle

Can you not use COUNT() in your SQL?

Seachmall

kbannon wrote:

Can you not use COUNT() in your SQL?

as in COUNT * FROM etc..?

Thats doesn't appear to be working but I've a feeling I'm doing it wrong. I'm kinda of embarrassed I forgot the COUNT command but ya live, ya learn etc.:D

Anyway, Thanks,
S.

Seth Brundle

http://www.tizag.com/mysqlTutorial/mysqlcount.php

Seachmall

So this is what I have now but it still outputs 2
[PHP]$getdays = mysql_query("SELECT day FROM archive WHERE day='$_POST[day]'");
$dayarr = mysql_fetch_array($getdays);
print count($dayarr);[/PHP]

Can somebody give me the script they know works so I can see if I'm anywhere near. I've been stuck on this part for weeks and I'm so close to finishing my program. Please, I need help.:(
Thanks,
S.

seamus

That's exactly the same script as you posted in the first place

One way of doing it:
[php]
$getdays = mysql_query("SELECT day FROM archive WHERE day='$_POST[day]'");
print mysql_affected_rows();
[/php]

Seachmall

seamus wrote:

That's exactly the same script as you posted in the first place

I've been trying everything (except the right one) and retrying them. Sorry for the repost.

seamus wrote:

One way of doing it:
[php]
$getdays = mysql_query("SELECT day FROM archive WHERE day='$_POST[day]'");
print mysql_affected_rows();
[/php]

Thats it!:) I havent heard of that command before but I searched it up and it looks like it could definetly come in handy in the future.
Thanks,
S.