Russell (zimzat) wrote,
Russell
zimzat

  • Mood:
  • Music:

~/alive && ~/kicking

All I have to say is allow me to blow your mind away.

$db_query = "
    SELECT `position`, `text` 
    FROM `news` 
    WHERE `entrystartdate` <= '" . date('Y-m-d') . "' AND (
        (
            `entrystartdate` <= '" . $comic . "' AND `entrystopdate` >= '" . $comic . "'
        ) OR (
            `entrystartdate` >= '" . $comic . "' AND `entrystopdate` = '0000-00-00'";
if ($comic_next != '')
{
    $db_query .= " AND `entrystartdate` < '" . $comic_next . "'";
}
$db_query .= "
        )
    ) 
    ORDER BY `publishdate` ASC";


Now that that is done, on to the next thing I need to do. Either a warm soak in the bath tub OR more PDI work. I'm leaning towards the former at the moment so I can relieve some of the tension working on that SQL query caused.

Oh yes, before I go. You'll be able to see the fruits of my labor on the main PDI site later. For now that formula is only on my private server, which Cox disables access to. har har
Subscribe
  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

  • 2 comments