Change date format

  • tmd2011

    I have a table on one of my webpages that pulls account information dynamically from a mysql database and includes a date of service (dos) column.  Currently mysql stores dates in the format yyyy-mm-dd, however I would like for the date of service in my table to show in the format mm-dd-yyyy on the actual webpage.  I am wondering if anyone can help me figure out how to convert the date format?  Here is the current code for my table:

    <table border="1" width="945">
          <tr bgcolor="#FFFFcc">
            <td width="124">Account #</td>
            <td width="180">Patient Name</td>
            <td width="195">Date of Service</td>
            <td width="127">Balance</td>
            <td width="159">Description</td>
            <td width="120">Amount to Pay</td>
          <?php foreach ($rowsPMHB as $key=>$rows){ $id = $rows?><!- foreach->
           <tr bgcolor="#ccffff">
              <td><?php if($rows>1){ echo "PP".$rows;?>&nbsp; <b><a href="javascript:void(0)" onclick="pp(<?php echo $rows.",".$rows;?>)" style="color:#000000;">+</a></b><?php }else echo $rows;?></td>
              <td><?php echo $rows.' '.$rows; ?></td>
              <td><?php echo $rows; ?></td>
              <td><?php if($rows>1) echo $rows; else echo $rows;?></td>
              <td><?php if($rows>1) echo "Payment Plan Total"; ?></td>
              <td><div align="center">
                <input name="payamt<?php echo $key;?>" type="text" id="payamt<?php echo $key;?>" size="20" />
      <!- PP ->
       <?php if($rows>1) {
    foreach ($rowsPP as $key2=>$rows){ ?>
               <tr style="border-width:0px;display:none;" id="<?php echo $id.$key2;?>">
                  <td width="124"><?php echo $rows; ?></td>
                 <td width="180"><?php echo $rows.' '.$rows; ?></td>
                 <td width="195"><?php echo $rows; ?></td>
                 <td width="127"><?php echo $rows; ?></td>
                 <td width="159"><?php echo "Incl in PP"; ?></td>
                 <td width="120">&nbsp;</td>
              <?php } ?>  
             <?php } ?><!- PP ->
            <?php } ?><!- foreach->