I am running a query in mysql :
SELECT DISTINCT (id) AS visitor_id,
MAX(date_time) AS last,
MIN(date_time) AS first,
UNIX_TIMESTAMP( MAX(date_time)) -
UNIX_TIMESTAMP( MIN(date_time)) AS diff
FROM visitors, pixeldata_
WHERE
visitors.created DATE_SUB( CURRENT_DATE, INTERVAL 1 HOUR )
AND
id =
I have a table that looks like this:
page_idvisitor_idtimestamp
...
13 20030101060522
58 20030101060512
26 20030101060634
73
What you'd be looking at there would be a custom script. Have a look at the
image functions of PHP. It can be done, but I think you'll find it easiest
to figure it out and write it yourself.
Mike
Miguel brĂ¡s [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi there gents,
i looked
PHP meant Personal Home Page to the guy who originated it. Later people
then decided to get cute and have redefined it to mean Php Hypertext
Preprocessor. Take your pick.
As for the max execution time, you're fine as long as the script completes
what it's doing within the allotted time. If