Comparing value from MySQL to an int in PHP doesn't work

Question

I am attempting to make my own website, from scratch, for a school project. It is going very well, and I got really far, but I encountered an issue, when comparing a variable to a number in a PHP script.

(I skipped alot of the code, which is not relevant, such as SQL connection etc)

$SQL = "INSERT INTO members (points) VALUES ('800')";

this works fine, and the number gets inserted in to my SQL databse as "int(64)"

then i put the variable in to a session in a PHP script

$_SESSION['points'] = $points[0];

then i put it down to another PHP script

$SQL = mysql_query("SELECT points FROM members WHERE username = $uname");
$points = mysql_fetch_row($SQL);

still fine, when I check $points[0] it is still 800

but I can't compare it in a statement such as this

if ($Points[0] >= 400)
{echo "took it";
}
else {echo "didnt take it";
}

Any idea of what could be wrong? It is bigger, but the variable gets threated as if its lower or empty.

Variable names in PHP are case sensitive. You should use if ($points[0] >= 400). — Ondřej Mirtes
– Ondřej Mirtes, Commented Feb 1, 2013 at 21:03
This might be one of the worst titles i've ever seen on this site. — Kai Qing
– Kai Qing, Commented Feb 1, 2013 at 21:05
Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. — Kermit
– Kermit, Commented Feb 1, 2013 at 21:13

Kermit · Accepted Answer · 2013-02-01 21:16:00Z

1

I'm taking a guess here, but I think you intend to compare $_SESSION['points'] when you say "then i put it down to another PHP script".

You need to update $_SESSION['points'] if you want the value to change.

In addition, variables are case sensitive. So in your if statement, you should be using lower case $points. You can check what mysql returns by doing var_dump($points).

answered Feb 1, 2013 at 21:16

Kermit

34.1k13 gold badges89 silver badges121 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Comparing value from MySQL to an int in PHP doesn't work

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related