Does "ORDER BY" work with stored procedures?

[cupboy]

Here's my code:

CREATE PROCEDURE selectlist(IN fmt varchar(50), orderby varchar(50))
select artist,
disc_title,disc_catno,label_name,qty,disc_seq from cd_data,cd_label,cd_artis
where cd_data.disc_label = cd_label.label_no and cd_data.artist_no = cd_artis.artist_no
and format=fmt
order by orderby

call selectlist(
'ld', 'disc_title'
)

After the call statement in the .php file is processed it returns the records unsorted. Also, does anyone know how to call a stored procedure in phpmyadmin? All phpmyadmin gives me is MySQL said: Documentation
#1312 - PROCEDURE rec1.selectlist can't return a result set in the given context

[dougal85]

Does "ORDER BY" work with stored procedures?

Yes

[tomhath]

Is "orderby" a column in one of the tables? I don't use MySQL stored procedures much but I'd be surprised if you could pass in the order by column as a parameter 😕