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[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

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

Reply via email to