Hi

I have been going over this for the best part of a week, with no resolve. I would like this simple MySQL link to show an accurate list of events, automatically kept up to date by the MKTIME function. I know the DB table is accurate, but I cannot see where my script is going wrong. Any advice would be amazing. Thanks in advance.

Dan

PHP Code:

$link = mysql_connect('HOST', 'USER', 'PASS');
                            if (!$link) {
                                die('Not connected : ' . mysql_error());
                            }
                            $db_selected = mysql_select_db('DBNAME', $link);
                            if (!$db_selected) {
                                die ('Failed to load data : ' . mysql_error());
                            }
$result = mysql_query("SELECT * FROM TABLENAME ORDER BY yy ASC, mm ASC, dd ASC  LIMIT 4");
    while($row = mysql_fetch_array($result))
                                {

list($day, $month, $year) = explode('-', $row['end']);
$timestamp= mktime(0, 0, 0, $month, $day, $year);


 if($timestamp < mktime()){echo'';} else{
                        echo'
                                    <a href=""><img src="'.$row['ROWNAME'].'" height="220" /></a>
                        '; }
                        ;} 


In what way(s) is it going wrong?

It is just not returning anything. It works in reverse, i.e. {if($timestamp > mktime())} perfectly well. My database is sound, I just cannot see what is going wrong here.

Not sure if I'm understanding you correctly. Are you saying that the table has a field named end which contains a date and that you have records where that value is before current date/time and records where it is after, and that those after are returned by the query but not those before? Can you echo the values returned from list($day, $month, $year) = explode('-', $row['end']);

Hi
Sorry, should have mentioned, the function of the script is to automatically remove from view yesterday's events from a live music calendar based on a stated end date (defined as $row['end'] in the MySQL table) being less than MKTIME().
If I echo the results as the reverse, i.e. MKTIME() is less than $row['end'], it does produce the results as expected.
Dan

I think I have found the problem, but this leaves me with another. The issue is the LIMIT 4 section of the mysql_query. Because it will only read the top 4 results, all of which have their dates in the past, it will not show any more.

The newest dilemna is the following.

How do I delete rows based upon the $row['end'] being less than MKTIME()?

The idea would be that when a user loads the site, the pre-head section of the page would delete from the table the "in the past" rows before the page is produced, and thus, a totally up to date page is shown.

where end < curdate ?(I don't have access at the moment to mysql, sorry, that's why I'm sort of guessing.)

Perfect! Thanks Paul! So obvious now!