Ext WD500GB drive not being recognised by ...

I may have done sumthin wrong here sumwhere... so i'll try to be as descriptive as possible.. i hav a WD 500GB elements. It was working gr8 until yesterday... the day bfore dat i had copied some vcd's onto it using vista...(dis was a seperate comp, mine has xp) then switched off d comp and disconnected. it was working until i tried to open d vcd files(.dat) on another comp.. also xp. As soon as i tried opening dem, d computer hung and d drive wouldnt open again. Anyway i connected it to the ps3(which can access almost all external media) and it was showing d data.. but was working very slowly.. and wouldnt let me copy large files... and labeled much of d files as corrupt.
i connected it to d comp and i cudnt open it.. d my computer just showed a random drive letter and wen i tried opening it it gave d " the drive cant be accessed due to I/O error" message.
anyway.. dis was still alright.. until d drive hung d the ps3 and i switched it off from d mains... wen i tried to reconnect it to d ps3.. it didnt show d device.. and now wen i connect it to d pc it doesnt show d drive.. but shows it in device manager as a usb mass storage... it even shows it under disk drives as WD. I had a ton of stuff on it.. 350gb's used 108 gb free... i would really appreciate it if u cud think of sumthin.. as i cant possibly get all dat data again
And i did use diff usb ports.. diff comps too.. nuthin works! :(