Re: Last visitors

Ryan A wrote: <snip>

then from my php script (test_last_visitors.php) I ran this test SQL: $SQL = "UPDATE test_last_visitors SET profile_id=".$profile_id.", user_id=user_id+1, ttimestamp=now() WHERE profile_id=1 ORDER BY ttimestamp ASC LIMIT 1";

Why are you setting the profile_id equal to a value when you also have that in your WHERE clause? I may have missed something here, but I though the purpose of this was to track the last ten visitors to a certain page, and if this is the case, why increment the user_id when updating the row? Shouldn't the query be more like... UPDATE test_last_visitors SET user_id=$user_id, ttimestamp=now() WHERE profile_id=$profile_id ORDER BY ttimestamp ASC LIMIT 1 -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 john@kegworks.com