Re: [PHP-DB] Re: Diff between 2 date

the problem is DATEDIFF command available in MySQL ver 4.1.1 above - Original Message - From: "Roby -" <[EMAIL PROTECTED]> To: Sent: Friday, October 06, 2006 10:44 AM Subject: [PHP-DB] Re: Diff between 2 date > Using SQL statement: datediff, example: > SELECT datediff( day, '2006-10-05'

[PHP-DB] Diff between 2 date

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

Re: [PHP-DB] Subquery

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" Sent: Monday, September 19, 2005 9:14 AM Subject: [PHP-DB] Subqu

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

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] Qu

[PHP-DB] Com 1

Hi,. any one to know, how to send ascci file to com1 port from php ?? thx, nandar