Count visitors using only one php page, with different variables

Can anyone help me ?

I'm just fractionally past being a newbie <-- what's that then? A
n.bie mebbe. I'm streamlining a website with 70 different clients on
it, putting all details into a mysql $db, and just loading 1 php page
depending on the client chosen, and grabbing that client's details to
view. Easy so far.

What I'd like to do though is record at the same time incremental hits
to that specific client. So it must mean recording displays of that
specific row - or would it be instances of the passed variable back at
the page?
Ie, $name=client.

And then adding a count to a field in that row, I assume.
But how?

I don't have any code because I'm not sure how to begin.

If anyone can help, or at least show me where to begin, i"d be
grateful.
Thanks

george say...

> Can anyone help me ?
>
> I'm just fractionally past being a newbie <-- what's that then? A
> n.bie mebbe. I'm streamlining a website with 70 different clients on
> it, putting all details into a mysql $db, and just loading 1 php page
> depending on the client chosen, and grabbing that client's details to
> view. Easy so far.
>
> What I'd like to do though is record at the same time incremental hits
> to that specific client. So it must mean recording displays of that
> specific row - or would it be instances of the passed variable back at
> the page?
> Ie, $name=client.
>
> And then adding a count to a field in that row, I assume.
> But how?

create a table where you have a client field which is a primary key, and
a count field which is an int field.

Query might be something like this:

<?
// if $name=client

$result = mysql_query("SELECT * FROM counts WHERE client='" . $name .
$'");

if (mysql_num_rows($result) == 0)
{
// client has never visited, so create a row in the table
$result2 = mysql_query("INSERT INTO counts (client,count)
VALUES ('" . $name . "',1)");
} else {
// client has been before, so update count
$result2 = mysql_query("UPDATE counts SET count=count+1 WHERE
client='" . $name . "'");
}

?>


I think this is the sort of thing you're after. Obviously you don't
necessarily need a seperate table for this, the 'count' field could be in
the client table but you get the idea.



--
Nathan.
XBL Gamertag: Cowfield
http://www.cowfields.com
Bow to the Cow!