Update field in master table

This topic is locked

Update field in master table	11/26/2005 11:47:43 PM
PHPRunner General questions
D Devon author I am not sure if this is possible, but it seems it would be. I am working with a view of the detail table. The detail table is linked to master table via a key field. like this: Table A - Detail Table Table B - Master Table All is working well, but I need to update a field in Table B that is no tshowing up. It is not the field used to link the two tables. Any ideas?


	Sergey Kornilov admin 11/28/2005
	Hi, you can your custom code to execute custom SQL query into generated pages. The code can look like this: $sql = "update B set field1=... where id='".$_SESSION[$strTableName."_masterkey"]."'"; db_exec($sql,$conn);