PHP - Sessions For Region Selector

hey guys   Doing last bit of site now and after doing full testing I found 1 little bug that I don't like

I created an appointment section with a table to display resuilts from mysql, works great, but add more than 1 appiontment and its almost adding a whole new page

See attachment for pic

Heres the code for the table

<?php  echo '<h2>Customer Appointments</h2>'; ?>
</span></div><table width="1248" border="3" align="center">
  <tr class="new">
           <td width="116" class="re" style="text-align: center"><strong>Date Booked</strong></td>
           <td width="96" class="re" style="text-align: center"><strong class="table">Time Booked</strong></td>
           <td width="823" class="re" style="text-align: center"><strong class="table">Notes</strong></td>
  </tr>
         <?php do { ?>
           <tr class="table">
             <td class="re" style="text-align: center; color: #FFF;"><?php echo $row['datebooked']; ?></td>
             <td class="re" style="text-align: center"><?php echo $row['timebooked']; ?></td>
             <td class="re" style="text-align: center"><?php echo $row['notes']; ?></td>
  </tr>
           <?php } while ($row = mysql_fetch_assoc($Recordset1)); ?>
</table>
          <span class="re">
          <?php

Is there anyway I can make the Titles: Date Booked, Time Booked, Notes and have all results showing directly underneath? Attached Files  success.JPG   31.29KB   0 downloads

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=316681.0

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=312305.0

I am using Dreamweaver CS4 to build a website. On my contact page, I made a form with spry validation. I used a tutvid tutorial to learn a simple form handler script (I'm a complete newb at PHP) and everything works great. The only problem I'm having is, in my Dreamweaver template, I have an editable region that has the form. When  the user clicks to submit the form, a new html page opens up that looks nothing like my website.
What I'm trying to accomplish is having the form disappear and be replaced in the same editable region with my "thank you" message. This way, the user just submits, the form disappears, and they get a thank you message on the same page, in the same place where the form was.

Here is the form code:

Code: [Select]
<form id="frmContact" name="frmContact" method="post" action="contact_form.php">
     <fieldset><legend>Submit a question or comment...</legend>
     
       <p>
         <label for="name">Name:</label>
         <span id="spryName">
         <input type="text" name="name" id="name" />
         <span class="textfieldRequiredMsg">Name is required.</span><span class="textfieldMinCharsMsg">Must have at least 3 characters.</span><span class="textfieldMaxCharsMsg">Must not exceed 20 characters.</span></span></p>
       <p>
         <label for="email">Email:</label>
         <span id="spryPassword">
         <input type="text" name="email" id="email" tabindex="10" />
         <span class="textfieldRequiredMsg">Email address is required.</span><span class="textfieldInvalidFormatMsg">Not a valid email address.</span><span class="textfieldMinCharsMsg">Not a valid email address.</span><span class="textfieldMaxCharsMsg">Not a valid email address.</span></span></p>
       <p>
         <label id="message" for="question">Please tell us how we can help you:</label><br />
         <span id="spryText">
         <textarea name="question" id="question" cols="45" rows="5" tabindex="20"></textarea><br />
         <span class="textareaRequiredMsg">A question or comment is required.</span><span class="textareaMinCharsMsg">Must have 16 characters minimum</span><span class="textareaMaxCharsMsg">Must not exceed 500 characters.</span></span></p>
       <p>
         <input type="submit" name="submit" id="submit" value="Submit" tabindex="30" />
       </p>
     </fieldset>
     </form>

Here is the PHP script:

<?php

/* Subject and Email variables */

$emailSubject = 'Contact Form Response';
$webMaster = 'centerline.computers@gmail.com';

/* Gather Data variables */

$nameField = $_POST['name'];
$emailField = $_POST['email'];
$questionField = $_POST['question'];

$body = <<<EOD
<br><hr><br>
Name: $nameField <br>
Email: $emailField <br>
Message: $questionField <br>
EOD;

$headers = "From: $emailField\r\n";
$headers .= "Content-type: text/html\r\n";
$success = mail($webMaster, $emailSubject, $body, $headers);


/* Results rendered as HTML */


$theResults = <<<EOD
<html><body>
<h2>Thank you for submitting.</h2>
<p>We will get back to you as soon as possible.</p>

</body>
</html>
EOD;
echo "$theResults";

?>

Thanks for any help you might have for me!

I am trying to create a order history page.

I want it to look something like this:

Ordernumber:  12
Products:
               Product 1
               Product 2
               Product 3
               Product 4
Total:      xx

Ordernumber:  13
Products: 
               Product 5
               Product 6
Total:      xx

and so on.

I have a recordset which get the ordernumbers from my database
and i have another recordset which get the products (this recordset has a WHERE clause which is used to get the products associated with its ordernumber.

Code: [Select]
    mysql_select_db($database_lol, $lol);
    $query_ono = "SELECT DISTINCT ordre.ono FROM ordre WHERE ordre.bruker='{$_SESSION['MM_Username']}'";
    $ono = mysql_query($query_ono, $lol) or die(mysql_error());
    $row_ono = mysql_fetch_assoc($ono);
    $totalRows_ono = mysql_num_rows($ono);
   
    mysql_select_db($database_lol, $lol);
    $query_history = "SELECT ordre.vare FROM ordre WHERE ordre.ono='{$row_ono['ono']}'";
    $history = mysql_query($query_history, $lol) or die(mysql_error());
    $row_history = mysql_fetch_assoc($history);
    $totalRows_history = mysql_num_rows($history);

This is the recordsets.

this is my table:

+-------+---------------------+------+
| ID      | vare                   | ono  |
+-------+---------------------+------+
|       1 | Product 1           |   12 |
|       2 | Product 2           |   12 |
|       3 | Product 3           |   12 |
|       4 | Product 4           |   12 |
|       5 | Product 5           |   13 |
|       6 | Product 6           |   13 |
+-------+---------------------+------+


So my question is: How do i do this? list all the records i mean.
Thanks