JeRRy wrote:
Why does this NOT work?

UPDATE tipping SET score = 3 WHERE round1.game1 = H
AND tipping.username = jerry;

Please inform?

You're not linking table round1 to table tipping in any way, and you've got some quoting issues.

something like this:

UPDATE tipping SET score=3 WHERE round1.game1='H' AND round1.username=tipping.username AND tipping.username='jerry';

- Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital.

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to