[snip] What if within these 30 days, student John actually decided not to withdraw anymore and to continue to study in the school? Is there any way whereby I can set the status to "0" again n then John will not be deleted from the DB?? Wonder if this would be possible??>? [/snip]
Yes, it is possible. http://homepages.tesco.net/~J.deBoynePollard/FGA/questions-with-yes-or-n o-answers.html Use an UPDATE query... UPDATE tblStudent SET status = 'n' WHERE uniqueID = 'John' Database questions should be referred to a database or SQL list. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
