How to merge these 2 sql inserts?

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
GK
Forum Commoner
Posts: 51
Joined: Sat Jun 07, 2003 2:58 pm
Contact:

How to merge these 2 sql inserts?

Post by GK »

Hi all

i'm almost done building my polyphonic ringtone scripts

i only got 1 problem left

i build my script in these mysql inserts:

INSERT INTO polyringtones (ringtoneid,artist,song,sectionid,newdate) VALUES (1100001,'Xavier Naidoo','Bevor Du Gehst',254,'2002-10-31');
INSERT INTO polyringtones (ringtoneid,artist,song,sectionid,newdate) VALUES (1100002,'10cc','Dreadlock Holiday',252,'2002-11-7');
INSERT INTO polyringtones (ringtoneid,artist,song,sectionid,newdate) VALUES (1100003,'Ace Of Base','All That She Wants',269,'2002-11-7');

Now i got to import an other sponsor that uses difrend tables
like this

INSERT INTO ringtone (ordernr,titel,datum,ranking,category) VALUES (80414,'007 - You only live twice','2002-11-01',0,1);
INSERT INTO ringtone (ordernr,titel,datum,ranking,category) VALUES (80634,'2 Unlimited - Get ready for this','2003-04-16',-178,9);
INSERT INTO ringtone (ordernr,titel,datum,ranking,category) VALUES (80635,'2 Unlimited - No limits','2003-04-16',-934,9);

the name and description should be seperated the rest is ok
i got to see the type of ringtone in my admin

the first inserts are MM and the second Ringtonio

How can u make a import file that converts this to the right tables?
Tubbietoeter
Forum Contributor
Posts: 149
Joined: Fri Mar 14, 2003 2:41 am
Location: Germany

Post by Tubbietoeter »

go to http://www.php.net and search for explode
Post Reply