-
Ideas. You add a field to the message table in the database, name it check sf, the value is "yes" or "no", the check sf field is added to the "no" by default when leaving a message, and the value of check sf is judged when it is displayed in the foreground, and only the value of the check sf field is displayed when the background management is set to "yes", and the sql statement in the foreground can be written like this.
select * from message where check_sf='Yes' order by submit desc
-
Display page Add a condition to the query statement when validating field=1 before displaying 1 in the data table Add field "validation".
2 The default value for setting validation is 0
3 Make a link to the page of the background management message, such as ? id=104 is the data that is querying id=id Modify the validation field If it is 0, it is equal to 1, and if it is 1, it is equal to 0
5 Add a condition to the query statement on the foreground display page, and display Qihuo only when the validation field = 1.
Sorry for reading the wrong question!
Should. Display the page Add a condition to the query statement when the reply field <>""of the display. (not equal to empty).
-
I don't know what the message reply field in your database is used for, and what is the default value? When the foreground displays, as long as the content of this field is judged, if it is empty (assuming that your field is empty when it is not restored), it will not be output, and if it is not empty, it will be output.
-
Key features: The message board is mainly composed of modules such as "View Topic", "Leave a Message", "User Registration", "My Message" and "Message Management". After entering the message board, you can view all the messages you have commented, and you can also check the topics you posted and the replies to the topics at any time.
Operational precautions.
1) The user name of this system administrator is mr, and the password is: mrsoft.
Business processes. When using this system, please follow the following process:
1) In the [User Registration] module, first register the user and obtain the username and password.
-
Hello, can you send me a copy of this asp, thank you very much, if you need points, you can tell me, really please.
To maintain a one-to-one guestbook database, it should look like this: (Table 1) ID content and other auxiliary items, such as time, IP, poster......Then add a table to the database. Name it casually. >>>More
Use split separation, but note that when multiple form elements have the same name, the data sent is in the same format. >>>More
Below is saved as.
set conn="") >>>More
The following ** I wrote for you can accomplish such a function, but the specific content needs to be added by yourself, and you have to know a little HTML to do it: >>>More
I just bought this book, Dell's 1400, like you, I feel very distressed, and I don't feel at ease. After reading the above article, I can be relieved, (*hee-hee......