Questions tagged [web-assist]

4 questions
3
votes
2 answers

How to insert calculated field into database?

I am inserting multiple records into a database. Many of the fields are consistent, but one field is calculated, and needs to calculate/subtract the value for each record inserted into the database.
Blondie
  • 59
  • 5
0
votes
1 answer

Issues to upload and rename multiple files from the same form

I am currently working on a form that has multiple file uploads (one image and multiple pdfs) with PHP/Mysqli. When I fill it out information are recorded into the database but the name of the files are not renamed and the destination folder called…
Lamine
  • 11
  • 5
-1
votes
1 answer

using row count to create percentage from query

I am trying to create a visual representation of a small survey which has three possible answers in mysqli. I have created three separate recordsets, and then tried to get the record count for each, turning the results into a graphical display. It…
Bill Teale
  • 159
  • 3
  • 15
-2
votes
1 answer

Complete Loop and then Insert if no records are found in any of the queries

When a person submits their payment voucher, I have a query performed on the database to make sure a voucher hasn't already been submitted for the same date and time. If so, an error message appears and the voucher doesn't insert into the database.…
lwaters
  • 19
  • 5