Posted by strawberry on 09/13/06 22:05

> OK, just two questions are important to me now.
>
> Can a user on my website submit a form that will automatically be written
> into my MySQL database? Just a yes or no would suffice at this stage.

Yes, but you MUST read up on MySQL injection.

> Can MySQL keep an up to date inventory, by say summing the total contents of
> field "a" in table "one", also summing the total contents of field "b" in
> the same table, and allow field "z" in table "two" to perform the
> calculation such as "a"-"b"="z"?

Well, total manufactured is probably as simple as 'total sold + total
in stock' but I guess it would be fairly straightforward to hold this
info in a separate table if you really wanted to.

[Back to original message]