select top 1 * from table where gender = female order by inserDate DESC On 12/7/05, Mike Belcher <[EMAIL PROTECTED]> wrote: > I though tI would toss this out in case anyone had a better way. What I want > to do is display the newest female member of the sight that has uploaded a > photo on the frontpage. This would change each time new ones join. Basically > I guess I would do a select * where gender = female and there is a > photo............ Order by deSC to put the new ones at the top and then take > the top one off with a reader I guess. That's about as far as I thought > about it. Just tossing it out to see if there are any ideas on a good way to > do this........... > > > > Mike > > > > > > > Yahoo! Groups Links > > > > > > >
------------------------ Yahoo! Groups Sponsor --------------------~--> 1.2 million kids a year are victims of human trafficking. Stop slavery. http://us.click.yahoo.com/WpTY2A/izNLAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
