---------- Forwarded message ---------- From: Chenri <[EMAIL PROTECTED]> Date: Mon, 24 Jan 2005 08:22:01 +0700 Subject: To: mysql@lists.mysql.com
i have a price table no date price limit 01 1/1/05 5000 100 02 1/2/05 5010 100 03 1/3/05 5020 60 in order to input a record the price must be checked with the previous date price and limit if the price entry is consecutive every day and can use date-1 but the problem is when i want to enter a price 3 days after, like this record: no date price limit 04 1/6/05 5010 100 so it will be like this no date price limit 01 1/1/05 5000 100 02 1/2/05 5010 100 03 1/3/05 5020 60 ** 04 1/6/05 5010 100 ** there are 3 days difference but how do make a query to check for record no 04 with 03 how do i retrieved the 1/3/05 date and the price i only ha -- Chenri J Taman Palem Lestari B18 - 19A (021) 926 68651 - Esia jadi bisa SMS -- Chenri J Taman Palem Lestari B18 - 19A (021) 926 68651 - Esia jadi bisa SMS -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
