Thread: PHP Question - simply but cant find the answer

If you have space on your server, I'd install phpMyAdmin as it makes managing MySql database so much easier.

Multiple inserts is one way; if you are just putting data in by hand, this is probably easiest as it is easier to fix if it goes wrong (i.e. you miss out a ').

If you have a text/csv file you want to import have a look at :- www.mysql.com/doc/en/LOAD_DATA.html, I haven't used that method, but its the why phpMyAdmin does it in the background.

php???? programs seem to be good - even though they are separate projects. I use phpMySql, phpAdsNew (For managing adverts, as seen at the top of the page) and phpBB2 (a php/MySql based forum).

Nice to have another php hacker amongst us!

SYLT thanks for that, I will be taking a look at the other options later, but how do you do the insert command with more than 1 set of values (ie, to create 3 rows)?

Is it possible?

I haven't tried it, but from just scanning the manual it looks like

Code:

 INSERT tablename (colname1, colname2, colname3)
VALUES ('val1a', 'val2a', 'val3a'), ('val1b', 'val2b', 'val3b'), ('val1c', 'val2c', 'val3c')

will work if you have MySql version 3.22.5 or later. Just repeat ('val1', 'val2', 'val3') for as many rows as you want.

If this doesn't work (i.e you have an earlier version), then use multiple inserts.

www.mysql.com/doc/en/INSERT.html

THANK YOU !!! <img src=http://www.gamers-forums.com/smilies/contrib/ruinkai/biggthumpup.gif ALT=":thumb">

It worked a treat :rollin: