Gossamer Forum: Products: Gossamer Links: Development, Plugins and Globals: Re: [Andy] Select Statement (ryel01)

Gossamer Threads

Home : Products : Gossamer Links : Development, Plugins and Globals :

Re: [Andy] Select Statement

Jul 3, 2004, 11:23 PM

ryel01

Veteran (1264 posts)

Jul 3, 2004, 11:23 PM

Shortcut

Re: [Andy] Select Statement In reply to

Hi Andy

Do you know how to get a count from a select statement using the GT code? I've tried a number of different ways but can't figure it out.

What I want to end up with is a $count variable that has a number in it by adapting the following statement.

SELECT count( DISTINCT(Email) ) FROM lsql_Users WHERE ReceiveMail = 'Yes'

regan

Subject	Author	Views	Date
Select Statement	ryel01	3479	Jul 2, 2004, 5:34 PM

Re: [ryel01] Select Statement	Andy	3405	Jul 3, 2004, 1:34 AM

Re: [Andy] Select Statement	ryel01	3394	Jul 3, 2004, 11:23 PM

Re: [ryel01] Select Statement	Andy	3387	Jul 4, 2004, 5:24 AM

Re: [Andy] Select Statement	ryel01	3380	Jul 4, 2004, 5:29 AM

Re: [ryel01] Select Statement	afinlr	3388	Jul 4, 2004, 7:52 AM

Re: [afinlr] Select Statement	ryel01	3382	Jul 4, 2004, 2:09 PM

Re: [ryel01] Select Statement	Alex	3394	Jul 5, 2004, 11:55 AM

Re: [Alex] Select Statement	afinlr	3355	Jul 5, 2004, 3:40 PM

Gossamer Threads is a Vancouver-based company with over 28 years experience in web technology. From development to hosting, we partner with leading organizations around the globe and help to build their web presences, strategies and infrastructures.

Let’s talk: 1-877-715-7676