View Single Post

   
  #2 (permalink)  
Old 05-16-2008, 01:40 PM
Chuck Anderson
 
Posts: n/a
Default Re: Query ordered by data from another table

Good grief. I have a minor, but confusing typo:

Chuck Anderson wrote:
> ......


> When an ip_address (visitor) visits more than 25 times in less than half
> an hour I INSERT that into another table 'over_limit', which has four
> columns.
>


Should be ..... "which has *three* columns."

> Table 2 -`over_limit` (3 columns)
> over_limit_id # auto_incr
> ip_address
> modified_date # timestamp = date this ip_address last exceeded limit
>


--
*****************************
Chuck Anderson • Boulder, CO
http://www.CycleTourist.com
Nothing he's got he really needs
Twenty first century schizoid man.
***********************************

Reply With Quote