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.

That person, who told me about this site, is my brother. And we live in the same house, therefore have the same ip address. So can you set me up with an account? If not, please delete this message board account as I won't be posting without a free site. Thanks a lot.

Redmond, that's where I used to live. Redmond/Kirkland and those surrounding cities are awesome areas! Anyway, I signed up using [edited...] at gmail dot com Thanks for the help.

I wasn't paying that close attention to the success page loading, but I do believe nothing took more than 5 seconds. So do I sign up again and hope for the best or can I private message you the info and you help me set up the account? Off topic... do you live in Washington state or D.C? I used to live in Washington. Just about 5 minutes drive away from the Microsoft campus. Beautiful place, that state.

OK, so yesterday, I signed up again. The username is: mrdarc djbob, can you please verify for me that everything is OK with the sign up and activate my account? Thanks a lot in advance.

I didn't sign up with duplicate accounts. So do I just try signing up again?

I signed up on Monday, July 14, and was emailed the login page http://limitedbooks.heliohost.org/cpanel So far, it says page not found when I try to go there to log in. Is there anything else I need to do to complete the registration or do I just have to wait a little bit longer for it to work? Thanks a lot for the help.

It's obvious he wants smarty and the rest of the features. That's a good question. I've been wondering about smarty support too. Hope it's there.

Does heliohost support the PDO classes in PHP5? I'm new here and haven't even earned the points to create a new account.

C# is the best out there as of now. I'm a Microsoft guy PHP MySQL isn't bad either.