any suggestions will be greatly appreciated
My first suggestion would be to use a title that has some relevance to the content of the post. In general, the most knowledgeable people are also the busiest, and they don't have time to click through to topics they've no idea if they can help with.
You can infer what you wish from the fact I had time to reply
IIRC, the WP54G is a Linksys card? If so, they've a nasty habit of changing the chipset quite substantially between (and even during) minor revisions. Check which revision you have, at least one has a Linux driver.
Have you tried manually downloading and installing the dependencies? I'd imagine Yum has a feature to simplify this.