Tutorial or documentation

  • Resolved kams01

    (@kams01)


    11 years ago

    Just downloaded this. Someone recommended this for my situation, where I have a table with 365 rows (the whole year) and times for 5 activities per day. I need my site to display only the activities for Today from the table where the site figures it out automatically by knowing today’s date.

    Is there a tutorial or documentation for your plugin i can read to figure this our or can you help me with this? Here is a link to the question i posted on the support forum of another plugin. Thanks.

    https://ww.wp.xz.cn/plugins/tabulate/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author samwilson

    (@samwilson)

    11 years ago

    (Sorry for the delay in replying.)

    There isn’t much documentation yet, I’m afraid. You can possibly do what you want by creating a view using the CURDATE() function. Say you’ve got a table timetable {id, activity_date, time_1, time_2, time_3} then you coud show just the row for today with:

    CREATE OR REPLACE VIEW timetable_today AS
  SELECT * FROM timetable
  WHERE activity_date = CURDATE();

    Then just grant ‘read’ access to that view for whichever roles are applicable.

    Plugin Author samwilson

    (@samwilson)

    10 years, 11 months ago

    Let me know if you need any more help. Marking this as resolved now.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Tutorial or documentation’ is closed to new replies.