Leaderboard

There are a couple of errors in your SQL statement... The specified format should be in quotes (it's a string) The format code for a short month name id "%b" (%m is month number) Try select STR_TO_DATE('Mar-2026', '%b-%Y'); -- > 2026-03-00 Note the function returns a date. To output your required "03-2026" you need to use DATE_FORMAT() on the returned date select DATE_FORMAT( STR_TO_DATE('Mar-2026', '%b-%Y'), '%m-%Y'); | | input output format format Easiest is always to store dates as DATE TYPE ie 2026-03-01 instead of Mar-2026.

Command line php has a linter (syntax checker) built into it. php -l /path/to/file.php Most PHP Integrated developer environments (IDE's) have a syntax checking built into it. The generally accepted best IDE for PHP is Jetbrains PHPStorm, but VSCode or Codium with the installation of https://intelephense.com/ plugin is a suitable free/low cost option. If you want to try it out, you should make sure to follow the installation instructions, which involves uninstaling a plugin that comes with vscode and will interfere with intelephense. These tools do numerous things to show you what syntax errors you have. Last but not least, there are numerous AI LLM's that you can point at the code and will diagnose problems.

No offence, but PHPMyAdmin totally sucks if you want to edit 3 rows at a time without having to click a thousand times. It's fine for raw queries, of course, but if you want to do anything meaningful with a result set, you're out of luck.