I am also a newbie in PHP, but your question is more a MySQL question I
$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 and $result_row.
I hope that helps you
P.S.: see the site www.mysql.com for more or clearer explanations and also of
The PHP newbie a écrit :
> 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
> $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<br>
> No of total messages: $result_row</b>
> What I don't understand is how did $result_row become $result_row and
> Also what does it mean to select max(thread) as thread, max(mesid) as
> I have never used this "as" command before.
> Thanks for any insight.
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php