Converting Date

[NoobPHP]

How should i change the display of my date from this "2005-07-12" YYYY-MM-DD, to "12-07-2005", DD-MM-YYYY

// Get the search variable from URL for Year Of Occurence
 $YearOfOccurence = @$_GET['YearOfOccurence'];
//trim whitespace from the stored variable
 $trimmedYearOfOccurence = trim($YearOfOccurence);
//separate key-phrases into keywords
 $trimmed_arrayYearOfOccurence = explode(" ",$trimmedYearOfOccurence);

// Build SQL Query for Year Of Occurence entered
foreach ($trimmed_arrayYearOfOccurence as $trimmYearOfOccurence){
     // EDIT HERE and specify your table and field names for the SQL query
    $queryYearOfOccurence = "SELECT * FROM report WHERE Year(DateOfOccurance) = \"$trimmedYearOfOccurence\" ORDER BY DateOfOccurance DESC";
    // Execute the query to  get number of rows that contain search kewords
    $numresultsYearOfOccurence =mysql_query ($queryYearOfOccurence);
    $row_num_links_mainYearOfOccurence2=mysql_num_rows ($numresultsYearOfOccurence);
}

display of results

//echo $queryAircraftTypeDisplay;
$queryAircraftDisplay = "SELECT * from report where reportid !=0"; 

if (!empty($_GET['YearOfOccurence']))
{ 
$queryAircraftDisplay  .= " and Year(DateOfOccurance) >='".$_GET['YearOfOccurence']."' and Year(DateOfOccurance) <= '".$_GET['YearOfOccurence']."'"; 
}
echo $queryAircraftDisplay;
$resultAircraftDisplay = mysql_query($queryAircraftDisplay) or die ("couldn't execute query ".mysql_error()); 
while ($row = mysql_fetch_array($resultAircraftDisplay)) 
{ 

//now let's make the keywords bold. To do that we will use preg_replace function. 
 //Replace field 
 $aircraftTailNo   = $row[ '1' ]; 
 $aircraftType     = $row[ '2' ]; 
 $servicingType    = $row[ '3' ]; 
 $airFrameHours    = $row[ '4' ]; 
 $defectInfo       = $row[ '5' ]; 
 $rectifications   = $row[ '6' ]; 
 $comments         = $row[ '7' ]; 
 $relatedDoc       = $row[ '8' ]; 
 //if there are 7 cols, write the <tr> tag and reset the counter 
 if ($cntr == 2) 
 { 
   echo "</tr><tr>"; 
   $cntr =1; 
 } 

  echo " 
  <td>$aircraftTailNo </td> 
  <td>$aircraftType   </td> 
  <td>$servicingType  </td>
  <td>$airFrameHours  </td> 
  <td>$defectInfo     </td> 
  <td>$rectifications </td> 
  <td>$comments       </td> 
  <td>$relatedDoc     </td> 
  "; 
 $cntr++;  //increment the counter 
}//end while 

[planetsim]

As its php please use [php][/php] tags it highlights the code and makes it easier to read. If you know that its exactly in the format of yyyy-mm-dd you can do it quite simply like this

$date = "2005-07-23";
$array = explode("-", $date);
echo date("d-m-Y", mktime(0,0,0, $array[1], $array[2], $array[0]));

Now this is usable if your doing it when its not from the Database as I cant really tell where the date is coming from it maybe from the database if so use the Date Time Functions

[NoobPHP]

Select * from report Where DATE_FORMAT(DateOfOccurance, '%d %m %y')>= '$beginDate' and DATE_FORMAT(DateOfOccurance, '%d %m %y') <= 'endDate'

WHere did i go wrong.. Why is the results still displayed in "2002-04-27", "YY-MM-DD"

[Weedpacket]

You want to format the field you're selecting, not the ones you're testing.

This is another reason why you should not use "SELECT *", but instead list the fields you actually want to select.

SELECT DATE_FORMAT(DateOfOccurrence, '%d %m %y'), etc FROM report WHERE ....

[NoobPHP]

I got this error instead..
Notice: Undefined index: 1 in c:\inetpub\wwwroot\searchAircraftTailNo.php on line 419,420,421,423,424,425,426

$aircraftTailNo = $row[ '1' ]; <- Line 419
$aircraftType = $row[ '2' ]; <- line 420
$servicingType = $row[ '3' ];
$airFrameHours = $row[ '4' ];
$defectInfo = $row[ '5' ];
$rectifications = $row[ '6' ];
$comments = $row[ '7' ];
$relatedDoc = $row[ '8' ]; <- Line 426

$queryAircraftDisplay = "SELECT DATE_FORMAT(DateOfOccurance, '%D %M %Y') as DateOfOccurance from report where reportID != 0"; 
if (!empty($_GET['AircraftType'])) 
{ 
$queryAircraftDisplay  .= " and aircraftType='".$_GET['AircraftType']."' "; 
}
if (!empty($_GET['ServicingType'])) 
{ 
$queryAircraftDisplay  .= " and servicingType='".$_GET['ServicingType']."' "; 
}
if (!empty($_GET['AirFrameHours']))
{ 
$queryAircraftDisplay  .= " and AirFrameHours>='".$_GET['AirFrameHours']."' and AirFrameHours <= '".$_GET['AirFrameHours2']."'"; 
}
if (!empty($_GET['AirFrameHours2']))
{ 
$queryAircraftDisplay  .= " and AirFrameHours>='".$_GET['AirFrameHours']."' and AirFrameHours <= '".$_GET['AirFrameHours2']."'"; 
}
if (!empty($_GET['YearOfOccurence']))
{ 
$queryAircraftDisplay  .= " and Year(DateOfOccurance) ='".$_GET['YearOfOccurence']."' "; 
}
if (!empty($beginDate))
{ 
$queryAircraftDisplay  .= " and DateOfOccurance >= '$beginDate' and DateOfOccurance <= 'endDate'";  

} 
if (!empty($_GET['Keyword']))
{ 
$queryAircraftDisplay  .= " and reportID in ($newarr)";
}
echo $queryAircraftDisplay;
$resultAircraftDisplay = mysql_query($queryAircraftDisplay) or die ("couldn't execute query ".mysql_error()); 
while ($row = mysql_fetch_array($resultAircraftDisplay)) 
{ 

//now let's make the keywords bold. To do that we will use preg_replace function. 
  //Replace field 
  $aircraftTailNo   = $row[ '1' ]; 
  $aircraftType     = $row[ '2' ]; 
  $servicingType    = $row[ '3' ]; 
  $airFrameHours    = $row[ '4' ]; 
  $defectInfo       = $row[ '5' ]; 
  $rectifications   = $row[ '6' ]; 
  $comments         = $row[ '7' ]; 
  $relatedDoc       = $row[ '8' ];