Syntax question

[Defender1]

if i'm going to get the sum of a bunch of rows, would my query and the php code look like this?

    <?
    $all_link_query = "SELECT sum(counter) from links";
    $do_sum_query = mysql_query($all_link_query, $db_connect);
    $result = mysql_fetch_array($do_sum_query);
    ?>
     <tr>
      <td width="100%">
      <font size="2" face="verdana">There are currently <b><?=$result[counter]; ?></b> links available.

[cupid]

Try this:

<?php
    $all_link_query = "SELECT sum(counter) as blah from links";

    $do_sum_query = mysql_query($all_link_query, $db_connect);
    $result = mysql_fetch_array($do_sum_query);
?>
     <tr>
      <td width="100%">
      <font size="2" face="verdana">There are currently <b><?=$result[blah]; ?></b> links available.

[Defender1]

cool, thx.