Running a transaction in phpmyadmin

The problem with PHPmyAdmin is that all the lines have to be one command so it is not easy to demonstrate.

But if you run a transaction as follows it will not commit though the response says a different story

BEGIN;# MySQL returned an empty result set (i.e. zero rows).

UPDATE PRODUCTS_TMP
SET COST = 70
WHERE PROD_ID = '11235';# 1 row affected.

rollback;# MySQL returned an empty result set (i.e. zero rows).