[SOLVED] Troubles With My Hit Counter

[phpQuestioner]

I am having having problem with my hit count. I only have one row in my table; so I am not sure how I would use the "where" at the end of my mysql_query update.

 

 

<?php

mysql_connect("localhost","username","password");

mysql_select_db("database");

mysql_query("UPDATE mytable SET myrow=myrow+1");

?>

[d22552000]

so whats the problem?

[phpQuestioner]

its not updating........

[TheFilmGod]

Lol. No offense but you made a pretty funny mistake.  ;D ;D

 

You need to have an id fieldname that has value of "1". You must use it to pin point which row you want to update.

 

then do what you did with the mysql query but set where id='1'. But first you need to create that fieldname. Hope that helps.

 

I'm a noob.

[phpQuestioner]

yeah - ok - i did that - but it still is not updating

 

<?php
mysql_query("UPDATE mytable SET myrow=myrow+1 WHERE number='1'");
?>

[phpQuestioner]

ok - i know what the problem was. in my real script i mis-spelled localhost - i had localhots - now i feel stupid - thanks everyone for their help.

[d22552000]

ciao idioto

[TheFilmGod]

yeah - ok - i did that - but it still is not updating

 

<?php
mysql_query("UPDATE mytable SET myrow=myrow+1 WHERE number='1'");
?>

 

"number"? ???

 

If you knew a tad bit of mysql and about php you should call that fieldname "id," with auto increment.

[phpQuestioner]

TheFilmGod - I know enough to do what I need to do and I always am continuously learning new things; just as most PHP coders are - I did not want to use a auto increment (although I am very aware of it - I have used it before) - also "id" is way over used as a field name - It's just been a while since I created a hit counter - But Thanks Anyways