RE: [PHP] How to edit the result after select join statement?

-----Original Message----- From: David Newcomb [mailto:davidn@vnvi.com] Sent: 06 September 2000 16:28 To: Wee Chua Cc: PHP (E-mail) Subject: Re: [PHP] How to edit the result after select join statement? * Please Note : This message was received from the Internet * _____________________________________________________________ Typicially you would sent the employee number as a hidden form value. They would enter the new number into the form and when it is submitted the server has all the information it need to update the record. Is that what you mean? David. ----- Original Message ----- From: Wee Chua <Chua@mail.interclean.com> To: PHP (E-mail) <php-general@lists.php.net> Sent: Wednesday, September 06, 2000 1:50 PM Subject: [PHP] How to edit the result after select join statement? > Hi all, > Could anyone tell me how to edit the result after select join statement? I > have a simple example query below, how could I update specific row? > > Company table > C_ID Company Name Phone > 1 ABC 123-456-7890 > 2 XYZ 111-111-1111 > > Employee table > E_ID Employee Name C_ID(FK) > 1 John Smith 1 > 2 Julie Foster 2 > > > Here is the query, > Select * from Company, Employee where C_ID="1"; > > The result would be: > C_ID ABC 123-456-7890 E_ID John Smith > > Let say I have more rows in the result and bigger table than the example, > and I find out the phone number of John Smith is wrong after some > complicated join query, can I just edit that row on result, how could I do > it? Please help, thanks in advance! > > > > Calvin > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net __________________________________________________________________ Confidentiality Notice This message may contain privileged and confidential information. If you think, for any reason, that this message may have been addressed to you in error, you must not disseminate, copy or take any action in reliance on it, and we would ask you to notify us immediately by return email to "Postmaster@Schroders.com".