RE: [PHP] Doubts With Select Queries
| From: | Jay Blanchard | Date: | Wed, 03 Dec 2003 13:04:58 +0000 |
| Subject: | RE: [PHP] Doubts With Select Queries | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-171667@lists.php.net to get a copy of this message | ||
[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.