phppup

As long as I'm logged in (although this may be more to the topic of 'table structure'), my table has fields for small, medium, and large blue candles and small, medium, and large pink candles. When an order is placed, the quantity requested is INSERTED into the correct field. Am I creating unnecessary overhead? Is there a way to have just one field for blue candles and one for pink, whereby the INSERT will record a customer request for 4 candles that are the small size? And how would I retrieve the data when I want to know both the total number of candles and their sizes. Note: the order form has radio buttons for the sizes, so a single order can only accept a single size per submission. Not sure if there's a simple way around that, but I'm learning more each day. Thanks in advance.

Details: Working for a company that sells candles in packages of 1,2,3,4,5 and 6. Their website is set, and their database is adequate. Situation: I need to be able to breakdown large orders for efficient packaging. So, if a customer orders twelve candles, I could transpose the order into 2 six-packs. If the order were for sixteen candles, the order would transpose to 2 six-packs and 1 four-pack. Always using the largest sized sets possible. Do NOT want an order for 12 being assembled as 3 fours or 4 threes, as it is inefficient. Can the quantity be INSERTED into the table accordingly, or does it need to be inserted as 16 (for example) and then broken down afterward?? I am not sure whether I can do this in PHP or if a JavaScript is better. Obviously, i need to divide the largest orders by six, but not sure how to get that number, and how to incorporate the remainder. Please help. i used to have a stress ball.... ya know, those rubbery things for you to squeeze and throw to AVOID real damage, but I broke it!

Some attendees submitted duplicate (but identical) information into the form in order to obtain more than one ticket, so they occuppy several record lines. However, I only need to send ONE email to that person. How can I filter through the records to make sure that only one email is sent even though the same email address may have been entered several times, so that I eliminate duplication? In other words, to send ONE email to each UNIQUE address.

Yes, very generic and I apologize. It's probably due to my novice status. I've searched websites and bookstores and it seems that authors write volumes on the cars performance ability, but never show you where to put the key or which way to start the ignition. I don't have a preference as to where I run the script (probably because I haven't had the initial experience foro comparison yet). I know that I'm not trying anything too complicated. The alternative I considered was to create an HTML form (in a hidden file). This would give me a SUBMIT button to act as my "on switch" to get the ball rolling. Is this my simplest solution? Can I place the file in my FTP with the website, use a particular extension, double click, and have my operation underway? Many thanks for your help.

Yes. I've seen the database information. So now if I write a script, where do I place it and how do I get it to run so that it performs the desired function?

I have a database with three fields: name, email, and event. People signed on through a form and provided this information each time they wanted a ticket to attend Thanksgiving, Christmas, and New Years parties. Now I want to contact them by email WITHOUT using a CC or BCC function because I do NOT want my messages filtered as spam. How can I send each person a single email?

The form I have is on a website that is hosted by a third party that provides MySQL as an option. I've been gathering data on their server, and now want to access it through the simplest way possible to sort rresults.

I've been using a PHP form to post to MySQL. Now that I've begun to build a database, I'm ready to sort some data. I've seen references to building scripts and then running them. But EXACTLY how do i RUN the script to get results. Do I create an icon in my ftp files and double click it? Do I need to create a form and hit the submit button?? I'm sure there's a simple answer, but I don't know it. Please teach me.