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.

Update more tables

Discussion in 'PHP' started by tasos55, Apr 17, 2013.

0
  1. #1
    Hello there, i need to count when they click on the picture it works, but now i want to update more tables how to do that ? here below is the script.

    mysql_query("UPDATE pictures SET count_pic = count_pic + 1 WHERE id = " .$file_id);
    PHP:
    Thanks.
     
    tasos55, Apr 17, 2013 IP
  2. Dangy

    Dangy Well-Known Member

    Messages:
    841
    Likes Received:
    25
    Best Answers:
    2
    Trophy Points:
    155
    #2 
    mysql_query("UPDATE table,table,table SET count_pic = count_pic + 1 WHERE id = ".$file_id);
    PHP:
    or


    mysql_query("UPDATE pictures SET count_pic = count_pic + 1 WHERE id = " .$file_id);
mysql_query("UPDATE pictures SET count_pic = count_pic + 1 WHERE id = " .$file_id);
mysql_query("UPDATE pictures SET count_pic = count_pic + 1 WHERE id = " .$file_id);
    PHP:
     
    Dangy, Apr 17, 2013 IP