[RESOLVED] comparing times

[johnpnoble]

Hello Folks,

I have a mySQL database where I store tide times as strings. At the moment my website only shows the morning tide regardless of what the real time is.

They are in the format

Morning tide
01:11

Afternoon tide
23:59

What I want to do is compare the morning time in the database with the current system time.
If the current time is less than the morning tide then show the morning tide; otherwise show the afternoon tide.

I do not know how to acquire the current system time, convert it to a string and then compare it with data from the tides table.

Here is the code I have so far :

<?php


//	connect to the db
	require ('mysql_connect.php');	

// 	get todays date
	$str_todaysdate = date('Y-m-d', strtotime('now'));

$tides = mysql_query("SELECT * FROM tides WHERE date1 = '$str_todaysdate'" );
$tides_check = mysql_num_rows($tides); 	

$gbdate = date('d-m-Y	', strtotime('now'));
$formatted_date = strftime("%A %d %B", strtotime($gbdate));



// 	if there are records to display				
	if($tides_check > 0){ 
		while($row = mysql_fetch_array($tides)){ 
			foreach( $row AS $key => $val ){ 
				$$key = stripslashes( $val ); 
			} 


			echo "$formatted_date<br>High Tide $High_HM_Morning";
		}
}

//  close connection
	mysql_close()


?>

[Krik]

First, this

date('d-m-Y', strtotime('now'))

is the same as

date('d-m-Y')

Next, why you are formatting the date of a formatted date?
This

$gbdate = date('d-m-Y	', strtotime('now'));
$formatted_date = strftime("%A %d %B", strtotime($gbdate));

Could be this

$formatted_date = date('D m F');

or

$formatted_date = strftime("%A %d %B");

Now to the comparison, you should use time stamps. You are using strtotime so you are likely familiar with time stamps. Store times as time stamps in your database and compare them as time stamps. Then, you can use "date" to make a formatted time for display.

$str_todaysdate = date('Y-m-d');

$tides = mysql_query("SELECT * FROM tides WHERE date1 = '$str_todaysdate'");	

$formatted_date = date('D m F');

if(mysql_num_rows($tides) > 0){ 
	while($row = mysql_fetch_array($tides)){

		if($row['Morning_tide'] > time()) {

			echo $formatted_date . "<br>High Tide " . date('H:i', $row['Morning_tide']);
		}
		else {
			echo $formatted_date . "<br>High Tide " .  date('H:i', $row['Afternoon_tide']);
		}
	}
}

[johnpnoble]

Perfect.

Thanks a lot.

J