Sorry, I'm only reading half posts today. :) If you want to turn your + into - you'll probably have to go through one more step and do a preg_replace(). Like $new_url = preg_replace("+","-",$url); I think that'll work. Again, shooting from the hip and not testing. Yeah, baby, livin' on the wild side! Anyway, check out this page for additional info if you need it: http://us4.php.net/manual/en/function.preg-replace.php > -----Original Message----- > From: Hutchins, Richard [mailto:Richard.Hutchins@Getingeusa.com] > Sent: Thursday, July 31, 2003 4:03 PM > To: 'Aaron Wolski'; php-db@lists.php.net > Subject: RE: updating a column based on info from another > coluimn ? Desperate! > > > 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 > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php