Hi,
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
discussionboard";
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
SR
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
