SELECT Help

jeffgman

I have a couple of questions about my SELECT statement.

	  	<?
	  	$sql="SELECT class_date FROM huntersafety_dates WHERE class_date > $today";
	  	$result=mysql_query($sql, $conn);
	  	while($row=mysql_fetch_array($result, $conn)) {
	  		$class_date=$row['class_date'];
	  		$class_date1=strtotime($class_date);
	  		$longdate=date('l, F, d, Y', $class_date1);
	  		echo "<option value=\"{$class_date}\">{$longdate}</option>";

The select statement is not working because it is pulling all of the records instead of just the records where the data is greater than today.

Also, how does my code for changing the date format look? Can I streamline it at all?

Thanks for your help.

Lars_Berg

$sql="SELECT class_date FROM huntersafety_dates WHERE class_date > current_date";

tomhath

You could collapse all four lines in the while loop into one, but there's really no reason to do so; what you have is easy to read. Some people like to play "golf" by writing code work in as few keystrokes as possible, but that usually makes it hard to understand.

jeffgman

Originally posted by Lars Berg

$sql="SELECT class_date FROM huntersafety_dates WHERE class_date > current_date";

[/B]

Thanks for the help. Where does current_date come from? Is that a variable I need to setup, or is it just a known variable with the current date in it?

Thanks,
Jeff

tomhath

The manual's a good place to start:

http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html

Beginning with MySQL 4.1.3, the CURRENT_TIMESTAMP(), CURRENT_TIME(), CURRENT_DATE(), and FROM_UNIXTIME() functions return values in the connection's current time zone, which is available as the value of the time_zone system variable