Doubts With Select Queries
| From: | irinchiang at justeducation dot com | Date: | Wed, 03 Dec 2003 09:30:58 +0000 |
| Subject: | Doubts With Select Queries | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-171650@lists.php.net to get a copy of this message | ||
Hi all:
Having some doubts with sql select queries here :
Right now, I have a "student" and a "withdraw" tables.
For example, when student "John" has withdrawn, his name will be inserted
into "withdraw" table but John's record will be kept in "student" table for
a
period of 30 days before it is deleted from "student" table. In the meantime,
in "student" table, the status for John should be set to "0" (inactive).
Wonder the solutions I have mentioned is possible? And if so, how shld i go
about doing it ??....Hope to get some help really soon...Thanks in advance!
student table withdraw table
----------------------- -------------------------------------
|student_name | status | student_name | withdraw_reason
----------------------- -------------------------------------
| John | 0 | John | migrate
----------------------- -------------------------------------
| James | 1 |
-----------------------
Regards,
Irin Chiang.