dates and databases

[Cuban]

hi,
i have a database where the primary field is a date. what i need is to pull and display the next record after todays date?
is this posible?
Please help!!
Cuban

[helil]

I might be able to help you, because I recently had some headaches on date formatting, but I didn't get what you want. Is it converting date formats? Is the date automatically added? If you want, post the code

[]'s
helil

[Cuban]

i have a table with 3 fields:
date | act | uni

date = date of the activity
act = Name of activity
uni = Dress code

what i would like is a table with the following info:

Next event: 10/2/03
activity: hand gliding
Dress: casual

the code i have so far is

<?php
	$rs =@mysql_connect("localhost","login","password");
	$rs =@mysql_select_db("database");

$sql ="select * from cal where date >= CURRENT_DATE limit0,1";

$rs =@mysql_query($sql);

if(mysql_num_rows($rs)==1)
{
$cal = mysql_fetch_assoc($rs);
echo "Next event: ".$cal["act"].",".$cal["date"].",".$cal["uni"]."!<br>";
}
?>

[Lars_Berg]

$sql ="select * from cal where date >= CURRENT_DATE order by date limit 0,1";
$rs = mysql_query($sql) or die(mysql_error());

Using limit without order by is void of meaning.

[Cuban]

Excerlant that helped alot thanx 🙂
i just have 1 final question.
The date format is in yyyy-mm-dd is their anyway i can change this to dd-mm-yy or dd-mm-yyyy?