Alias the count()
$query = "select count(fld_gender) s sumField from tbl_survey";
$result = mysql_query( $query, $dbConnection );
$aRow = mysql_fetch_array( $result );
print( $aRow["sumField"] );
Joseph E. Sheble
a.k.a. Wizaerd
Wizaerd's Realm
Canvas, 3D, Graphics,
ColdFusion, PHP, and mySQL
http://www.wizaerd.com
=================================
> -----Original Message-----
> From: Chris Adams [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 27, 2001 9:31 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP] count() problem :D
>
>
> On 27 Apr 2001 19:50:04 -0700, Chris Schneck
> <[EMAIL PROTECTED]> wrote:
> >anywho, im having problems getting data out of the count() function i've
> >implemented, could anyone lend a hand?
> >
> > $query = "select count(fld_gender) from tbl_survey";
> >
> >how exactly is it that you output data retrieved from a count()
> >implementation?
>
> The same way you retrieve data from any other query - SQL functions like
> count() or sum() return data in the same fashion as normal,
> non-computed data.
>
> As an example:
> $foo = mysql_query("select count(*) from table");
> echo "Number of records in table: " . mysql_result($foo, 0);
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
