Search the Community
Showing results for tags 'dg'.
Found 1 result
-
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
