i have a list of transaction id's in an array in PHP. i want to see if these transaction id's are in a mysql table field. if they aren't, i want to create new rows in this table with the new trans_id's.
anyone have any idea how i can do this? i'm stumped.