HELP. Multi-Record Insert

[Fuzzy.wonderdog]

Hello,

I hope some one can help me, at least give me a little direction.

I have the need to insert many records into the same table at once.
Not very many data points (<5), but many (30+) records. Not being a
PHP guru, I am at a loss as where to start. Really I am a PHP
neophyte. Though I am a quick study and REALLY need to know how to do
this.

Please Help!

Thanks!

[J.O. Aho]

Fu*************@gmail.com wrote:

Hello,

I hope some one can help me, at least give me a little direction.

I have the need to insert many records into the same table at once.
Not very many data points (<5), but many (30+) records. Not being a
PHP guru, I am at a loss as where to start. Really I am a PHP
neophyte. Though I am a quick study and REALLY need to know how to do
this.

Make one insert for each SQL line you want to insert, this way you can track
what went wrong if something would go wrong.

Of course you can use the ; to make a really long SQL statement, but you will
_NOT_ be able to find out what went wrong if something goes wrong.
INSERT INTO table(user,age) VALUE('tom','10'); INSERT INTO table(user,age)
VALUE('ann','11')

If you do not know how to use sql from PHP, then you should take a look at the
following page (assuming you are using mysql):
http://www.php.net/manual/en/ref.mysql.php
//Aho

[Jim Michaels]

INSERT INTO `graph_apps` (`app_id`,`name`) VALUES

(1,'cities'),

(2,'statemachine'),

(3,'molecules'),

(4,'prj_mgmt');

One insert statement. Use commas. As I saw in a previous post, there is a
30-second limit probably imposd on the server, and a 1MB query limit also
probably imposed on the server. If its your own box, you can probably tweak
that out.

<Fu*************@gmail.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...

Hello,

I hope some one can help me, at least give me a little direction.

I have the need to insert many records into the same table at once.
Not very many data points (<5), but many (30+) records. Not being a
PHP guru, I am at a loss as where to start. Really I am a PHP
neophyte. Though I am a quick study and REALLY need to know how to do
this.

Please Help!

Thanks!

[Dikkie Dik]

The php timeout can be set with set_time_limit if the server is not
running in secure mode. I didn't see a time limit on MySQL.

Jim Michaels wrote:

INSERT INTO `graph_apps` (`app_id`,`name`) VALUES

(1,'cities'),

(2,'statemachine'),

(3,'molecules'),

(4,'prj_mgmt');

One insert statement. Use commas. As I saw in a previous post, there is a
30-second limit probably imposd on the server, and a 1MB query limit also
probably imposed on the server. If its your own box, you can probably tweak
that out.

<Fu*************@gmail.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...

Hello,

I hope some one can help me, at least give me a little direction.

I have the need to insert many records into the same table at once.
Not very many data points (<5), but many (30+) records. Not being a
PHP guru, I am at a loss as where to start. Really I am a PHP
neophyte. Though I am a quick study and REALLY need to know how to do
this.

Please Help!

Thanks!