OK..another amber goodie question....

[amber438]

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]

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]

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]

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

[DangerDave]

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]

|smooch| |smooch| |smooch| |smooch| |smooch| |smooch|

thank you so much

it worked!!