Page 1 of 1

what's the most efficient way??

Posted: Tue Nov 25, 2003 1:04 pm
by lisawebs
I'd appreciate your comments on this:

Have a table where key is date, and containing #peoplea
I get all the records and put them in an array(date and #people)

The user can only:
change #people
or create new entries to the array (date and # people)

When accepting the page, the process must
a) update all existing records (matching dates in the array)
with the new #people value
b) create records that don't exist (new entries in the array)

Well, basically I should divide existing data than new entries,
and issue 2 sql statements (for update and for create)

Question:
Since the #people for each record is different,
I wonder if I could pass in the sql statement
an entire array with the record key (date) and the #people

thanks