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 thi
--- "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:
Why does this NOT work?
UPDATE tipping SET score = 3 WHERE round1.game1 = H
AND tipping.username = jerry;
Please inform?
J
Find local movie times and trailers on Yahoo! Movies.
http://au.movies.yahoo.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.ph
Dear Online Business Opportunity Seekers
Why CCI ?
CCI, Core Club International is a 3 year old,
Federally registered non-profit humanitarian
aid, corporation.
Federal EIN # 93-1324671
State Reg. # 036394-99
Established April 17, 2000
CCI was set up to help eradicate poverty in the
world beg