1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Query to copy row to all tables in wordpress multisite DB

Discussion in 'Databases' started by bellcom, Feb 18, 2016.

  1. #1
    I was hoping I could get some help correcting a script I use to copy a row from a table in my wordpress multisite db to all my other sub site tables in the db.
    SEMrush
    For example I have a row in one of my root site tables
    wp_119_stock_widgets

    and it needs to copy to all the sub site tables:
    wp_120_stock_widgets
    wp_121_stock_widgets
    wp_122_stock_widgets etc.

    I have attached a script I have that does work and it copies rows from 4 different tables and copies to all sub sites, its named working.php.

    I have also attached my script that does NOT work, update_stock_widget.php.
    I was trying to get row #2 from wp_119_stock_widgets to copy to all my other sub sites.
    When I run it I just get a blank page. Perhaps its something simple to correct?
    Any help appreciated :)

    thanks!!
     

    Attached Files:

    bellcom, Feb 18, 2016 IP
    SEMrush
  2. lektrikpuke

    lektrikpuke Well-Known Member

    Messages:
    297
    Likes Received:
    1
    Best Answers:
    1
    Trophy Points:
    113
    #2
    I'm sorry, but I don't want to dL and open zip files. Can you just post the sql scripts and resultant data?
     
    lektrikpuke, Mar 31, 2016 IP