Question on Update command

[lauray34]

I'm trying to use a variable in the update of a field.

The Following won't work

$points = 5;

$query2 = "UPDATE `Cust` SET points = points + $points WHERE name = '$name'";
$result = mysql_query($query2);

What am I doing wrong with the above query?

Yet this one does work

$query2 = "UPDATE `$tablecust` SET points = points + 5 WHERE name = '$name'";
$result = mysql_query($query2);

Thank you

[bradgrafelman]

Welcome to PHPBuilder! When posting PHP code, please use the board's [noparse]

..

[/noparse] bbcode tags as they make your code much easier to read and analyze.

Few questions:

1. What does "won't work" mean? Are you getting any SQL errors? (Did you even bother checking for SQL errors?) Are you getting any PHP errors? (Is error_reporting set to E_ALL and display_errors set to On?)

2. What is the value of $tablecust?

3. Have you tried echo'ing out the two SQL query strings and visually inspecting them? Can you post them both here for us to see?