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
You actually want the
Jigal van Hemert [EMAIL PROTECTED] wrote on 01/24/2005 03:10:40 AM:
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
-- 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