mysql and php, best software ???

[kevin_sauerwald]

ok I'm going from scratch here and developing a page using PHP with mysql.. but I want to use store procs but I guess PhpMyAdmin doesnt allow it unless you make them right in the sql editor..

so question 1.. is there some good software that I can use to do it all ?

question 2.. if I'm using the phpMyAdmin I'm not sure how I'm supposed to be entering in SP's.. I got one to go in fine using normal methods.. but then in reading all these other pages they say for the call to work properly you need to
use this delimiter thing ? but in all the examples I see and then try.. phpMyAdmin doesnt like it... this is what I tried..

DELIMITER //

DROP PROCEDURE IF EXISTS SaveQuestion; 

create procedure SaveQuestion
(in pCategory TINYINT,
 in pAnswer_Type TINYINT,
 in pQuestion_Text VARCHAR(55))
 BEGIN
	INSERT INTO question VALUES 
		(1,pCategory,pAnswer_Type,"2012-02-02","HEAT",pQuestion_Text)
END //
DELIMITER ;

so I do know if that delimiter is if you are building these from some other software other than phpMyAdmin.. or what.. just not sure if what I', doing
is totally wrong.. or I should not even try to be doing what I'm doing.. want
to get started on the correct foot before I go to far..

any pointers would be great..

[penagate]

I suggest you use the MySQL console instead of phpMyAdmin.