select * from shows where date >= '$year-$month-01' and date <=
'$year-$month-$lastdayofthemonth'
- Original Message -
From: "Matt Nigh" <[EMAIL PROTECTED]>
To: "php-db" <[EMAIL PROTECTED]>
Sent: Monday, August 27, 2001 7:09 AM
hello again,
i'm stuck with this mysql query and can't seem to get it right
// start code
$result = mysql_query("select * from shows WHERE date >= '" . $year . "-" . $month .
"-" . ("00") ."' AND where date <= '" . $year . "-" . $month . "-" . ("31") ."'");
// end code
and yes, $year and $mo
