RE: Insert data if not duplicate based on order

2004-06-21 Thread John McCaskey
eries hitting this table. Maybe someone else has a better solution. John A. McCaskey -Original Message- From: Grant Giddens [mailto:[EMAIL PROTECTED] Sent: Monday, June 21, 2004 4:59 PM To: [EMAIL PROTECTED] Subject: Insert data if not duplicate based on order Hi, I have a table that has

Insert data if not duplicate based on order

2004-06-21 Thread Grant Giddens
Hi, I have a table that has many rows. I want to be able to insert a new row only if has a unique field of the last 20 rows when I sort them by date. Currently before I insert a new row, I will select a specific field for 20 rows and run a for loop in php looking for a match with the data I'm