Playing with my curve trying to dowload movies I mistakenly hit "ok" when prompt to delete memory card

When I synch at work, will I get my pictures, music and videos back?

No, the memory card is separate from sync, etc. If you deleted it, it's gone.

You can use your card adapter and put it in a card reader on your computer and use recovery software to get anything that was on your card back.