Re: [PHP-DB] Why not ?
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 you will need to mention all tables referenced in the WHERE clause in the UPDATE clause. e.g. UPDATE tipping, round1 SET tipping.score = 3 WHERE round1.game1 = 'H' AND tipping.username = 'jerry' (assuming the score column you want to update is in the tipping table...) You almost certainly want to join the two tables as well but without knowing your database it is impossible for me to say how. If you are using an older mysql version what you want to do is probably impossible in one statement. Simon -- ~~ Simon Rees | [EMAIL PROTECTED] | ORA-03113: end-of-file on communication channel ~~ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Why not ?
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 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.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Why not ?
--- "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. > > Larry > 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. But the table name exists. And I use the correct quotations, this does not effect it without it when i use other queries. I will keep trying... If anyone knows, shoot! :) 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.php.net/unsub.php
Re: [PHP-DB] Why not ?
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
Re: [PHP-DB] Why not ?
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://www.php.net/unsub.php
[PHP-DB] Why not ?
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.php.net/unsub.php
[PHP-DB] Why NOT you ?
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 beginning with YOU ! >> http://www.adminder.com/c.cgi?formorcash&CCIbm THE BUSINESS OPPORTUNITY... Could you use an additional income of $4,000 a month...every month ? Step 1 It's as easy as joining CCI for $9.99 and the CCI upgrade for an additional $9.99...That's a total of $19.98...For under $20 you can start your own business which will begin to return a real monthly income within just a few months. Step 2 Invite 4 members into CCI just like you...People who want to be making $4,000 in six months... Then help your 4 new members do the same as you...which is find their 4 people who want to be making $4,000 in six months. >> http://www.adminder.com/c.cgi?formorcash&CCIbm That's it...It's that easy... You've now set something in motion...A boulder tumbling down a hill that will begin to pick up momentum as it continues, until it becomes an avalanche ! This is what your avalanche will look like as it picks up momentum... 1st Month -- Your monthly fees are covered once you have invited your 4 CCI members at $19.98 each. 2nd Month -- You receive a check for $18.99 3rd Month -- You receive a check for $100 4th Month -- You receive a check for $200 5th Month -- You receive a check for $1,300 6th Month -- You receive a check for $4,000 and every month thereafter !!! >> http://www.adminder.com/c.cgi?formorcash&CCIbm THE TOOLS... We have the tools, 1,000's of training videos, auto-responders, traffic generators and training by some of the Internets top marketers on how to use them. Let's get started TODAY...The only thing that stands in your way of $4,000 a month...is 4 people...If you are serious I will help you get there! >> http://www.adminder.com/c.cgi?formorcash&CCIbm Before you go, it's important to know also that CCI, is the core company of the much awaited MegaOpp. When MegaOpp launched, the spillovers into CCI will be massive. Position yourself now. If you need more info on MegaOpp. Send me an email and I will be happy to fill you in. Questions - Email Me... To Your Success, Chew Tee Khim 659-638-7345 [EMAIL PROTECTED] >> http://www.adminder.com/c.cgi?formorcash&CCIbm Disclaimer For Unsolicited Email This message is sent in compliance of the new e-mail bill: SECTION 301. Per Section 301, paragraph (a)(2)(C) of S. 1618. This message is NOT Spam as long as you are provided with a way to remove your name from this mailing list. All further transmissions to you from me may be stopped at no cost to you by replying to this email with "Remove" in the 'Subject' line.