>>MySQL QUEEERY help yo - GoFuckYourself.com - Adult Webmaster Forum

X

Juicy D. Links

So Fucking Banned

Join Date: Apr 2001

Posts: 122992
Share

Post
#1

>>MySQL QUEEERY help yo

07-16-2004, 09:22 AM

Check it out

I got galleries in a table

jg_galleries

in that table the main domain url is domainA.com

Can i so some fancy sql shit to replace doaminA.com with domainB.com in one queeeeery?
Tags: None
grumpy

Too lazy to set a custom title

Join Date: Jan 2002

Posts: 9870
Share

Post
#2

07-16-2004, 09:24 AM

update table set fieldname="something" where fieldname="something"

Don't let greediness blur your vision | You gotta let some shit slide
icq - 441-456-888
Comment
Juicy D. Links

So Fucking Banned

Join Date: Apr 2001

Posts: 122992
Share

Post
#3

07-16-2004, 09:24 AM
Comment
creegan

Confirmed User

Join Date: Jun 2004

Posts: 223
Share

Post
#4

07-16-2004, 09:25 AM

why not do it after the query, like as you're looping stuff out

$string=str_replace("domainA.com", "domainB.com", "$query_result");

gfy'ers remind me of the causeheads from pcu
Comment
pornstar2pac

Omaha Hi/Lo

Join Date: Nov 2003

Posts: 17380
Share

Post
#5

07-16-2004, 09:25 AM

If you go 7-11 today, bring me back some slim jims.

and some pop rocks

Trump haters gonna hate. that's all they can do
Comment
Viper2K1

Confirmed User

Join Date: Aug 2001

Posts: 1006
Share

Post
#6

07-16-2004, 09:25 AM

update jg_galleries SET fieldyouuseforthedomain="
domainB.com" where fieldyouuseforthedomain="domainA.com";

Spank me
Dude, where's my traffic?
Comment
creegan

Confirmed User

Join Date: Jun 2004

Posts: 223
Share

Post
#7

07-16-2004, 09:26 AM

or you could do update, i figured that domaina.com was in the db for a reason though

gfy'ers remind me of the causeheads from pcu
Comment
Juicy D. Links

So Fucking Banned

Join Date: Apr 2001

Posts: 122992
Share

Post
#8

07-16-2004, 09:27 AM

cool cool

Let me back up the db then try thanks for the help
Comment
grumpy

Too lazy to set a custom title

Join Date: Jan 2002

Posts: 9870
Share

Post
#9

07-16-2004, 09:28 AM

Originally posted by Viper2K1
update jg_galleries SET fieldyouuseforthedomain="
domainB.com" where fieldyouuseforthedomain="domainA.com";

Thats what i said :-)

Don't let greediness blur your vision | You gotta let some shit slide
icq - 441-456-888
Comment
Viper2K1

Confirmed User

Join Date: Aug 2001

Posts: 1006
Share

Post
#10

07-16-2004, 09:38 AM

Originally posted by grumpy
Thats what i said :-)

saw that after i made my post, i type kinda sloooow hehe

Spank me
Dude, where's my traffic?
Comment
Due

Confirmed User

Join Date: Mar 2001

Posts: 3620
Share

Post
#11

07-16-2004, 09:54 AM

This might be what you are looking for:

$searching="FIND-THIS";
$replace="REPLACE-WITH-THIS";

$res = mysql_query("SELECT * FROM jg_galleries WHERE url LIKE '%$searching%'");
while($row = mysql_fetch_array($res)) {
$surl++;
$my_id[$surl] = $row[id];
$my_thumb[$surl] = $row[url];
}

while($y<$surl){
$y++;
$newurl[$y]=str_replace("$searching", "$replace", $my_thumb[$y]);
$query = mysql_query("UPDATE jg_galleries SET url='$newurl[$y]' WHERE id='$my_id[$y]'") or print mysql_error();
}

I buy plugs
Skype: Due_Global
/Due
Comment
Due

Confirmed User

Join Date: Mar 2001

Posts: 3620
Share

Post
#12

07-16-2004, 09:56 AM

replace { with the opening of character for }

I buy plugs
Skype: Due_Global
/Due
Comment
woj

<&(©¿©)&>

Join Date: Jul 2002

Posts: 47882
Share

Post
#13

07-16-2004, 10:58 AM

Originally posted by Due
This might be what you are looking for:

$searching="FIND-THIS";
$replace="REPLACE-WITH-THIS";

$res = mysql_query("SELECT * FROM jg_galleries WHERE url LIKE '%$searching%'");
while($row = mysql_fetch_array($res)) {
$surl++;
$my_id[$surl] = $row[id];
$my_thumb[$surl] = $row[url];
}

while($y<$surl){
$y++;
$newurl[$y]=str_replace("$searching", "$replace", $my_thumb[$y]);
$query = mysql_query("UPDATE jg_galleries SET url='$newurl[$y]' WHERE id='$my_id[$y]'") or print mysql_error();
}

