Results 1 to 2 of 2

Thread: mysql and php, best software ???

  1. #1

    Thread Starter
    Fanatic Member kevin_sauerwald's Avatar
    Join Date
    Feb 2002
    Location
    outside Philly
    Posts
    516

    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..

  2. #2
    I'm about to be a PowerPoster!
    Join Date
    Jan 2005
    Location
    Everywhere
    Posts
    13,647

    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
  •  



Click Here to Expand Forum to Full Width