Re: [PHP] delete duplicates from array and insert statement

Ryan A wrote: want i want to do is, do a select and get the data that is already in the db, compare it, and if its in the insert statement delete those rows... am getting screwed up in the logic for this...so far I have exploaded the insert statement so its in a neat array, now i need to check in

[PHP] delete duplicates from array and insert statement

Hi, I have a movie database with this structure: flick_name text part_url text part_size varchar(50) time_length varchar(50) part_format varchar(10) and my select statement is something like this: insert into table values ("abba",http://...abba1.wmv,"3 mb","3 mins",".wmv"),("