heres the code.. I've been working on this for a while.. cant figure out what I'm doing wrong..
Code: Select all
$value = "Y";
# setup SQL statement
$SQL = " INSERT INTO registered WHERE usernumber = $namenumber ";
$SQL = $SQL . " ( payed ) VALUES ";
$SQL = $SQL . " ('$value') ";so basically what I wanted it to do, is.. insert into table registered only in the row where the usernumber I have selected is present, then modify column payed, by inserting value Y..... anything wrong with that you can see?.... any questions, ask, and I'll answer.. thanx for helping
edit : forgot to post the error it gave.. here it is
You have an error in your SQL syntax near 'WHERE usernumber = ( payed ) VALUES ('Y') ' at line 1 INSERT INTO registered WHERE usernumber = ( payed ) VALUES ('Y')