-
Feb 12th, 2012, 05:50 PM
#1
Thread Starter
Fanatic Member
mysql and php, best software ???
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..
Code:
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..
-
Feb 12th, 2012, 06:53 PM
#2
Re: mysql and php, best software ???
I suggest you use the MySQL console instead of phpMyAdmin.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|