AW: [phplib] the "Group by" Function Problem From: rquinn <email protected>
Date: 11/24/00

If I may (as a newcomer to this list) respond:

I use a slightly modified select statement, in the form of:

SELECT MAX(demo_id) AS MAXDEMOID FROM Match_demo;
echo $db->f("MAXDEMOID");

The Alias does the trick.

- Rich

---------------------
Richard Quinn www.richardquinn.de
rquinn <email protected>

0173 - 664 1468
24h: Voicebox:0180/505254647774 Fax:0180/505254647774

> -----Ursprüngliche Nachricht-----
> Von: Michael Zeidler [mailto:web_style <email protected>]
> Gesendet: Freitag, 24. November 2000 17:01
> An: phplib <email protected>
> Betreff: [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>