Julia’s Fairies – 2014(I)

$db = “juliasfairies_authors”;

echo “

“;

echo “

Original Problems Published at Julia’s Fairies in 2014,
January – April

The judge: Vlaicu Crișan
The judge for Retro and PG problems 2013 – 2014: Hans Gruber

“;

echo “

“;
echo “

if (isset($_POST[‘submit’])) {

if ($_POST[‘jf-2014-i’] == ‘1’) {

echo “Problems for JF-2014-I”;
$select_author = “SELECT problem_no, problem_date, problem_url, author, country, stipulation, fairy_pieces, fairy_conditions, pieces, tournament FROM JFauthors WHERE tournament like ‘JF-2014-I’ order by problem_date, problem_no”;

} else if ($_POST[‘jf-r2013-14’] == ‘1’) {

echo “Retro & PG problems”;
$select_author = “SELECT problem_no, problem_date, problem_url, author, country, stipulation, fairy_pieces, fairy_conditions, pieces, tournament FROM JFauthors WHERE (problem_date>=’2014-01-01′ and problem_date<='2014-04-30' and tournament like 'JF-R2013-14') order by problem_date, problem_no"; } else { echo "All published problems"; $select_author = "SELECT problem_no, problem_date, problem_url, author, country, stipulation, fairy_pieces, fairy_conditions, pieces, tournament FROM JFauthors WHERE tournament like 'JF-2014-I' OR (problem_date>=’2014-01-01′ and problem_date<='2014-04-30' and tournament like 'JF-R2013-14') order by problem_date, problem_no"; } } else { echo "All published problems"; $select_author = "SELECT problem_no, problem_date, problem_url, author, country, stipulation, fairy_pieces, fairy_conditions, pieces, tournament FROM JFauthors WHERE tournament like 'JF-2014-I' OR (problem_date>=’2014-01-01′ and problem_date<='2014-04-30' and tournament like 'JF-R2013-14') order by problem_date, problem_no"; } echo "

echo “

“;

selected_list_authors($select_author, database_connect($db), 0, 0);

echo “

“;

echo ““;

echo “

“;