On Thursday 24 March 2005 17:26, JeRRy wrote:
>
> I was getting an error earlier stating round1 does not
> exist, however it does. round1 table does not exist.
> So does not say round1.game1 does not exist.
Does a table named round1 exist in your database?
If so and you are using mysql > 4.0.4 yo
missing single quotes around text
UPDATE tipping SET score = 3 WHERE round1.game1 =' H'
AND tipping.username = 'jerry';
bastien
From: JeRRy <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: [PHP-DB] Why not ?
Date: Fri, 25 Mar 2005 04:05:28 +1100 (EST)
Why does this NOT work?
UPDATE tipping SET
--- "Larry E. Ullman" <[EMAIL PROTECTED]>
wrote:
> > Why does this NOT work?
> >
> > UPDATE tipping SET score = 3 WHERE round1.game1 =
> H
> > AND tipping.username = jerry;
>
> For starters, you should quote strings in a query.
> There may also be a
> problem with the round1 reference.
>
> Lar
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
Why does this NOT work?
UPDATE tipping SET score = 3 WHERE round1.game1 = H
AND tipping.username = jerry;
For starters, you should quote strings in a query. There may also be a
problem with the round1 reference.
Larry
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http: