PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
$sql = "SELECT time, dates,events, dayofmonth(dates) as days FROM pickageek.calendar WHERE MONTH(dates)='$month' AND YEAR(dates)='$year' AND user='USERNAME'";
Last edited by Milan on Thu Jun 01, 2006 5:40 pm, edited 1 time in total.
$sql = sprintf("
SELECT time, dates, events, dayofmonth(dates) as days
FROM pickageek.calendar
WHERE MONTH(dates) = '%s' AND YEAR(dates) = '%s' AND user = '%s'
", mysql_real_escape_string($month),
mysql_real_escape_string($year),
mysql_real_escape_string($username));
$sql = sprintf("
SELECT time, dates, events, dayofmonth(dates) as days
FROM pickageek.calendar
WHERE MONTH(dates) = '%s' AND YEAR(dates) = '%s' AND user = '%s'
", mysql_real_escape_string($month),
mysql_real_escape_string($year),
mysql_real_escape_string($username));