Re: [PHP] Help with query

2002-02-09 Thread Bas Jobsen

$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 #
> # [EMAIL PROTECTED]  | +46 704 86 14 92 #
> # ICQ: 63006462   | +46 8 694 82 22  #
> # PGP: http://www.mindbash.com/pgp/  #

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP] Help with query

2002-02-09 Thread val petruchek

> 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.

select count(distinct name) from site; in Mysql

Valentin Petruchek (aki Zliy Pes)
*** Cut the beginning ***
http://zliypes.com.ua
mailto:[EMAIL PROTECTED]






-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php