[PHP-DB] Com 1

2005-06-13 Thread Nandar
Hi,. any one to know, how to send ascci file to com1 port from php ?? thx, nandar

Re: [PHP-DB] Question about COUNT(*)

2005-07-06 Thread Nandar
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: php-db@lists.php.net Sent: Wednesday, July 06, 2005 1:11 PM Subject

Re: [PHP-DB] Subquery

2005-09-18 Thread Nandar
i hope it's helping sql code: UPDATE T020Employee SET T020FaxNo = T010FaxNo FROM T020Employee a JOIN T010Company b ON a.T020CoCd =b.T010CoCd - Original Message - From: Ng Hwee Hwee [EMAIL PROTECTED] To: PHP DB List php-db@lists.php.net Sent: Monday, September 19, 2005 9:14 AM Subject:

[PHP-DB] Diff between 2 date

2006-10-05 Thread Nandar
How to know diff between 2 date ? tgl1 = 2006-10-05 tgl2 = 2006-10-06 result = 1 day nandar -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php