[Resolved] How do I Omit 1 Row?

[KuroSatsu]

This is probably a n00bish question. But anyway, I'm integrating a phpbb memberlist into one of my webpages. It's basically a roster of everyone in a gaming clan. However, PHPBB creates an anonymous user which consequently shows up on this roster when I display it.

How do I go about making it so that the query won't display the Anonymous user on my website? Is it possible to replace the text w/ a blank or something?

-Dave

[eoghain]

SELECT *
  FROM MyTable
 WHERE Name != 'Anonymous';

[KuroSatsu]

wow thanks, that worked out real slick. I wonder if there's some kinda website that has all these options written in? Took me forever to find out how to even order/organize what's displayed.

thanks again

-Dave

[eoghain]

Go to the site for you database. Or just search for SQL, there are tons of places that have tutorials on how to use SQL and databases.