RE: updating a column based on info from another coluimn ? Desperate!

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Or rawurldecode()?

http://us4.php.net/manual/en/function.rawurldecode.php

> -----Original Message-----
> From: Hutchins, Richard [mailto:Richard.Hutchins@Getingeusa.com]
> Sent: Thursday, 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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux