Jump to content

Order by time mistake


phpretard

Recommended Posts

My DB is holding time as "11:00 AM" "10:00 AM" ect...

 

Is there a way to convert these to time() after I have queried the DB for results?

 

<?php

connect();
$query = "SELECT * FROM party WHERE year(DOP) = '2011' order by PTIMES asc";
$qt=mysql_query($query);
echo mysql_error();
while($nt=mysql_fetch_array($qt)){

echo "
<tr height='30'> 
<td id='label'>".$nt['NOC']."</td>
<td id='labeloff'>".$nt['CFN']." ".$nt['CLN']."</td>
<td id='labeloff'>".$nt['type']."</td>
<td id='label'>".birthday($nt['DOB'])."</td>
<td id='label'>$DOP</td>
<td id='labeloff'>".$nt['PTIME']."</td>
<td id='labeloff'>".$nt['act1']."</td>
<td id='labeloff'>".$nt['act2']."</td>
<td id='label'>".$nt['pizza']."</td>
<td id='label'>".$nt['fc']."</td>
</tr>
";
}free($qt);

?>

 

Thank you.

Link to comment
https://forums.phpfreaks.com/topic/223947-order-by-time-mistake/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.