This works, but I am not getting the correct result. Any idea why?
$sql = SELECT max(month), max(year) FROM `table` WHERE country LIKE '$country';
when I execute this, it comes up with 9/2000
however, the max month should be 10 (and when I look in the database, the max month IS 10 and max year 2000). I did not set up the database, so I can't change it to keep the dates in one field.
$sql = SELECT max(month), max(year) FROM `table` WHERE country LIKE '$country';
when I execute this, it comes up with 9/2000
however, the max month should be 10 (and when I look in the database, the max month IS 10 and max year 2000). I did not set up the database, so I can't change it to keep the dates in one field.