title: Wedding website RSVP database
body: <p>I am creating a wedding website for my brother, and one of his requirements in that the user can go onto a page titled 'RSVP'.</p>
  
  <p>Once on the 'RSVP' page, the user will be presented with a simple form:</p>
  
  <pre><code>First Name | Surname
  Email | Phone Number
  Attending the Wedding? (drop down box with options yes | no)
  </code></pre>
  
  <p>Once the user clicks submit it will do one of two things. </p>
  
  <p>If the user select <code>'no'</code> to the option <code>'Attending the Wedding?'</code>, then send the information to the database, display it in a table and send an email to my brother telling him that this person has filled out the form and that they will not be coming to the wedding.</p>
  
  <p>However, if the user clicks <code>'yes'</code> to the option <code>'Attending the Wedding?'</code> than they will be asked further questions about where they are staying etc. Upon submitting that information the details will need to be stored in the database, represented in a <code>table</code> and sent to my brother via email informing him that this person in coming and there answers to the other questions.</p>
  
  <p>I am going to be using PHP and MySQL for this project, MySQL for the database queries and other database work and PHP for the Form processing etc`.</p>
  
  <p>Could anyone provide me with a start to finish step by step guide as to how they would tackle this so my brother can have this fantastic aspect to his wedding website.</p>
  
  <p>My thoughts so far are:</p>
  
  <ol>
  <li>Create HTML table/form
  (I'm confident with this, will be able to make drop down box and form etc.)</li>
  <li>If user selection = no, store in database, display in table, email brother. 
  (Will be able to do if function but not able to store it in the database and email brother results. Will be able to display results in table.)</li>
  <li>If user selection = yes, ask more questions about where they are staying, upon submission of there answers to the second round of questions, store in database, display in table, email brother. 
  (Will be able to do <code>if</code> function and display the second round of questions but not able to store it in the database and email brother results. Will be able to display results in table.)</li>
  </ol>
  
  <p>If I'm missing anything please inform me, i.e. any steps, vital information I have left out etc. </p>
  
  <p>So what I am looking for is, <em>your</em> step by step approach to this, and some links, material that would help me with the parts I identified I would need some help on, i.e. storing the users responses in the database and email the results to my brother.</p>
  
  <p><em><strong>P.S., I'm not looking for people to code this for me, I'm just looking for peoples ideas on how they would approach this</em></strong>.</p>