Jump to content

insert select


karimali831
 Share

Recommended Posts

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
Share on other sites

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
Share on other sites

This thread is more than a year old.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.