Re: query problem

Thanks to Tim, Stephen, and Sarah. It did turn out to be an issue with quotes after all. Single quotes in particular. ;) I went and got meticulous with my urlencode/urldecode-ing. Phew!!! Jen > On Mon, Oct 21, 2002 at 04:05:06PM -0500, Jennifer Swofford wrote: > > The client was doing a whole batch of updates... and it seems that the > > query works for some items and not for others. For instance, I have a > > category called "Auto and Garage", and of the 7 items in that category, > > only 1 is updatable. In the "For the Birds" category, 12 of the 20 > > items are updatable. It is always the same items that fail. > > Make sure these fields don't have any special characters in them, > either at the database level, shell level, or html level. Proper > quoting/encoding is essential for things like this to work. > Also, make sure you are not passing GET or POST data with imbeded > spaces as part of the query, as the URL will break. > > See urlencode in the php manual. > > Tim