display a coming date

[siesmith]

merry xmas everyone
my question is

i currently display all dates (from a database) for gigdates for a band

but what i want to do next is to display just the next coming date
ie next gig 16th january 2003 - is it possible to do this dynamically. im sure it is but my php skills dont stretch this far

any help or advice please
thank you

all the best
siesmith

[kamy99]

Just run a simple query and limit it to 1

Select Date from Table Limit 1,1

[andrewkimb]

Use the function mktime. Just goto php.net and look at documentation on Date and Time Functions, it will tell you everything you need to know.

[siesmith]

kamyy99
thanks for the speedy reply

but im sorry i know what you mean by selecting just the one record but dont know how to do it - im use to selecting all records, here is my coding

$Query = "SELECT *, date_format(Date,'%W, %M %D %Y') as gigDate from maintable where Date >= CURRENT_DATE() order by Date asc";
$Result = mysql_db_query ($DBName,
$Query, $Link);

thanks again

sie

[cgraz]

SELECTING selects everything, so instead of selecting , you would use the actual field names you want to select. For example, if you have a database with 3 fields, field1, field2, and field3, and wanted to select just fields 1 and 2, your query would look like

SELECT field1, field2 FROM yourtable

In your case, you want to select just the date, so you'd do something like

$query = "SELECT date_format(Date,'%W, %M %D %Y') as Date from maintable where Date >= CURRENT_DATE() order by Date asc"; 
$result = mysql_query($query);

The above would select just the field Date (you may need to change if that's not the name of your field in the db)

Cgraz

[siesmith]

thanks gkraz
that does work fine
but what i want to do is to display dynamically just the next coming date, ie jan 16th 2003 - then once that date has passed to display the next date

as well as all the dates on a separte page as normal

i thank you and everyone else who has replied to my question

sorry to be a pain

regards

sie smith

[cgraz]

I don't know, you could try something like this maybe

$query = "SELECT id, date_format(Date,'%m-%d-%y') as Date from maintable WHERE -- specify which date you're wanting to check"; 
$result = mysql_query($query);

// NOTE this code assumes your query will only return one result
$row = mysql_fetch_array($result);

$today = date("m-d-y");
if ($row["Date"] > $today) {
   $id = $a_row["id"] + 1;
} else {
   echo "Date is still valid";
}
// by adding 1 this would assume everything is in order (particularly your id field and the dates)

$query = "SELECT id, date_format(Date,'%m-%d-%y') as Date from maintable WHERE id='$id'"; 
$result = mysql_query($query);

You'll probably have to play around with it a bit to get it to work.

Just out of curiosity, can I check out the liink to the site? You can email it to me if you don't want to post it - [e-mail]

I developed this bandsite http://www.wasteofmind.net/ a while back. Didn't know much PHP back then. Come to think of it, I never really did finish the site, but I'm curious to see what you've come up with.

Cgraz

[siesmith]

thank you for your help - i will try that code .........
the site was one of my first i built you can view all my work at
www.simonpaulwebdesign.co.uk

i liked the site you did for the band
it seems you know your stuff
#
i love php but html was a lot lot easier to learn

all the best mate
sie north east UK