Re: How to edit the result after select join statement?

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 >