I am also a newbie in PHP, but your question is more a MySQL question I
believe... :
$sql = "select max(thread) as thread, max(mesgid) as mesgid from
This MySQL request gives you two informations : the maximum of the values of
the two fields (thread and mesgid) of the table named discussionboard : these
values are then put with $result_row = mysql_fetch_row($result) inside a row
of two values : $result_row[0] and $result_row[1].
I hope that helps you

P.S.: see the site www.mysql.com for more or clearer explanations and also of
course www.php.net


The PHP newbie a écrit :

> Hi,
> I am trying to figure out a part of the PHP code which belongs to one of
> the files that is responsible for operating a discussion group.
> I was examining some of a part of the code which produces the total number
> of messages and displays the subject of the message.
> I encountered a part that looks like this:
> mysql_select_db("discussionboard", $db)
>    or die("Couldnot select database");
> $sql = "select max(thread) as thread, max(mesgid) as mesgid from
> discussionboard";
> $result = mysql_query($sql)
>         or die("Query failed");
> $numrows = mysql_num_rows($result);
> $result_row = mysql_fetch_row($result);
> echo"<center><b>No of topics: $result_row[0]<br>
>                 No of total messages: $result_row[1]</b>
> What I don't understand is how did $result_row become $result_row[0] and
> $result_row[1]?
> Also what does it mean to select max(thread) as thread, max(mesid) as
> mesgid?
> I have never used this "as" command before.
> Thanks for any insight.
> Peter
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to