Changing a Field in a Database Table

I need to calculate a capital and put the information inside of a table, but something doesn't work well, can you help me.what i try to do is to calculate when final capital will be equal to the initial one and secondly the intereste slow down eatch year. so with out any table i have no problem , but i can not make work the table, i don't know what i need to do.

Expand|Select|Wrap|Line Numbers

 
<html><head><title>calcul du capital</title></head>

<body bgcolor="#ffcc99">

<h1>Calcul du capital</h1>

<?php

$capital_initial=100;

$taux_initial=2.5;

$capital_final=1000;

$annees=2007;
 
print "<h2>Tableau de l'évolution du capital</h2><BR>";
 
$capital=$capital_initial;

$taux=$taux_initial;

 echo "<TABLE BORDER='1'>";

  echo "<tr><td>annees</td><td>taux d'interet</td><td>capital</td></tr>";
 
while ($capital<$capital_final)

{
 
echo"<TR>";

$capital=$capital*(1+$taux/100);

echo"<TR>"

for($i=0,$i<???,$i++){

echo "<tr><td>".$row["annees"]."</td><td>".$row["taux"]."</td><td>".$row["capital"]."</td></tr>;

   }

$annees=$annees+1

$taux=$taux-.1    
 
   echo "</TABLE>";

 }

?>

thanks

Jun 15 '07 #1

Subscribe Post Reply

1158

webshzu

The code below will create table output for you. With your orignal code you would never see the output because the criteria to complete the "while" statement is never met. The interest rate became negative before capital exceeded capital_final, which then caused the value of capital to decrease.

So I made a few changes in your formula just to show you the table results.

Expand|Select|Wrap|Line Numbers

 
<body bgcolor="#ffcc99">

<h1>Calcul du capital</h1>

<h2>Tableau de l'évolution du capital</h2>

<TABLE BORDER='1'>

<tr>

    <th>annees</th>

    <th>taux d'interet</th>

    <th>capital</th>

</tr>
 
<?php 

    $capital_initial=100;

    $taux_initial=2.5;

    $capital_final=120;

    $annees=2007;

    $capital=$capital_initial;

    $taux=$taux_initial;

    echo "capital = " . $capital . "<br />taux = " . $taux . "<br />capital_final = " . $capital_final;
 
    while ($capital < $capital_final) {

?>

        <tr>

            <td>

                <?php echo $annees; ?>

            </td>

            <td>

                <?php echo $taux; ?>

            </td>

            <td>

                <?php echo $capital; ?>

            </td>

        </tr>

<?php

    $capital=$capital*(1+($taux/100));

    $annees=$annees+1;

    $taux=$taux-.1;

    }

?>

</TABLE>

</body>

Jun 15 '07 #2

pbmods

5,821

Expert 4TB

Heya, Stephan. Welcome to TSDN!

What is your code doing? What is it supposed to be doing?

P.S., Changed thread title. We know it's a PHP problem; that's why you posted it in the PHP forum :)

Jun 17 '07 #3

by: Peter | last post by:

Can anyone tell me how to change the data type of a field in a table created with a make table query? The field is a binary and must be changed to text. alternately does anyone know how to specify...

Microsoft Access / VBA

Replacing data in a table WITHOUT changing the numbers created from a running sum..

by: StenKoll | last post by:

Help needed in order to create a register of stocks in a company. In accordance with local laws I need to give each individual share a number. I have accomplished this by establishing three tables...

Microsoft Access / VBA

Changing field types with Excel as linked table

by: me here | last post by:

I have a VBA subroutine that links an MS Excel spreadsheet and copies the data into a local table. This process is controlled by a form that allows users to select the spreadsheet from the file...

Microsoft Access / VBA

changing field names

by: Michael | last post by:

Hi everyone, I am trying to change the field names for a table that is being exported via Excel. Its a spreadsheet that our National Office sends us but even after promise after promise they...

Microsoft Access / VBA

copying and changing fields to another table can you change description at this time?

by: sparks | last post by:

I was copying fields from one table to another. IF the var name starts with milk I change it to egg and create it in the destination table. It works fine but I want to copy the description as...

Microsoft Access / VBA

Changing query to access different tables

by: Marizel | last post by:

I'm not sure there's an easy solution to this, but thought I'd ask. I often find myself with a query which I'd like to reuse, but with a different datasource. These datasources generally have...

Microsoft Access / VBA

changing field data types programmatically

by: David Gartrell | last post by:

Hi i'm trying to import an Excel Spreadsheet into Access2000 but the data types for two of the fields in my imported table are being identified incorrectly. Is there a way of using some VB code in...

Microsoft Access / VBA

Programmatically changing RecordSource - too risky?

by: deko | last post by:

I have a popup form with a textbox that is bound to a memo field. I've been warned about memo fields so I'm wondering if I should use this code. Is there any risk with changing the form's...

Microsoft Access / VBA

Changing Switchboard Textbox Title Via Text Document

by: mplus_2000 | last post by:

I have recently inherited a database. The switchboard (and other forms) displays the name of the database on it (top, center). Currently the name that appears is Reviews. There are plans to roll...

Microsoft Access / VBA

Changing the standard "week"

by: sbaird | last post by:

Aloha from Hawaii, I'm beating my head on the wall here. I have a recruiting contact managment database I'm trying to create. Managers (there ar 14 of them) have to make a certain number of...

Microsoft Access / VBA

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Changing a Field in a Database Table

Similar topics