Thread: Perl and MySQL

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

    Join Date
    Oct 2000
    Posts
    0
    Rep Power
    0
    I need help with writing a perl script that looks through a MySQL database table for a date in the table that is five days from the time that the script runs. Can anyone outline the functions that perl uses to accomplish this task?
  2. #2
  3. No Profile Picture
    RyanP
    Guest
    Devshed Newbie (0 - 499 posts)
    too general, look into Perl DBI
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    71
    Rep Power
    15
    You should use DBI module for communication with MySql.
    Download latest version of DBI module, and MySQL driver from this page: http://cpan.valueclick.com/modules/by-module/DBD/

    Then install it on your server. Or probably just upload DBI.pm and Mysql.pm from those zip files.

    You should upload in this directories:

    /cgi-bin/DBI.pm
    /cgi-bin/DBD/Mysql.pm

    Tutorial for DBI for beginners: http://www.perl.com/pub/1999/10/DBI.html

    And Tutorial for MySQL:
    http://www.mysql.com/Manual_chapter/..._Tutorial.html

    If something doesn't work right search trough previous posts on this forum, most questions are already answered...

    [This message has been edited by Pepe (edited October 13, 2000).]

IMN logo majestic logo threadwatch logo seochat tools logo