MatthewFriedman

I trying to write a custom php web interface with my existing website so that potential customers and sign up to recieve our news letter. I have created a database with fields for email address, name, mailing address, and interests and subscriber status. customers do not have a problem coming to the website and signing up, however, I have also written an unsubscribe. where a customer may go to a different page, enter their email address, and the database scrip performs a search, finds their record based on the unique email address and automatically switches the subscriber status to "do not contact". I can not execute a search with the full email address in it, and it seems to be because of the @ symbol. however i have noticed that I can remedy this by doing searching with quotations like "blank@blank.com" and it will properly return a record for that email address. is there a way to do this without using the quotations, and if not, how do i write a find script to take the regularly entered email address and transform it to the email address with quotes around it an then execute the search.

OK, I have muddled through this project so far putting together an entire client and staff admin database, and I am working on payroll functionality. I have a table used to record hours and dates worked. I have another related table to house employee information. these tables are related by a common employee ID number. I have set up a portal in the employee info table and I am trying to make a calculation to automatically break down total hours worked by month in a summary field for each respective month on the employee info table via the timecard portal. I do not want a running total, I want 12 subtotals one for each month. IE I want the hours worked in jan to be totaled in the jan summary field the ones worked in feb to be totaled in feb summary field and so on without having to limit the records displayed in the portal. I have thus far been unsuccessful in accomplishing a formula to discriminate info based on date from my portal does anybody have the knowledge to help me accomplish this?