maccaj51
asked on
update mysql field on click?
I want to update a specific field in a specific row in a database using php...
i.e. when <a href="index.html>Home</a> is clicked it adds 1 to a running tally in:
Database - exampledatabase
table - exampletable
Where row = example record
in Field = hit_count
Any Ideas?
i.e. when <a href="index.html>Home</a> is clicked it adds 1 to a running tally in:
Database - exampledatabase
table - exampletable
Where row = example record
in Field = hit_count
Any Ideas?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It depends on your table layout.
If there is only one field, use
update TABLENAME set PAGECOUNT = PAGECOUNT + 1
Or use your primary key.
update TABLENAME set PAGECOUNT = PAGECOUNT + 1 where id=1
If there is only one field, use
update TABLENAME set PAGECOUNT = PAGECOUNT + 1
Or use your primary key.
update TABLENAME set PAGECOUNT = PAGECOUNT + 1 where id=1
Do you still require assistance with this Question?
ASKER
Hi BitFreeze...
So sorry been snowed under... havent tried it yet!
But will get back to you and will accredit you as necessary!!
Maccaj51
So sorry been snowed under... havent tried it yet!
But will get back to you and will accredit you as necessary!!
Maccaj51
It sounds like the thing you're looking for is called a "page hit counter" and you might get better results if you used the Google Analytics web service -- instead of trying to write one yourself.
But that said, here are some resources that describe how it is done ;-)
http://www.lmgtfy.com?q=php+page+hit+counter
But that said, here are some resources that describe how it is done ;-)
http://www.lmgtfy.com?q=php+page+hit+counter
ASKER
BitFreeze....
This is my code... But doesnt seem to be working or incrementing on page view...?
<?php
mysql_query("update news set PAGECOUNT = PAGECOUNT + 1 where filename=$filename");
?>
This is my code... But doesnt seem to be working or incrementing on page view...?
<?php
mysql_query("update news set PAGECOUNT = PAGECOUNT + 1 where filename=$filename");
?>
Try first solution posted by BitFreeze in post id ID:33421505
<?php
mysql_query("update tablename set hit_count = hit_count + 1 where examplerecord = '' ");
?>
You have only to add the correct condition to identify row wich has to be updated.
Bye
<?php
mysql_query("update tablename set hit_count = hit_count + 1 where examplerecord = '' ");
?>
You have only to add the correct condition to identify row wich has to be updated.
Bye
So your MySQL field has "filename" as the Primary ?
Please post the table layout.
ASKER
Im being very slow haha! BitFreeze ur first post has worked!! BRILLIANT!!
Thanks to marqusG: for pointing out my ineptitude!!
Thanks to marqusG: for pointing out my ineptitude!!
Sorry, but if so you could assign an assited solution to my comment, don't you?
Kind regards
Kind regards
ASKER
<?php
$con = mysql_connect("localhost",
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("DBNAME", $con);
mysql_query("update TABLENAME set PAGECOUNT = field + 1 where condition");
?>
Would this be right?!