Re: AW: [phplib] the "Group by" Function Problem From: R.B. Scholtus (regiment <email protected>)
Date: 11/24/00

You forgot:
$db->next_record() or die("No max?!?");

try:
> $query = "SELECT MAX(demo_ID) MAXDEMOID FROM Match_demo";
$db->next_record() or die("No max?!?");
>
> if($db->query($query)){
> $max_rec_id = $db->f("MAXDEMOID");
> my_error("MAXDEMOID : ", $max_rec_id);

Yes -- a very stupid mistake, i make it all the time.

Brian

----- Original Message -----
From: Michael Zeidler <web_style <email protected>>
To: <rquinn <email protected>>; PHPLIB <phplib <email protected>>
Sent: Friday, November 24, 2000 9:23 PM
Subject: Re: AW: [phplib] the "Group by" Function Problem

> Sorry Dudes,
>
> but I have tried the two shown statements :
>
> "SELECT MAX(demo_ID) MAXDEMOID FROM Match_demo"
> "SELECT MAX(demo_ID) AS MAXDEMOID FROM Match_demo"
>
> but $db->f("MAXDEMOID") gives nothing back .... grrrrr
>
> I will show you my code so you maybe see another stupid mistake !?!?!
>
> $query = "SELECT MAX(demo_ID) MAXDEMOID FROM Match_demo";
>
> if($db->query($query)){
> $max_rec_id = $db->f("MAXDEMOID");
> my_error("MAXDEMOID : ", $max_rec_id);
> }
> else{
> if($debug_db)
> my_error($methodname, "Query : $query");
> }
>
>
> RESULT :) -----> Error: MAXDEMOID : :
>
> Am I blind ???
> __________________________________________________________________________
>
>
> At 17:29 24.11.00 +0100, rquinn <email protected> wrote:
> >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>
>
>
> ---------------------------------------------------------------------
> 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>