stored procedures

[estudiante]

Hi, I´m newbe and I´m trying to save a stored procedure using phpMyAdmin.

I thought it was as easy as writing:

******************************************************
-- Create myprocedure stored procedure
CREATE PROCEDURE myprocedure( )

BEGIN SELECT attribute1, attribute2
FROM mytable
ORDER BY attribute1;

END$$
******************************************************

But phpMyAdmin tells me there is a syntax problem in my sql-query. Is there something I´m not doing wright?

[estudiante]

I think the mistake was to write END$$ in spite of writing END $$ .