This note from http://us4.php.net/manual/en/function.rawurldecode.php might explain what you're seeing if you're using urldecode() "Note: rawurldecode() does not decode plus symbols ('+') into spaces. urldecode() does. " If you start out with $url = "The+Man+On+The+Moon" and you urldecode($url) then you should, predictably, end up with The Man On The Moon. If plus signs are a problem, you may need to implement a little bit of code just to check the string for + then use either urldecode() or rawurldecode() to get the output you want. Something like: $position = stripos($urlFromDB, "+"); if($position === FALSE){ rawurldecode($url); } else( urldecode($url); } or something along those lines. I'm just shooting from the hip here. stripos() returns a boolean false so be careful there. Not sure if my if() statement is right. > -----Original Message----- > From: Aaron Wolski [mailto:aaronjw@martekbiz.com] > Sent: Thursday, July 31, 2003 3:49 PM > To: 'Hutchins, Richard'; php-db@lists.php.net > Subject: RE: updating a column based on info from another > coluimn? Desperate! > > > Hey hey, > > Works like a charm. I have have my urls looking like > The+Man+on+The+Moon > > Seems weird, however, PHP automatically strips out the +'s? > cause when I > echo the variable I get The Man On The Moon. > > Idea's? > > > Also.. ANYWAY to make the +'s into -'s (hyphens)??? > > Thanks!! > > Aaron > > -----Original Message----- > From: Hutchins, Richard [mailto:Richard.Hutchins@Getingeusa.com] > Sent: July 31, 2003 3:21 PM > To: php-db@lists.php.net > Subject: RE: updating a column based on info from another > coluimn? Desperate! > > Will urldecode() work for you on the PHP side or do you have > to convert > everything in the database? > > http://us4.php.net/manual/en/function.urldecode.php > > > -----Original Message----- > > From: Aaron Wolski [mailto:aaronjw@martekbiz.com] > > Sent: Thursday, July 31, 2003 3:14 PM > > To: php-db@lists.php.net > > Subject: updating a column based on info from > > another coluimn? > > Desperate! > > > > > > Hi All, > > > > This is OT but I am in need of serious help. > > > > I am rewriting URL's for a site and came across an issue with > > spaces in > > URLS having %20 applied to them. I can't seem to find a > solution with > > mod_rewrite to get rid of the %20 and replace with - > (hyphen) so I am > > hoping someone can help me here with an MySQL solution. > > > > I have over 4000 records in a table. I've added a new column in that > > table called newUrl > > > > Is it possible with a QUERY to take from the 'designers' column and > > write into the 'newUrl' column and replace spaces with - at the same > > time? > > > > I'm probably talking out my a$$ here but I am a little > desperate for a > > solutions. > > > > Thanks in advance and again my apologies for the OT message. > > > > Aaron > > > > > > -- > 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
