RE: [PHP-DB] 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: [PHP-DB] 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: [PHP-DB] 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