try this
SELECT client_name, COUNT(sale.client_id) as total
FROM client, sale
WHERE client.client_id *= sale.client_id
GROUP BY client_name
ORDER BY total DESC
nandar
- Original Message -
From: <[EMAIL PROTECTED]>
To:
Sent: Wednesday, July 06, 2005 1:11 PM
Subject: [PHP-DB] Question abo
[EMAIL PROTECTED] wrote:
> Hi,
>
> Let's say that I have 2 tables: client and sales
> ---
> | client_id | client_name |
> ---
> | 1 | John|
> | 2 | Mark|
> | 3 | Luke|
> | 4 | Matthew |
> --
Brad Webb wrote:
> I'm a big fan of Eclipse + PHP|Eclipse.
>
> Bastien Koert wrote:
>
>> Zend is pretty close to what you want
>>
I use Zend - IMHO the debugger makes it worth the price tag. Also if you
take the year's support, you get upgrades for free during the
subscription period - which is
Virus warning from BT Business
This message contained a computer virus which has been detected and deleted by
the BT Business Email Virus Filter to avoid infecting your computer.
You may wish to contact the sender of this email requesting they remove any
virus infection from their PC before
Hi,
I can connect and query the MSSQL database successfully using PHP 4.1,
but the function 'mssql_error()' aparently locks!.
Any help, please?
Denio Mariz
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
The original message was received at Wed, 6 Jul 2005 21:14:54 +0200
from [192.68.208.157]
- The following addresses had permanent fatal errors -
php-db@lists.php.net
- Transcript of session follows -
... while talking to 183.35.144.64:
>>> DATA
<<< 400-aturner; -SYSTEM-F-EXDISKQUO
I'd love to try eclipse but I've heard its really difficult just to
install and a bit difficult to get the hang of as well. Did you have any
problems getting started with it? Do you use it on a windows platform?
Incidently, yesterday I downloaded a new editor 'PHP Designer 2005' from
www.mpsof
Download, unzip, run :) The 3.0 line runs and installs much nicer than
previous versions... it has some really nice PHP-specific stuff that
PHP|Eclipse adds.. only bug that I've found with it, is that it hates
(i.e. doesn't work with AT ALL) Interfaces, which is kind of a pain and
makes for sli