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';

cheers,
--
- 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



Reply via email to