Why does this NOT work?
UPDATE tipping SET score = 3 WHERE round1.game1 = H AND tipping.username = jerry;
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 (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php