Infinite Script

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Maximus

    Infinite Script

    I need to make a script that whenever somethin is added to the db, it
    will run and grab those info. Worth sayin that there's no time limit
    for the db data addition.

    I was planning of makin a script that runs infinitly every 0.25 seconds
    and break then runs again.

    If you have any ideas please inlighten me.

  • Jerry Stuckle

    #2
    Re: Infinite Script

    Maximus wrote:[color=blue]
    > I need to make a script that whenever somethin is added to the db, it
    > will run and grab those info. Worth sayin that there's no time limit
    > for the db data addition.
    >
    > I was planning of makin a script that runs infinitly every 0.25 seconds
    > and break then runs again.
    >
    > If you have any ideas please inlighten me.
    >[/color]

    Which database? What does it need to do?

    Sounds like you need a trigger.

    --
    =============== ===
    Remove the "x" from my email address
    Jerry Stuckle
    JDS Computer Training Corp.
    jstucklex@attgl obal.net
    =============== ===

    Comment

    • Maximus

      #3
      Re: Infinite Script


      Jerry Stuckle wrote:[color=blue]
      > Maximus wrote:[color=green]
      > > I need to make a script that whenever somethin is added to the db, it
      > > will run and grab those info. Worth sayin that there's no time limit
      > > for the db data addition.
      > >
      > > I was planning of makin a script that runs infinitly every 0.25 seconds
      > > and break then runs again.
      > >
      > > If you have any ideas please inlighten me.
      > >[/color]
      >
      > Which database? What does it need to do?
      >
      > Sounds like you need a trigger.
      >
      > --
      > =============== ===
      > Remove the "x" from my email address
      > Jerry Stuckle
      > JDS Computer Training Corp.
      > jstucklex@attgl obal.net
      > =============== ===[/color]


      Exactly,

      I need a 24/7 trigger
      the trigger is a PHP script
      but i don't know how to make it go 24/7 other than using a cron job.

      any suggestions?

      Comment

      • Oli Filth

        #4
        Re: Infinite Script

        Maximus wrote:[color=blue]
        > Jerry Stuckle wrote:[color=green]
        > > Maximus wrote:[color=darkred]
        > > > I need to make a script that whenever somethin is added to the db, it
        > > > will run and grab those info. Worth sayin that there's no time limit
        > > > for the db data addition.
        > > >[/color]
        > >
        > > Which database? What does it need to do?
        > >
        > > Sounds like you need a trigger.
        > >[/color]
        >
        > Exactly,
        >
        > I need a 24/7 trigger
        > the trigger is a PHP script
        > but i don't know how to make it go 24/7 other than using a cron job.[/color]


        He means an SQL trigger. Various RDBMS support triggers, e.g. MySQL
        5.0.2+, MS SQL Server, PostgreSQL.

        The idea of a trigger is that the database server itself runs a
        sequence of instructions whenever a record is inserted, updated or
        deleted.

        --
        Oli

        Comment

        • Jerry Stuckle

          #5
          Re: Infinite Script

          Maximus wrote:[color=blue]
          > Jerry Stuckle wrote:
          >[color=green]
          >>Maximus wrote:
          >>[color=darkred]
          >>>I need to make a script that whenever somethin is added to the db, it
          >>>will run and grab those info. Worth sayin that there's no time limit
          >>>for the db data addition.
          >>>
          >>>I was planning of makin a script that runs infinitly every 0.25 seconds
          >>>and break then runs again.
          >>>
          >>>If you have any ideas please inlighten me.
          >>>[/color]
          >>
          >>Which database? What does it need to do?
          >>
          >>Sounds like you need a trigger.
          >>
          >>--
          >>============= =====
          >>Remove the "x" from my email address
          >>Jerry Stuckle
          >>JDS Computer Training Corp.
          >>jstucklex@att global.net
          >>============= =====[/color]
          >
          >
          >
          > Exactly,
          >
          > I need a 24/7 trigger
          > the trigger is a PHP script
          > but i don't know how to make it go 24/7 other than using a cron job.
          >
          > any suggestions?
          >[/color]

          No, a database trigger. Many databases support the ability to execute
          code which are "triggered" by actions in the database.

          Again - what database? What does it need to do?


          --
          =============== ===
          Remove the "x" from my email address
          Jerry Stuckle
          JDS Computer Training Corp.
          jstucklex@attgl obal.net
          =============== ===

          Comment

          Working...