MySql query not working, not giving error

[Oni]

Hey,

I'm running the below queries and they don't seem to be working.
The code sets the value in "credits" to 0 and the value in "earned" stays the same.

I'm pretty sure that the variables are all correct (As in all of the variables in the queries have a value)

$query = "SELECT credits, earned FROM users WHERE id=$user";
$result = mysql_query($query) or die(mysql_error()); 
$row = mysql_fetch_array( $result );

$credits = ($row['credits'] + 0.7);
$earned = ($row['earned'] + 0.7);

$query = "UPDATE users SET credits=$credits AND earned=$earned WHERE id=$user";
$result = mysql_query($query) or die(mysql_error()); 

Why? 🙁

Thanks!

[stewartship]

Replace:

$row = mysql_fetch_array( $result );

with:

$row = mysql_fetch_assoc( $result );

should work if everything else is ok

[devinemke]

you do not need the SELECT query at all

UPDATE users SET credits = credits + 0.7, earned = earned + 0.7 WHERE id = $user

[Houdini]

use single quotes on your variables '$user' '$credits' '$earned'

[Oni]

Had no idea you could do that with the update query...

Tried it, and it works great! (Not to mention while using less recources!) 😉

Thanks!!