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

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

 



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


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

  Powered by Linux