Re: Error in Query
| From: | J-E-N | Date: | Mon, 08 Oct 2001 06:30:05 +0000 |
| Subject: | Re: Error in Query | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-13098@lists.php.net to get a copy of this message | ||
i also tried but still didn't work =(
select customerid as i, count(customerid) as j from tbltransaction group by
customerid order by j;
----- Original Message -----
From: Beau Lebens <B.Lebens@curtin.edu.au>
To: 'J-E-N' <eper@tridel.net>; <php-db@lists.php.net>
Sent: Monday, October 08, 2001 2:18 PM
Subject: RE: [PHP-DB] Error in Query
> i have a feeling you have to "ORDER BY j"
>
> // -----Original Message-----
> // From: J-E-N [mailto:eper@tridel.net]
> // Sent: Monday, 8 October 2001 2:23 PM
> // To: php-db@lists.php.net
> // Subject: [PHP-DB] Error in Query
> //
> //
> // my query below does not work in interbase, is there any work
> // around for
> // this?
> //
> // select customerid as i, count(customerid) as j from
> // tbltransaction order by
> // count(customerid) group by customerid;
> //
> //
> // --
> // PHP Database Mailing List (http://www.php.net/)
> // To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> // For additional commands, e-mail: php-db-help@lists.php.net
> // To contact the list administrators, e-mail:
> // php-list-admin@lists.php.net
> //
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net