| | |
| |
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: WebPage Updating...... |
|
From: |
outsider |
|
Date: |
8/28/2000 10:05:27 AM |
|
IP: |
212.95.172.2 |
Sure.
First, create table including your needed fields
Str_link, str_ImageName, str_AuthorName, str_UserID(related probably with table users), str_Text, str_Heading and so….
You also can include a field for date.
When users are redirected to your admin page make them fill a form:
Link, imagename(they’ll have to upload it on the server, you will write image’s name into tha table), etc. (date probably will be =date())
Fill table with data from the form.
Your main page (where users will watch and browse) will be generated from this table:
Probably: strSQL=“SELECT * FROM table_name WHERE Date_Field = CONVERT(DATETIME,101,”&Date()&”)”
Then open your recordset and write your values in variables:
StrImageName = rs(“str_ImageName”)
…………………………………………
-> generate HTML using variables
Well, I can’t write the whole module, don’t worry it’s very simple.:) |
Previous Message
|
|
|
|
|
|
