Do you have a question? Post it now! No Registration Necessary. Now with pictures!
January 9, 2006, 3:20 pm
rate this thread
Re: URL description
Why do you need a variable in the URL? Just knowing what the database
key is should be all you need.
If you using something like $_SERVER['REQUEST_URI'] as the primary key
in the database, then all you need to do is something similar to:
$query='UPDATE table SET count = count + 1 WHERE page =
Then, if the query succeeds but affected rows == 0, you'll need to do an
$query='INSERT INTO table (page, count) VALUES
However, before doing this consider the effect that a search engine
spider will have on the database... you may want to use some filtering
of how/when the queries are executed...
Justin Koivisto, ZCE - email@example.com