Update problem mysql

[lunas]

I'm having a problem getting the following update function to actually update the table:

@("UPDATE $pntable[j_stats] SET viewers=CONCAT(viewers,',',$viewers) WHERE uid='$uid'");

The viewers field is of type text and the $viewers is varchar.

When I check the field, nothing is being written to the viewers field and I cannot figure out why. If I put echo statements prior to the statement above to check what values are in the variables, they all hold the right values.

I'm just trying to create a field where usernames keep getting added to the field and then output on a different page.

Anyone able to help me here?

---

If anyone cares, I found the problem, should have been:
@("UPDATE $pntable[j_stats] SET viewers=CONCAT(viewers,' ','$uname') WHERE uid='$uid'");

[barand]

Better than checking the individual variables is to check the sql is properly constructed.

$sql = "UPDATE $pntable[j_stats] SET viewers=CONCAT(viewers,',',$viewers) WHERE uid='$uid'";

echo "$sql<br>";

@($sql)