Adjective: The wind's sound made a whistling noise.
Prepositional Phrase: The sound \of the wind made a whistling noise.
On the other hand, adverb prepositional phrases modify a verb, adjective, or adverb. They usually tell when, where, how, why, or to what extent (how many, how much, how long, or how far), and under what condition.
Adjective prepositional phrases can also follow linking verbs; however, this is not very common.
You seem \under the weather. (Under the weather describes you, not how you seem.)
More than one adjective phrase can modify the same noun.
The sound \of the players \from the gym distracted us.