[Resolved] Inserting multiple records with one SQL statement

[Mr_Mako]

Hi...

I'm trying to figure out a way to insert multiple records into a table with a single SQL statment.

Basically what I have is a table with users like so:

user_id || name || email || status

0 || Bob || [e-mail] || active

I want to be able to use a FORM to insert more than one user record into the table at a time.

Is there a variance of the LOOP function I can use for this? Or is it more complex than that?

[LordShryku]

AFAIK, with MySQL, you can comma delimit the values. ie.

INSERT INTO table
  (field1, field2)
VALUES
  ('value1','value2'),
  ('value3','value4'),
  ('value5','value6')

[Mr_Mako]

Thanks... that was it. Worked like a charm. 🙂