MySQL Database, PHP Forms etc

  • Posted
  • Proposals 4
  • Remote
  • #4191
  • Expired
Susan S.SM M.Nilay P.Steve Z. have already sent a proposal.
  • 3

Description

Experience Level: Expert
Hello

I want to try and explain this whilst retaining confidentiality of the full details, so please bear with me.

I require a web based database set up which will enable users to input data to 8 fields under 2 categories %u2026 call it, `O` & `W` (4 fields each). A `Matching` process (W against O) needs to be undertaken periodically and then emails sent automatically.

I've done some work on the database, but I%u2019ve stalled on the Matching and Emailing. I%u2019ve also set up the website (easy bit) using a bespoke application which does not allow integration with MySQL Forms etc. The site is hosted with MySQL / PHP support. A link off my web page to a separate `database entry page` may be the easiest way to go, but I%u2019m open to suggestions?

Users would register with email address before they could enter the data.

Lets say we have 2 users Jack & Jill. If Jack%u2019s qty 4 `O` entries match Jill%u2019s qty 4 `W` entries then Jill would be emailed with Jack%u2019s email address. The matching needs to be done on an automatic basis and similarly with emailing, i.e. I don%u2019t want to match or email on a manual basis.

That%u2019s it really, simple or what? You tell me?

Cheers
Graham

Clarification Board

    There are no clarification messages.