Getting sum of a column from a table into a textbox

[lindisfarne]

In the code below I can get the total of the column into the field in a table,but how would I go about this if I wanted to get the total into a text box(html).
I tried placing the $total variable into the value attribute of the text box but this didn't work.Any suggestions much appreciated:)

 

$total = 0; // initialise total

while($record = mysql_fetch_array($myData)){
echo "<tr>";
echo "<td>" . $record['id'] . "</td>";
echo "<td>" . $record['author'] . "</td>";
echo "<td>" . $record['title'] . "</td>";
echo "<td>" . $record['publisher'] . "</td>";
echo "<td>" . $record['year'] . "</td>";
echo "<td>" . $record['genre'] . "</td>";
echo "<td>" . $record['sold'] . "</td>";
echo "<tr />";

$total += $record['sold']; // accumulate total
}

echo "<tr><td colspan='6'>Total:</td><td>$total</td></tr>"; // output total

echo "</table>";

 

Kind regards

Lind

[Barand]

Are you referring to an input box of type "text" or a textarea element?

 

If the former then using the value attribute should work.

echo "<input type='text' name='total' value='$total' />";

If you mean the latter then there is no value attribute. The text content goes between the open and close tags

echo "<textarea rows='2' cols='20' name='total'>$total</textarea>";

Basic HTML.

 

And please use code tags, or the "<>" button in the toolbar.

Edited October 13, 2016 by Barand

[cyberRobot]

Side note: In case you are not aware, the mysql_* functions have been removed from the latest version of PHP. You will want to switch to PDO or MySQLi in the near future. More information can be found here:

http://php.net/manual/en/mysqlinfo.api.choosing.php