MySQL/PHP Date stuff...

Anon

Hiya.

I'm putting together a MySQL/PHP solution for a local non-profit music venue and I am almost done except for a few minor things...

When MySQL spits out the date it's "yyyy-mm-dd" and I'd like to make is "Day, Mo DD".
It spits out all the info on what shows are coming up and I'd like to make it so it only shows current stuff.

Can you take a look at my code that I am inserting in an almost all HTML php file and see what I am doing wrong and need to do...

http://r3e.com/koos/help.txt

I am just a beginner and am motivated to learn by the fact that I can directly apply it to people around me.

Any help would be appreciated.

Thanks,

Rob Roy

Anon

Firstyl you dont need to call you variables
all you need to do is put in $myrow[band1] this will shrten your code.

As for the date

the dates are here in php if you need to read more

http://www.php.net/manual/en/function.date.php

its all there

Anon

Thanks Lee,

I'm not sure if I was specific but I need to format a date that MySQL spits out. The page you referred me to is for local date and I went over that page many, many times trying to incorporate the code to no avail... do you think you could point out how in my code I would format the date that I put into variable $show_date from the database?

Any pointers would be appreciated... and any pointers on how to order that is spits out by date and to have it only spit out shows of that day or later.

If I am so beginner that is offends, I apologize. This was my last resort. I have been searching the php manual and scouring the web too.

Rob Roy

Anon

your date problem is easy
this will make you able to use date():
list($year, $month, $date) = explode("-", $date)
$timestamp = mktime(0,0,0,$month, $day, $year);

just pop $timestamp in as the second argument.

now unix time stamps are very useful.
since its one number you can easily compare dates.

i couldn't tell you how to sort the dates, but if your going to convert to times stamps, you could use time() to display only the shows that are past today, though i think there's more to it than that, using date() and the above code i.e.
//at the begining of your code
$today=date("j-n-y");
list($dnow, $mnow, $ynow) = explode("-", $today)
$today = mktime(0,0,0, $mnow, $dnow, $ynow);

if($timestamp >= $today)
{
//code used to show...
}

sorting it is beyond my abilities, i havn't worked with mysql before. and i don't intend to.

Anon

Im sorry if i was not clear enough

Once you have stored your date in the the database all you have to do is use the date function.
ie here is a small piece of script i use

$result = mysql_query ( "SELECT * from mpn_war_games WHERE result = '' ORDER BY e_date ");
while ( $a_row = mysql_fetch_array( $result ))
{
echo "<td width=\"10%\" height=\"2\"><div align=\"center\">".date("D j M H:i", $a_row[e_date])."</div></td>"
etc etc etc with your rows

Hope this help more

it is still the date function but you are telling it where its getting the info
ie
echo date("D j M:i", $a_row[your_date])
date() is the function