Insert into

[reportingsjr]

WTF, Im using PHP myadmin which uses mysql 4.1.9 and this wont work!! can someone pleaaassse help me. I dont know why it wont work. When I do just one row at a time it works perfectly, but not when I do two or more.The mysql query is:

INSERT INTO lvls (minexp, maxexp)VALUES ('0', '124')VALUES ('125', '215');

and the table looks like this:Field|Type|otherslevel | int(255) | NOT NULL,auto_increment, primary keyminexp | int(255) | NULLmaxexp | int(255) | NULLThis is supposed to contain all the minimum and maximum level experiences. I already have like 300 of the levels done and this is for a calculator. Can someone please tell me why this wont work?

[aspnetguy]

I don't think that is hte correct syntax, You could write multiple insert statements in a stored procedure then execute the stored procedure when you want to insert multiple records.