mysql not connecting

Randomizer

I'm trying to connect to my mysql database with the code:

mysql_connect($mysqlhost, $mysqlusername, $mysqlpassword);

It gives me a Warning: mysql_connect(): Access denied for user: 'ODBC@localhost' (Using password: NO) I can't figure it out because I'm using a password. The strange thing is if i just go

 
mysql_connect($mysqlhost, $mysqlusername, "mypassword");

it connects fine, help would be great.
Many Thanx

kellog

right before you do your mysql_connect, do a echo $mysqlpassword; and see what it says. More than likely the variable is not set.

Randomizer

That dosen't make any sense cause I'm submitting it from a form..

kellog

Originally posted by Randomizer
That dosen't make any sense cause I'm submitting it from a form..

Most of the time when something goes wrong in a script, it's a type-o. And when it's not a type-o, it's a logical error. Either way, seeing what is in your variables at the end of your script will tell you everything. If you echo your password, and it comes up blank, then you know it's not being set correctly. However, if it does indeed echo the correct password, then something is wrong[tm] between php and mysql.

Randomizer

can't be a error I checked everything and rechecked and I don't get any error messages besides the mysql connection one.

Randomizer

is there a max amount of POST variables you can send?

silent

Run this script :

phpinfo();

Are you trying to access your POST variables by their name?
ie :
<input type="text" name="name">

then you reference it by $name ??

If so, try this :
$_POST['name']

If that works, then register_globals is off (which it should be!)

I hope this helps... if not, then you really should post more code up here so we can really help you.