Jump to content


Photo

Using the UPDATE statement


  • Please log in to reply
1 reply to this topic

#1 WhiteDevil

WhiteDevil
  • Members
  • Pip
  • Newbie
  • 2 posts
  • LocationUK

Posted 25 December 2003 - 08:23 PM

Evening guys :)

Im new to the forum, did a quick search for using mysql update statements and got a load of results - the thing is i didnt understand half of it and usually if i dont understand something ill forget it :?

Basically i have some tables (too many tables to think about at this hour) and what i want to do is update tblPilots with the value entered via frmPirep. The value entered in frmPirep is written to tblPirep so i can keep track of each individual flight...

I want to be able to add the value entered in frmPirep to the values already existing in the database...

To sum up, my question is, what is the syntax for UPDATE and why does it do what it does?

Thanks in advance for any help given, PHP developer in training :D

Adam

#2 Barand

Barand
  • Moderators
  • Sen . ( ile || sei )
  • 18,021 posts

Posted 26 December 2003 - 09:29 AM

http://www.mysql.com.../en/UPDATE.html

hth
If you are still using mysql_ functions, STOP! Use mysqli_ or PDO. The longer you leave it the more you will have to rewrite.

Donations gratefully received






moon.png

|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users