mrdarc

Yes, I mean on my own computer

Yep, that thing running in the "Command Prompt" window. MySQL console, that's what wamp calls it. It's not pretty to look at, but it works

I've tried running the procedure after having selected the database, without selecting it, and from just about every window that I possibly can within phpMyAdmin. Just wondering... have you ever tried running a procedure in phpMyAdmin? If it worked for you, how did you do it? I just tried running the procedure from the mysql console and it works. It's definitely something about my installation of phpMyAdmin.

I pretty much tried everything It seems I can call the stored procedure from a php web page though. So I guess that's just what I'll have to do to test it out. Thanks.

Thanks for the reply JcX... I forgot to say that I was using phpmyadmin the whole time, so I don't think that's the problem. I've looked up tutorials online about stored procedures and follow them step by step. But I still get this error. Don't know if it's some weird setting I need to change. I'm using the latest version of wamp with its default settings.

OK, so I'm testing out how to use stored procedures in MySQL on my local machine.... I create a very simple one that retrieves all the data from a table call `book`. Then run the command "CALL get_all_books()" and all it does is give me this error... Error SQL query: SELECT DATABASE( ) AS 'db'; MySQL said: Documentation #2014 - Commands out of sync; you can't run this command now Trying to figure this one out is giving me a headache. Any help would be appreciated. Thanks.

djbob, Did you give up on trying to get the .ini file from resetting? Been waiting for the PDO classes to work, but it hasn't. Let me know what your plans are. If you can't get the PDO classes to work permanently, I'll just give up and use mysqli instead. Thanks.

OK, got it. Forgot to add the permissions. I'm retarded Thanks for the help djbob.

My account in on the Stevie server. What is the host name I should use to connect to MySQL? Is it localhost? I keep getting the access denied no matter what I try. Thanks in advance for the help.

djbob, It is saying Fatal error: Class 'PDO' not found again. I guess it got turned off. Can you re-enable? Thanks.

Yup, I can verify that it works now. You rock djbob.

Hmm.. I just signed up for this account so it is already on the Stevie server. I guess the problem would be me doing something wrong. How would you reference it on this site? On my default installation of PHP using wamp, I can get it to work by using the following quick test: $db = new PDO(); It give me a warning that "PDO::__construct() expects at least 1 parameter". But I know that it is working. I also got it working before when I put in all the parameters. I tried the same above code on this site and it gives me the follow error: Fatal error: Class 'PDO' not found in /home/myaccountname/public_html/index.php Anybody have any clue what I need to do? Thanks a lot.

Are you going to include PDO class support soon? I'm not trying to rush you. Just want to know so I can decide what method to use to code my site. Thanks.

It works. I can log in to my account now. Thanks djbob.

Why delete your account? First of all, that would get rid of your posts, which may be a valuable resource for somebody with the same problem. And second of all, that would take some work from my end and probably some database corruption to deal with. What do you have to gain from locking yourself out anyways? Requests for account deletion always intrigue me. Well, I just thought that if I don't get to create my own account, that there would be no point in leaving my message board account here. It's not that I'm trying to lock myself out or create extra work for you. I didn't even think of it that way. OK, leave my message board account. It's no big deal. I will try to sign up again after you do the work around for the sign up. Thanks for the help.