Posted by bobkaku on 09/20/05 07:12

Steve,

Thanks so much. Your solution works like a charm!


Steve wrote:
> > $query = "select max(qno) from answers";
> > $result = mysql_query($query);
>
> > $maxqno = mysql_result($result);
>
> > $nextqno = $result + 1;
>
> mysql_result() needs a minimum of two arguments: resource and row
> number.
>
> Alternatively, use an alias for the aggregate column and get it by
> name:
>
> $query = "select max(qno) as maxqno from answers";
> $result = mysql_query( $query );
>
> $row = mysql_fetch_array( $result, MYSQL_ASSOC );
> print $row[ 'maxqno' ];
>
> ---
> Steve

• Next in forum: Re: installation, debugging
• Prev in forum: Re: instantiating an object fails (design patterns)
• Thread view: Re: mysql_fetch for aggregate SQL function

[Reply to this message]