update 2 table

  • ultimate11
  • Student
  • Student
  • ultimate11
  • Posts: 86

Post 3+ Months Ago

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
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

  • ultimate11
  • Student
  • Student
  • ultimate11
  • Posts: 86

Post 3+ Months Ago

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

Post Information

  • Total Posts in this topic: 2 posts
  • Users browsing this forum: No registered users and 156 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
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.