RE: [PHP] Re: order of update??
| From: | Sam Masiello | Date: | Thu, 23 Aug 2001 20:15:02 +0000 |
| Subject: | RE: [PHP] Re: order of update?? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-64170@lists.php.net to get a copy of this message | ||
Why "can't you update" ? What error message are you getting?
Sam Masiello
Software Quality Assurance Engineer
Synacor
(716) 853-1362 x289
smasiello@synacor.com
-----Original Message-----
From: Gerard Samuel [mailto:trini0@optonline.net]
Sent: Thursday, August 23, 2001 3:28 PM
To: PHP
Subject: Re: [PHP] Re: order of update??
Im currently hacking away at a current setup that uses php/mysql on a
user table. I have successfully inserted and selected from it, but I
cannot update. Yes there were quotes, but thanks for letting me know
that the order didn't matter, that narrows my list of possibilities
down. Talk to you all later.
trini0
jimw@apache.org wrote:
> Gerard Samuel <trini0@optonline.net> wrote:
>
>>My seem stupid to some, but when running
>>update tablename set x='$x', y='$y', z='$z' where a=$a;
>>Does it matter if it the set were in backwards order ie z, y, x ??
>>
>
> the order does not matter. (although unless you're sure $a is an
> integer value, you may want to wrap it in quotes, too.)
>
> jim
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
For additional commands, e-mail: php-general-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net