Many, if not most wireless cards will choke if you put the computer to sleep and then wake it up. A probable cause is that the card loses track of where in the "direct sequence spread spectrum" algorithm it should be when it wakes up. Often, it takes more than a "disconnect then reconnect" action to get these cards to see the network again.
One work around I've seen work well is to manually disconnect from the wireless network before putting the computer to sleep. It isn't just Macs that have this problem, either. I have to log off from my user profile on my WinXP laptop before I put it in Suspend or Hibernate, or it will have the same problem.