Fetch array, display and update, all in one.. ?

Hi All,

I have designed a debit-system database with a PHP frontend. The amounts
need to be updated on a monthly basis. now i have 10 clients in the system.
i can get all the fields and display them, but next to that, i need to
insert a field where we can enter an amount per client and after all the new
amounts have been filled in, i need to update the database with those
amounts entered.

I know that by using html forms to enter the info, i can submit the info and
do a update statement but the problem is, is that i need to dynamically add
the field to update the amount according to the amount of results resturned
from the database...

Hope you guys understand what i mean here... !


GM.

[Average_Joe]

In article <ch6r53$ed4$1@ctb-nnrp2.saix.net>, <post@gam.co.za> wrote:

> Hi All,
>
> I have designed a debit-system database with a PHP frontend. The amounts
> need to be updated on a monthly basis. now i have 10 clients in the system.
> i can get all the fields and display them, but next to that, i need to
> insert a field where we can enter an amount per client and after all the new
> amounts have been filled in, i need to update the database with those
> amounts entered.
>
> I know that by using html forms to enter the info, i can submit the info and
> do a update statement but the problem is, is that i need to dynamically add
> the field to update the amount according to the amount of results resturned
> from the database...
>
> Hope you guys understand what i mean here... !

If by "amount of results" you are refering to a row count, you could try:

mysql_num_rows() ?

If you mean a sum, you might be able to do something like:

SELECT SUM(field) FROM tbl ...

I'm not quite sure I understand the problem.

Jamie

--
[url]http://www.geniegate.com[/url] Custom web programming
User Management Solutions Perl / PHP / Java / UNIX

Hi All,

I have designed a debit-system database with a PHP frontend. The amounts
need to be updated on a monthly basis. now i have 10 clients in the system.
i can get all the fields and display them, but next to that, i need to
insert a field where we can enter an amount per client and after all the new
amounts have been filled in, i need to update the database with those
amounts entered.

I know that by using html forms to enter the info, i can submit the info and
do a update statement but the problem is, is that i need to dynamically add
the field to update the amount according to the amount of results resturned
from the database...

Hope you guys understand what i mean here... !

GM.

[Erwin Moller]

Hi [email]post@gam.co.za[/email]

If you want a response, better post to 1 group at a time.

I responded in this group alone so I don't annoy all the others.
I am curious if you find this answer.

Tip: Post to comp.lang.php in the future. Very active. :-)

To your question: No I do not understand what you mean.
Actually I have a few ideas what you *could* mean, but that doesn't help.
Sorry.

Regards,
Erwin Moller

Hi Erwin,

Thanx for the reply and my apologies for posting to multiple lists.

Actually, all that needs to happen here :-

i have a table with 300 entries of client account numbers and amounts. they
need to be updated on a monthly basis. when i get the results from the
database i need to add a field in php to update the existing amount. i.e.
one field per row to add a new amount and update the database with the new
amount.

Hope this helps.


Regards, Gawie.


"Erwin Moller"
<since_humans_read_this_I_am_spammed_too_much@spam yourself.com> wrote in
message news:413dc88e$0$78738$e4fe514c@news.xs4all.nl...

> Hi [email]post@gam.co.za[/email]
>
> If you want a response, better post to 1 group at a time.
>
> I responded in this group alone so I don't annoy all the others.
> I am curious if you find this answer.
>
> Tip: Post to comp.lang.php in the future. Very active. :-)
>
> To your question: No I do not understand what you mean.
> Actually I have a few ideas what you *could* mean, but that doesn't help.
> Sorry.
>
> Regards,
> Erwin Moller
>
>
>

[Erwin Moller]

Hi [email]post@gam.co.za[/email]

Sorry for very late response, I was in hospital for some time. :-(
Better now. :-)

Do you stillneed help or did you fix it yourself in the meantime?

Regards,
Erwin