Re: Why not ?
| From: | Martin Norland | Date: | Thu, 24 Mar 2005 17:15:13 +0000 |
| Subject: | Re: Why not ? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-39029@lists.php.net to get a copy of this message | ||
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.