Counter

[Napster]

I tried making a counter and the number always stays at one, neven if I refresh the page

The code is:

<?php

include"jocey.inc.php";

$connection = mysql_connect($host, $user, $password)
or die(mysql_error());

mysql_select_db($database, $connection)
or die(mysql_error());

$sql = "SELECT * FROM counter";
$select = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_array($select,MYSQL_ASSOC);

$counter = $row[number] + 1;

$query = "UPDATE members SET number='$counter'";
mysql_query($query) or die(mysql_error());

echo "$counter's people have been to this site";

?>

[mcrbids]

I'd guess the problem is in this line. You have a string '$counter' in the SQL query rather than just counter:

$query = "UPDATE members SET number='$counter'";

Try this instead:

$query="UPDATE members SET number=$counter";

But, more could be derived if we knew what value is stored in members.number?

-Ben

[LordShryku]

$sql = "SELECT * FROM counter"; 
$select = mysql_query($sql) or die(mysql_error()); 
$row = mysql_fetch_array($select,MYSQL_ASSOC); 

$counter = $row[number] + 1; 

$query = "UPDATE members SET number='$counter'"; 
mysql_query($query) or die(mysql_error()); 

You also seem to be working with two tables, so the number you get from counter is never changing....

[Napster]

about the table thing, I know it says 2 tables but in the code it is both table called counter. the variable i pull right now is 0

[LordShryku]

Must be something I don't see then, cuz this code works for me.