Unanswered: autoenter date and klickable web-urls.
Hi all. Im just getting the hang of simple Mysql-stuff but i cant figure out how to autoenter date in my date-field. I made it NOT NULL and default 0000-00-00 but i only get the zeros in all the posts, datefiled.
I also have a filed that people puts weburls in but when i se them in a webbrowser i they are not klickable, how do i do that.
1) Re date field
As far as I know you cannot default the field to NOW. What you can do when the record is created add the current time in the SQL statement:
"INSERT INTO.... (... ,col_date,...) VALUES (..., NOW(),...)
(instead of NOW you can put a specific date/time)
2) Re URL
When you output the url value, add HTML tag for link (ASP example):
response.write "<a href=""" & theURL & """>" & theURL & "</a>"