Login Counter

[Pablo]

am trying to create a login counter but the counter number is stuck at 1 please help me and tell me wats wrong

here is the sql

visits var 255

and the coding goes on login.php

$visits = mysql_query("SELECT ibwf_users SET visits=visit+1 WHERE id='".$uid."'");

mysql_query("UPDATE ibwf_users SET visits='".($visit[0]+1)."' WHERE id='".$uid."'");
echo "°Login Counter: <b>$visits Times</b><br/>";

help please

[crazybrumi]

try

$visits = mysql_fetch_array(mysql_query("SELECT visits FROM ibwf_users WHERE id='".$uid."'"));

mysql_query("UPDATE ibwf_users SET visits='".($visit[0]+1)."' WHERE id='".$uid."'"); 

[Pablo]

it show nothing now look if here is rite?

echo "&#176;Times Login: <b>$visits</b><br/>";

[crazybrumi]

try $visits[0]

[crazybrumi]

is there an error being displayed

[Pablo]

so wats the error?

[kiLLeR-eyEd_14]

This is the correct..

mysql_query("UPDATE ibwf_users SET visits=visits+1 WHERE id='".$uid."'")
$visits = mysql_fetch_array(mysql_query("SELECT visits FROM ibwf_users WHERE id='".$uid."'"));


echo "°Login Counter: <b>$visits[0] Times</b><br/>"; 

so easy..crazybrumi's post is also correct, but she?/he? missed 1 letter..Its $visits[0] not $visit[0]

[kei_ki7]

..yeah he/she missed 1 letter nice one killer eyed, HANEP SA MATA !! -pmpl-

[Pablo]

lol thanx was the same wit mine lol lol

[kiLLeR-eyEd_14]

..yeah he/she missed 1 letter nice one killer eyed, HANEP SA MATA !! -pmpl-

hehe.,sanay lng kc..I'm not using any php code validator with my phone..Mano mano..Hehe..

[kiLLeR-eyEd_14]

lol thanx was the same wit mine lol lol

your 1st post was wrong..Instead to UPDATE, you made it SELECT..Lol..Then the $visits should be in the second sql query and you missed mysql_fetch_array..Then you printed $visits where it is defined to select as what u did, that it should be update..What that messy..

[Pablo]

...........................