there is NO reason at all to do this, when a simple
"UPDATE x SET y WHERE z" query will do just as well...

Custom Software Development, email: woj#at#wojfun#.#com to discuss details or skype: wojl2000 or gchat: wojfun or telegram: wojl2000
Affiliate program tools: Hosted Galleries Manager Banner Manager Video Manager
Wordpress Affiliate Plugin Pic/Movie of the Day Fansign Generator Zip Manager
Comment
JSA Matt

So Fucking Banned

Join Date: Aug 2003

Posts: 5464
Share

Post
#14

07-16-2004, 11:01 AM

Did you solve this yet? What do the entries look like?

Are they like:
http://www.domainA.com/

or more like

http://www.domainA.com/gallery1/index.html

?
Comment
Due

Confirmed User

Join Date: Mar 2001

Posts: 3620
Share

Post
#15

07-16-2004, 12:52 PM

Originally posted by woj
there is NO reason at all to do this, when a simple
"UPDATE x SET y WHERE z" query will do just as well...

Actually there is.
Else "y/gallery/whatever/213423.html" will just be replaced with "x" when it should have been "x/gallery/whatever/213423.html"
I asume he have 100's or 1000's of galleries saved on 1 domain that need to be updated to be on another domain.

I buy plugs
Skype: Due_Global
/Due
Comment
Juicy D. Links

So Fucking Banned

Join Date: Apr 2001

Posts: 122992
Share

Post
#16

07-16-2004, 12:59 PM

Originally posted by JSA Matt
Did you solve this yet? What do the entries look like?

Are they like:
http://www.domainA.com/

or more like

http://www.domainA.com/gallery1/index.html

?

like this

http://www.domainA.com/gallery1/index.html
Comment
creegan

Confirmed User

Join Date: Jun 2004

Posts: 223
Share

Post
#17

07-16-2004, 01:02 PM

Originally posted by woj
there is NO reason at all to do this, when a simple
"UPDATE x SET y WHERE z" query will do just as well...

unless you plan on expanding your affiliate program with more sites and more hosted galleries, and need to generate the data on the fly

gfy'ers remind me of the causeheads from pcu
Comment
M_M

Confirmed User

Join Date: May 2004

Posts: 1167
Share

Post
#18

07-16-2004, 01:03 PM

Originally posted by Due
Actually there is.
Else "y/gallery/whatever/213423.html" will just be replaced with "x" when it should have been "x/gallery/whatever/213423.html"
I asume he have 100's or 1000's of galleries saved on 1 domain that need to be updated to be on another domain.

UPDATE tablename SET fieldname = REPLACE(fieldname,'domainA','domainB')

u gotta study more my man

;-)!;-)!;-)!;-)!;-)!;-)!;-)!;-)!;-)!;-)!;-)
Comment
Due

Confirmed User

Join Date: Mar 2001

Posts: 3620
Share

Post
#19

07-16-2004, 01:44 PM

Originally posted by M_M
UPDATE tablename SET fieldname = REPLACE(fieldname,'domainA','domainB')

u gotta study more my man

Well I just posted a search and replace script I made a few months ago.
Got nothing to do with if I need to study more or not.
The original search and replace script contained a lot more functions that included updating other tables for some of the results depending on what was returned from the first result.
So a simple replace wouldn't be good enough for what I needed it for.

I buy plugs
Skype: Due_Global
/Due
Comment
SlickCash Sarah

Confirmed User

Join Date: Feb 2004

Posts: 2055
Share

Post
#20

07-16-2004, 01:45 PM

This thread reminds me of this..

asdlfkjasd;lfhspdfhglgpoighgpowigwekjhwoeigjkwe

Like Chinese to me.
Comment
M_M

Confirmed User

Join Date: May 2004

Posts: 1167
Share

Post
#21

07-16-2004, 01:46 PM

Originally posted by Due
Well I just posted a search and replace script I made a few months ago.
Got nothing to do with if I need to study more or not.
The original search and replace script contained a lot more functions that included updating other tables for some of the results depending on what was returned from the first result.
So a simple replace wouldn't be good enough for what I needed it for.

excuses, excuses

j/k

;-)!;-)!;-)!;-)!;-)!;-)!;-)!;-)!;-)!;-)!;-)
Comment
fusionx

Confirmed User

Join Date: Nov 2003

Posts: 4618
Share

Post
#22

07-16-2004, 01:48 PM

Originally posted by M_M
UPDATE tablename SET fieldname = REPLACE(fieldname,'domainA','domainB')

Assuming the DB is mySql, which it probably is
Comment
Tom_PMs

Confirmed User

Join Date: Jun 2004

Posts: 2049
Share

Post
#23

07-16-2004, 01:50 PM

Oh then Sarah, you'll appreciate this actual copy and paste from Perl documents.

If you fork without ever waiting on your children, you will accumulate zombies.

My favorite!

You've read it, you can't unread it.
Comment

Previous template Next

Working...