Back To Programming / Scripting / Coding Forum

update 2 table

  • ultimate11
  • Student
  • Student
  • No Avatar
  • Joined: Feb 02, 2011
  • Posts: 86
  • Status: Offline

Post December 26th, 2011, 2:52 am

guys how to update two table
Code: [ Select ]
mysql_query("UPDATE login_tb l,reply_tb r SET l.L1='$_SESSION[session_user]', l.L2='$_SESSION[session_pword]', l.firstname='$firstname', l.lastname='$lastname',r.user='$_SESSION[session_user]' WHERE l.id and r.id='$id' ")

coz either of the two table will be updated all of the field
  • Anonymous
  • Bot
  • No Avatar
  • Joined: 25 Feb 2008
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post December 26th, 2011, 2:52 am

  • ultimate11
  • Student
  • Student
  • No Avatar
  • Joined: Feb 02, 2011
  • Posts: 86
  • Status: Offline

Post December 30th, 2011, 2:52 pm

Try this...
http://askzone.wordpress.com/2011/12/30/mysql-update/

Page 1 of 1

Post Information

  • Total Posts in this topic: 2 posts
  • Users browsing this forum: No registered users and 86 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 2011 Unmelted, LLC. Ozzu® is a registered trademark of Unmelted, LLC.