UPDATE MYSQl PROBLEM

[Redlightpacket]

i'm trying to get this statement to work but it don't work.

How do you get "$username" part to work.

What i'm trying to do is update the publictb from multiple user tables.

$result = mysql_query("UPDATE $username, publictb SET scriptref='$scriptref' AND scripture ='$scripture' AND WHERE id='$id' AND scriptref='$scriptref' AND scripture ='$scripture'")

[revraz]

Show us what it should say without a variable.

 

Also, you don't use AND in your SET function, use a comma.

Don't use AND before your WHERE.

 

$result = mysql_query("UPDATE $username, publictb SET scriptref='$scriptref', scripture ='$scripture' WHERE id='$id' AND scriptref='$scriptref' AND scripture ='$scripture'")