Re: Help with query
| From: | Bas Jobsen | Date: | Sat, 09 Feb 2002 12:57:32 +0000 |
| Subject: | Re: Help with query | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-84096@lists.php.net to get a copy of this message | ||
$number=mysql_num_rows(mysql_query("SELECT DISTINCT date FROM $table"));
Op zaterdag 09 februari 2002 13:41, schreef Daniel Alsén:
> Hi,
>
> i can´t seem to get my head to wake up...
>
> How would i do to count how many different values that exists in a mysql
> field? Ie i have a date-field and need to know how many different dates
> that exists in the table.
>
> Regards
> # Daniel Alsén | www.mindbash.com #
> # d@mindbash.com | +46 704 86 14 92 #
> # ICQ: 63006462 | +46 8 694 82 22 #
> # PGP: http://www.mindbash.com/pgp/ #