Re: [phplib] the "Group by" Function Problem From: Jesse Swensen (swensenj <email protected>)
Date: 11/24/00

Try:
SELECT MAX(demo_id) some_alias FROM Match_demo;

And then

$db->f("some_alias") 

-- 
Jesse Swensen
swensenj <email protected>

> From: Michael Zeidler <web_style <email protected>>
> Date: Fri, 24 Nov 2000 17:01:22 +0100
> To: phplib <email protected>
> Subject: [phplib] the "Group by" Function Problem
> 
> Hi my friends,
> 
> this problem is rather a MySQL Statement problem than a phplib problem.
> But I want to use the $db->f() function :))).
> 
> When I want to get the highest value of a column of a table the following
> statement would return the right output on the mysql-client.
> 
> SELECT MAX(demo_id) FROM Match_demo;
> 
> But how can I get a useable result returned as a row that I can get the
> highest value of
> column by using the $db->f("demo_id") function ???
> 
> The statement above doesnt return a row, so the f()-functione wouldn´t fit
> here !
> 
> Thank you for help !
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: phplib-unsubscribe <email protected>
> For additional commands, e-mail: phplib-help <email protected>
> 
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>