Re: count...I think

2002-05-30 Thread mos
At 01:24 PM 5/30/2002, you wrote: >Hey guys, >I have a very simple question, I though I knew the answer but the MySql >manual has confused me > >I have a simple select from a database of say...1k records...I use > >select id from myTable where sal>1000; > >Lets say this statement would n

Re: count...I think

2002-05-30 Thread Terrence Cox
the case, PHPBuilder has an article on the topic. Also, if you are OK with using objects, I wrote one for that specific purpose. Let me know, TRC - Original Message - From: [EMAIL PROTECTED] Date: Thu, 30 May 2002 14:24:58 -0400 To: [EMAIL PROTECTED] Subject: count...I think Hey guy

RE: count...I think

2002-05-30 Thread Sander, Ryan
select count(*) from myTable where sal > 1000; Ryan Sander Web Developer [EMAIL PROTECTED] http://cantonrep.com > -- > From: [EMAIL PROTECTED] > Sent: Thursday, May 30, 2002 2:24 PM > To: [EMAIL PROTECTED] > Subject: count...I think > >

count...I think

2002-05-30 Thread r
Hey guys, I have a very simple question, I though I knew the answer but the MySql manual has confused me I have a simple select from a database of say...1k records...I use select id from myTable where sal>1000; Lets say this statement would normally return 132 records, but how do I kn