RE: [PHP-DB] MultSelect ListBox hell!

2004-09-24 Thread Ford, Mike
On 23 September 2004 20:53, Stuart Felenstein wrote: So here is what I have: //Here is defines the field variable and uses //CodeCharge function to grab the variable $s_Industry = CCGetParam(s_Industry, ); $s_LocationState = CCGetParam(s_LocationState, ); $s_TaxTerm =

[PHP-DB] Newbie Question - mysql_select_db fails with access denied.

2004-09-24 Thread Christian Schlaefcke
Hi Folks, I want to do something like the following: $db = mysql_connect(localhost, myuser) or die(Connect failed : . mysql_error()); mysql_select_db(mydb,$db) or die(SELECT_DB failed : . mysql_error ()); $result = mysql_query(SELECT * FROM mytable, $db) or die(Query failed : .

Re: [PHP-DB] Newbie Question - mysql_select_db fails with access denied.

2004-09-24 Thread John
This might be a stupid idea, but did you remember to issue the Flush Privelages; command to the mysql database after granting your user all the rights? --John Christian Schlaefcke [EMAIL PROTECTED] wrote: Hi Folks, I want to do something like the following: $db = mysql_connect(localhost,

RE: [PHP-DB] MultSelect ListBox hell!

2004-09-24 Thread Stuart Felenstein
It's working great! I replaced the former parser with the implode. All is good again in the world! :) Mucho gracias! Stuart --- Ford, Mike [EMAIL PROTECTED] wrote: Mike - Mike Ford, Electronic Information Services

RE: [PHP-DB] Newbie Question - mysql_select_db fails with access denied.

2004-09-24 Thread Peter Lovatt
Hi try $db = mysql_connect(localhost, myuser,mypassword) - without it you are not submitting a password Peter -Original Message- From: Christian Schlaefcke [mailto:[EMAIL PROTECTED] Sent: 24 September 2004 13:31 To: [EMAIL PROTECTED] Subject: [PHP-DB] Newbie Question -

RE: [PHP-DB] Newbie Question - mysql_select_db fails with access denied.

2004-09-24 Thread Christian Schlaefcke
I have chosen an empty password. I know that this is a security problem. Im using it for testing at the moment only. I use it because there also seems to be an issue with php connecting to mysql servers with verions 4.1. When trying to connect with password I get this: Connect failed : Client

Re: [PHP-DB] Newbie Question - mysql_select_db fails with access denied.

2004-09-24 Thread Pablo M. Rivas
You're right: if you use mysql_connect(localhost, root,); you''ll get acces denied for user [EMAIL PROTECTED] if you use mysql_connect(localhost); you'll get Access denied for user @localhost I'll google for a while... but.. to solve YOUR problem, just use: mysql_connect(localhost,user,); Good

Re: [PHP-DB] Newbie Question - mysql_select_db fails with access denied.

2004-09-24 Thread Christian Schlaefcke
When I switch back to user root with empty password and use mysql_connect(localhost, root) it works. I just found out when I set the permission for myuser to localhost instead of any it works also for myuser. Now I have to check out why I cant use passwords. Maybe the PHP Version Im running is

[PHP-DB] Register Globals = OFF not passing variable

2004-09-24 Thread Craig Hoffman
Hey Folks, I can use some help here. I am changing some scripts around so they work with (register) globals off. I am trying to pass variables in a function and it does not seem to be passing. The script work fine with globals turned on. I would really like to have them work with RG

[PHP-DB] [Newbie] switch, if, or something to choose queries and echo formatting--PLEASE help

2004-09-24 Thread spam
[Newbie] switch, if, or something to choose queries and echo formatting--PLEASE help Please bear with me, I will be telling you step by step what I have tried, and what I want. I'm a newbie to this whole thing. I've had no trouble getting php and mysql running on computer and getting a test

Re: [PHP-DB] Register Globals = OFF not passing variable

2004-09-24 Thread Craig Hoffman
My apologies for not being clear. ;) I am not getting an error message. The script works just fine when Register Globals are turned on in the php.ini file. I am simply trying to understand what I need to change in order to have RG off and still have my code to work. See the area of the code

Re: [PHP-DB] Register Globals = OFF not passing variable

2004-09-24 Thread Daniel Watrous
Craig, I don't see where you are calling the function display_private_results, but I think I know what you are after. It appears you are expecting POST data and so have used the _POST superglobal. You have one of two options: Option 1: call the function sending parameters as you have shown

Re: [PHP-DB] Register Globals = OFF not passing variable

2004-09-24 Thread Craig Hoffman
Daniel, Thanks. Thats what I was looking for. Regards, Craig On Sep 24, 2004, at 9:40 PM, Daniel Watrous wrote: Craig, I don't see where you are calling the function display_private_results, but I think I know what you are after. It appears you are expecting POST data and so have used the _POST