PHP - How To Get Php To Auto-create Months/years

Hi i have this drop down list current the year is 2010 and downwards but i want to change the list to 2010 upwards u can notice on the 50-- so shows current year minus so current is 2010 to 61 how can i change 2010 to 2030 or sunfin??

echo '<select name="year_of_birth">',"\n";
    $year = date("Y");
    for ($i = $year;$i > $year-50;$i--) {
      if($i == $thisYear) { 
        $s = ' selected'; 
      } else { 
        $s='';
      }
      echo '<option value="' ,$i, '"',$s,'>' ,$i, '</option>',"\n";
    }
  echo '</select>',"\n";

I can determine 3 years from today, but How do determineo 3 years from march 1st?

So I want to echo out "3/1/2013"?

Thanks!

Hi Guys,

In a form within PHP coding i can get the the next 10 years with the following code:

Code: (php) [Select]
<?php 
$date_future = date("Y", strtotime('+10 year'));
$date_year = date("Y");
for($i=$date_year;$i<$date_future;$i++){
if($date_year == $i){ 
echo "<option value=\"$i\" selected=\"selected\">$i</option> \n";
} else { 
echo "<option value=\"$i\">$i</option> \n"; 
}
} 
?>
I have tried to mess about with the same code and try and get it to work for the last 10 years without any luck. He's what i did:
Code: (php) [Select]
<?php 
$date_past = date("Y", strtotime('-10 year')); 
$date_year = date("Y");
for($i=$date_year;$i>$date_past;$i++){
if($date_year == $i){ 
echo "<option value=\"$i\" selected=\"selected\">$i</option> \n"; 
} else { 
echo "<option value=\"$i\">$i</option> \n"; 
}
} 
?>
I would appreciate any help with this.

How can i group the data by year to build the graph

I need the data to be like so

2012
0 - total customers
0 - total customers
0 - total customers
0 - total customers
0 - total customers
9 - total customers
5 - total customers
3 - total customers
5 - total customers

however i only have this data

Code: [Select]
total_customers month year
1 Aug 2011
9 Oct 2011
8 Nov 2011
4 Dec 2011
4 Jan 2012
so i need to make it show 0 for the months i dont have data for

Code: [Select]
<div id="dash_chart" class="portlet x9">

<div class="portlet-header">
<h4>Customer Growth</h4>

<ul class="portlet-tab-nav">
<li class="portlet-tab-nav-active"><a href="#tab1" rel="tooltip" title="Customers">Customers </a></li>
<li class=""><a href="#tab2" rel="tooltip" title="Sales over last 48 hours.">Sales </a></li>
</ul>
</div> <!-- .portlet-header -->

<div class="portlet-content">
<div id="tab1" class="portlet-tab-content portlet-tab-content-active">
               
                <?php 

echo '<table class="stats" title="area" width="100%" cellpadding="0" cellspacing="0">
<caption>Customer Base Growth</caption>
<thead>
                <tr>';

$monthNames = Array('Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec');

$i = 0;

foreach ($monthNames as $month){

echo '<th>'.$month.'</th>'."\n";

}

echo '</tr>
  </thead>';

                      $q = "SELECT count(cus_id) as total_customers, DATE_FORMAT(sign_date, '%b') as month, YEAR(sign_date) as year FROM customers 
  GROUP BY YEAR(sign_date), MONTH(sign_date) ORDER BY sign_date ASC";
$r = @mysqli_query ($dbc, $q);

$data = array();

if (mysqli_affected_rows($dbc) >= 1) {

echo '<tbody>
<tr>
   <th>2011</th>';

while ($row = mysqli_fetch_array($r, MYSQLI_ASSOC)) {


}

}

echo '</tr>';

?>
                            <tr>
<th>2012</th>
<td>3</td>
<td>4</td>
<td>2</td>
<td>0</td>
<td>0</td>
                                <td>0</td>
<td>0</td>
<td>3</td>
<td>5</td>
                                <td>3</td>
                                <td>9</td>
</tr>
</tbody>
</table>

I am searching the database for items that are plaques. There are different years of plaques. I find all the plaques sorted by year. My display puts them in rows of 4 max.
What I want is to display them by year with a different year on a different line.
Right now there are 4 (1963), 3 (1965), 1 (1978) all bunched together.
1963, 1963, 1963, 1963,
1965, 1965, 1965, 1978

What I want is:
1963, 1963, 1963, 1963,

1965, 1965, 1965,

1978,

Any help would greatly be appreciated.


<?php
include 'config0.php';

$search=$_GET["search"];

// Connect to server and select database.
mysql_connect($dbhost, $dbuser, $dbpass)or die("cannot connect");
mysql_select_db("$dbname")or die("cannot select DB");


$result = mysql_query("SELECT * FROM table1 WHERE plaques LIKE '%$search%' ORDER BY year") or die(mysql_error());
// store the record of the "" table into $row
//$current = '';

// keeps getting the next row until there are no more to get
if($result && mysql_num_rows($result) > 0)

{
    $i = 0;
    $max_columns = 4;
    echo "<table align=center>";
echo "<br>";
    while($row = mysql_fetch_array($result))
   {
       // make the variables easy to deal with
       extract($row);

       // open row if counter is zero
       if($i == 0)

          echo "<tr>";

          echo "<td align=center>";
          ?>
          <div style="float: left;">
          <div><img src="<?php echo $tn; ?>"></div>

  </div>


          <?php
          echo "</td>";

       // increment counter - if counter = max columns, reset counter and close row
       if(++$i == $max_columns)
       {
           echo "</tr>";
           $i=0;
       }  // end if
   } // end while
} // end if results

// clean up table - makes your code valid!
if($i > 0)
{
    for($j=$i; $j<$max_columns;$j++)
        echo "<td>&nbsp;</td>";
   echo '</tr>';
}
mysql_close();
 ?>
</table>