OK..another amber goodie question....

amber438 · 2004-04-09, 05:01 PM

Does anyone know how to play with phpmyadmin?
i mass added some links today..it's kinda complicated with my script cause if you have one | in the wrong place, it gets screwed up..
so, I have about 300 links from DMOZ with an addition date of 12/31/1969. cute, huh?? ok, my a dummie..
I wanted to just delete em all, fix the text file and redo it but I cant seem to figure out how to do an inquirie for the link numbers (I have all the link numbers) and I can't mass delete in my script..what a pain in the butt..
if anyone knows, it would be a great help

amber438 · 2004-04-10, 10:32 AM

ok..here I sit..editing each frigging entry in phpmyadmin one at a time..but at least I figured out how..and made the server admin install the new phpadmin so I could edit in tables!! so..if anyone know how to edit a complete table in phpmyadmin, would surely be a help
happy easter

Cleo · 2004-04-10, 10:38 AM

I've had the same problem, not that I have an answer.

I've actually thought of doing a dump and then using a text editor on the dump. So far I haven't been brave enough to try this.

amber438 · 2004-04-10, 10:44 AM

I actually did a dump, looked at it and said screw it..I'll do it by hand to Rammenstein..lol..

DangerDave · 2004-04-10, 04:31 PM

Amber,

If all the link have a common date and no other links do.. you should be able to use..

DELETE FROM YOUR_TABLE_NAME
WHERE Date LIKE '%YOUR_DATE_FORMAT%'
;

DD

amber438 · 2004-04-11, 09:25 AM

thank you so much

it worked!!

2004-04-09, 05:01 PM	#1
amber438 Whatever don't kill ya makes ya stronger... Join Date: Apr 2003 Location: New York Posts: 820	OK..another amber goodie question.... Does anyone know how to play with phpmyadmin? i mass added some links today..it's kinda complicated with my script cause if you have one \| in the wrong place, it gets screwed up.. so, I have about 300 links from DMOZ with an addition date of 12/31/1969. cute, huh?? ok, my a dummie.. I wanted to just delete em all, fix the text file and redo it but I cant seem to figure out how to do an inquirie for the link numbers (I have all the link numbers) and I can't mass delete in my script..what a pain in the butt.. if anyone knows, it would be a great help __________________ Red Hot Links Red Hot Galleries

2004-04-10, 10:32 AM	#2
amber438 Whatever don't kill ya makes ya stronger... Join Date: Apr 2003 Location: New York Posts: 820	ok..here I sit..editing each frigging entry in phpmyadmin one at a time..but at least I figured out how..and made the server admin install the new phpadmin so I could edit in tables!! so..if anyone know how to edit a complete table in phpmyadmin, would surely be a help happy easter __________________ Red Hot Links Red Hot Galleries

2004-04-10, 10:38 AM	#3
Cleo Subversive filth of the hedonistic decadent West Join Date: Mar 2003 Location: Southeast Florida Posts: 27,936	I've had the same problem, not that I have an answer. I've actually thought of doing a dump and then using a text editor on the dump. So far I haven't been brave enough to try this. __________________ Free Rides on Uber and Lyft Uber Car: uberTzTerri Lyft Car: TZ896289

2004-04-10, 10:44 AM	#4
amber438 Whatever don't kill ya makes ya stronger... Join Date: Apr 2003 Location: New York Posts: 820	I actually did a dump, looked at it and said screw it..I'll do it by hand to Rammenstein..lol.. __________________ Red Hot Links Red Hot Galleries

2004-04-10, 04:31 PM	#5
DangerDave Bonged Join Date: Mar 2003 Location: BrisVegas, AUSTRALIA Posts: 4,882	Amber, If all the link have a common date and no other links do.. you should be able to use.. DELETE FROM YOUR_TABLE_NAME WHERE Date LIKE '%YOUR_DATE_FORMAT%' ; DD __________________ Old Dollars >>>> Now with over 90 Hosted Free Sites <<<< DangerDave.com.au - Adult Links to Free Porn

2004-04-11, 09:25 AM	#6
amber438 Whatever don't kill ya makes ya stronger... Join Date: Apr 2003 Location: New York Posts: 820	thank you so much it worked!! __________________ Red Hot Links Red Hot Galleries