On Fri, 24 Aug 2001 04:57, Gerard Samuel wrote:
> 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
>
> [EMAIL PROTECTED] wrote:
> > Gerard Samuel <[EMAIL PROTECTED]> 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
As a debugging aid, use mysql_error() to trap any error messages returned
from the database, and mysql_affected_rows to determine the number of
rows affected by your update query. It _might_ be that your query is
valid, but actually no rows meet the criteria for update?
--
David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc
CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA
"His Honor is crazy," Tom admitted judgementally.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
