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.

    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
  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