[Resolved] [Resolved] [Resolved] To retrieve a number value from MySQL?

[jeffkee]

I'm trying to take a number out of my MySQL table.

The field is set to tinyintegers..

I searched the value through query strings,

and the value

---

$data = mysql_fetch_array($result);
$points = $data["points"]

$newpoints = $points + 5

mysql_query("UPDATE users SET points='$newpoints'");

---

And every time I execute this file, the value on the MySQL is set to 0!!! What do I do to retrieve the value as a simple number instead of a regular string?

[LordShryku]

Why would you even do that? You can do the math calculation in the sql...

UPDATE table
SET points = (points + 5)
WHERE some_field = something