Query Request

[Rose]

This isn't really a hack request, but I couldn't decide on which forum would be the most appropriate, but as this is a "request", I stuck it in here. :nervous:

Many of my members have "http://www./" entered as their homepage. I'm not sure why, but to prevent future instances I have installed N9ne's "default homepage" hack.

However, for those members that have already registered, the value hasn't changed, obviously. Is there a way to run an UPDATE query or something in phpmyadmin that will allow all the values of "http://www./" changed to "http://www.mydefaultsite.com"?

:rambo: Thanks in advance!

[Xenon]

php forum would have been right ;)

UPDATE user SET homepage='http://www.mydefaultsite.com' WHERE homepage='http://www./'

[Rose]

Originally posted by Xenon
php forum would have been right ;)




Interestingly enough, I was in the PHP forum first. *hehe* :$

edited to say - Nevermind. Dunno what the error was that I originally got, but I've got it fixeded up. ;) But, the query didn't seem to have any effect on the current homepages.

[Xenon]

the query has an effect, but you have to be sure that the hompage is exactly like that.

is the last / really there?

if not use this:

UPDATE user SET homepage='http://www.mydefaultsite.com' WHERE homepage='http://www.'

[Rose]

Originally posted by Xenon
the query has an effect, but you have to be sure that the hompage is exactly like that.

is the last / really there?

if not use this:

UPDATE user SET homepage='http://www.mydefaultsite.com' WHERE homepage='http://www.'


There we go. That did the trick. :D

The last "/" was showing up when I did a mouseover the button and when I clicked "properties" on it, too. :s But whether real or no, this worked! Thanks a million. :D

[Xenon]

:)
you're welcome :)