|
Replies:
2
-
Pages:
1
-
Last Post:
Mar 1, 2011 6:17 AM
by: Yasawas
|
Threads:
[
Previous
|
Next
]
|
|
Posts:
2
Registered:
2/28/11
|
|
|
|
Hide record (nor delete, or move to other table) + hide it after given time
Posted:
Feb 28, 2011 1:41 PM
|
|
|
Hi,
I suppose this is very simple to do, but since i'm kinda newbie in PHP (btw, Toad is very nice platform), so i'll explain it quickly:
The practical example:
The user must be able to "switch on/off" a certain record (in this case, it's a news article with images) in a table so it may appear (or not) on a certain page.
It has also to "file/hide" itself after a given time (in this case, 15 days, counting from the last update/insert).
I think this can be done when inserting/updating a record - with a extra checkbox on that form or something alike -, but i don't know how to do it. It is important that the record itself won't be deleted, only hidden from "public" view, and of course, able to be switched"on" again.
This way, i could dump a non-sequential (1, 3, 4, 6, 7, 9) recordset into a page (thus showing only the "on/active" articles).
The second option, well, blows me, i have no idea, and YES, i've searched a LOT.. :P
It would be of course VERY NICE if i could do all this right in TOAD. (yay!)
Thank you!
PP
|
|
|
|
|
|
|
Re: Hide record (nor delete, or move to other table) + hide it after given time
Posted:
Feb 28, 2011 1:45 PM
in response to: Yasawas
|
|
|
Well you obviously need to write the application to actually show or hide the article in PHP.
You can certainly modify your table to provide the columns to do this to your table using Toad. Just do alter table on the table you have in the object explorer.
|
|
|
Posts:
2
Registered:
2/28/11
|
|
|
|
Re: Hide record (nor delete, or move to other table) + hide it after given time
Posted:
Mar 1, 2011 6:17 AM
in response to: Guest
|
|
|
Well obviously, the "i don't know how to do it" part wasn't read.
It was, indeed, very helpful..
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
