PHP - Moved: Sorting Videos By Date Has Crashed

This topic has been moved to Other.

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

So i've got a CSV file, pull data from it and it's stored within an array. $data[0] contains date that looks like so 9/14/2011 00:00:00. How can i sort this array before displaying it so that it's sorted by Date ASC by default.

Code: [Select]
<?php
if (($handle = fopen("http://www.website.com/images/uploads/Recruitment_for_Web.csv", "r")) !== FALSE) 
{
while (($data = fgetcsv($handle, 10000, ",")) !== FALSE) 
{
echo '<tr>';
echo '<td>' . str_replace("0:00:00","",$data[0]) . '</td>';
echo '<td>' . $data[1] . '</td>';
echo '<td>' . $data[2] . '</td>';
echo '<td>' . $data[3] . '</td>';
echo '<td>' . $data[4] . '</td>';
echo '<td>'; 
if($data[7] != "")
{
echo '<a href="' . $data[7] . '" target="_blank">' . $data[5] . '</a>';
}
else
{
echo $data[5];
}
echo '</td>';
echo '<td>' . $data[6] . '</td>';
echo '</tr>';
   
}
fclose($handle);
}
?>
Thanks

This topic has been moved to PHP Applications.

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

This topic has been moved to MySQL Help.

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

Hello, I could really use a hand transferring my database off of an external hard drive onto a new drive after my os crashed. I'm running xampp with php 5.5 and my database is password protected so I need to be able to reset that too. Everything i have tried has not worked and now mysql can't be found so I have to do a new install. My database engine is innoDB. Sorry I'm new to programming and was running phpmyadmin so I don't quite understand getting shell commands to work since now mysql can't be found...