karimali831 Posted April 14, 2012 Share Posted April 14, 2012 Need help with insert(), I am using the below insert query with values from SELECT but want to add data not from the select also, so instead of ...clan2, comment, 1on1 I would like to put: ...clan2, comment, 1on1, date and value of date: time() do I need join query someone show me how to please? safe_query("INSERT INTO ".PREFIX."cup_matches ($type, $type_opp, matchno, clan1, clan2, comment, 1on1) ( SELECT a.$type, a.$type_opp, a.matchno, a.clan1, b.clan2, a.comment, a.1on1 FROM ".PREFIX."cup_matches a, ".PREFIX."cup_matches b WHERE a.clan2 != b.clan2 AND a.matchno = '$ID' AND b.matchno = '$ID' AND a.$type='h' AND b.$type='h')"); Link to comment https://forums.phpfreaks.com/topic/260930-insert-select/ Share on other sites More sharing options...
karimali831 Posted April 14, 2012 Author Share Posted April 14, 2012 So you cannot use insert select and insert value in one query? I would appreciate someone can help me with this as it is urgent, please Link to comment https://forums.phpfreaks.com/topic/260930-insert-select/#findComment-1337389 Share on other sites More sharing options...
awjudd Posted April 14, 2012 Share Posted April 14, 2012 Inserting using the set-based notation doesn't need the () around the values. The following should work: safe_query("INSERT INTO ".PREFIX."cup_matches ($type, $type_opp, matchno, clan1, clan2, comment, 1on1) SELECT a.$type, a.$type_opp, a.matchno, a.clan1, b.clan2, a.comment, a.1on1 FROM ".PREFIX."cup_matches a, ".PREFIX."cup_matches b WHERE a.clan2 != b.clan2 AND a.matchno = '$ID' AND b.matchno = '$ID' AND a.$type='h' AND b.$type='h'"); ~awjudd Link to comment https://forums.phpfreaks.com/topic/260930-insert-select/#findComment-1337405 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.