Re: Re: order of update??

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 > > 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 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.