From: Bishop B. <ph...@id...> - 2008-01-21 01:16:14
|
All, I have a question about the phpESP underlying design: if you delete a =20 survey to which a response points, can you still recover the answers =20 given in the response? For example, say you have this: mysql> select id,survey_id,complete from response; +----+-----------+----------+ | id | survey_id | complete | +----+-----------+----------+ | 7 | 18 | Y | | 6 | 18 | Y | | 8 | 18 | Y | | 9 | 18 | Y | | 10 | 18 | Y | | 11 | 17 | N | | 13 | 20 | N | | 14 | 21 | Y | +----+-----------+----------+ and then you do this: delete from survey where id=3D18 Can you get the responses made for response ids 6, 7, 8, 9, and 10? =20 If so, is there a convenient function to get those responses as an =20 array/object? Thanks! bishop --=20 Bishop Bettini ideacode, Inc. (main) +1 919 341 5170 / (fax) +1 919 521 4100 Visit us on the web at: ideacode.com Professional software research and development reviewmysoftware.com Improve sales! Review your software before you release bytejar.com Solutions to those annoying development problems |