#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    3
    Rep Power
    0
    How do I print the date and the time when a MySQL database was last updated? I need to do this to see how often teachers at my school update their webpages through a control pannel. Thanks!

    Tyler Longren
  2. #2
  3. .Net Developer
    Devshed Novice (500 - 999 posts)

    Join Date
    Feb 2000
    Location
    London
    Posts
    987
    Rep Power
    15
    Hi,

    just create a "last_updated" column in your table.This column should be
    updated with the current date when ever the teacher's try to update the control panel.

    or

    probably you can create a separate table with teachers_id and last_updated fields.
    then update this table when ever teachers try to update some thing.




    ------------------
    SR -
    shiju.dreamcenter.net

    "I will love thee, O Lord,my strength"

Similar Threads

  1. Need advice designing a usage tracking database (MySQL)
    By Randolpho in forum Database Management
    Replies: 0
    Last Post: February 13th, 2004, 04:11 PM
  2. Database Administrators
    By phil310 in forum Database Management
    Replies: 1
    Last Post: February 9th, 2004, 01:03 PM
  3. mysql date time stamp and UTF8
    By doomish in forum MySQL Help
    Replies: 0
    Last Post: February 8th, 2004, 08:37 AM

IMN logo majestic logo threadwatch logo seochat tools logo