RE: Count (*) function results needed in echo statement

2003-03-05 Thread John Berman
Renne I did a similar thing with asp, my query was like SELECT COUNT(*) AS countresult, uniqueref FROM global WHERE PROPOSEDRELEASE <= 2002 and SURNAME = '"& globsurname & "' group by uniqueref" Im my asp code I referenced countresult Hope this helps John B -Original Message- Fr

RE: Count (*) function results needed in echo statement

2003-03-05 Thread Stitchin'
Just wanted to let y'all know this worked awesome! Thanks so much! Renee :) -Original Message- From: Sqlcoders.com Programming Dept [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2003 11:20 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Count (*) function results need

Re: Count (*) function results needed in echo statement

2003-03-04 Thread Paul DuBois
At 23:08 -0500 3/4/03, Stitchin' wrote: I've got the following code in my php file: /* Select all categories from designcatagories table */ $query = "SELECT designcatagories.catcode, designcatagories.catdesc, count(*) FROM designs,designcatagories where designs.catcode = designcatag

RE: Count (*) function results needed in echo statement

2003-03-04 Thread Sqlcoders.com Programming Dept
> -Original Message- > From: Stitchin' [mailto:[EMAIL PROTECTED] > Subject: Count (*) function results needed in echo statement > > > I've got the following code in my php file: > > > > /* Select all categories from designcatagories table */ > $query = "SELECT