m3rajk — Sat, 23 Aug 2003 18:48:49 +0000

i've done that. it's having issues with the @ in the e-mail address. i'm looking o see if i can find anything that will dealw ith that automatically while writing the forum display and tweaking the control panels on interests.. and possibly the sign up...

Suzanne — Wed, 20 Aug 2003 19:17:48 +0000

Thanks Mark, noted.

Those errors show up when you have other problems with the query, but at least you're connecting now. Check your variables, check your syntax, and make sure you're asking for the right things.

I use mysql_error() a LOT and echo ""; exit; after every thing when I have errors to debug line by line.

Mark Hensler — Wed, 20 Aug 2003 19:00:33 +0000

Quote: Originally posted by m3rajk
the db has nothing in it. is that why i'm getting the invalid resource? or is that caused by something else?

No, results should always be valid, regardless if anything is returned from the query.

Suzanne, watch your scope...
global $server, $username, $password;

m3rajk — Wed, 20 Aug 2003 18:10:56 +0000

i have switched it to mysql_connect (in all my files) it's still not doing it, "thepassword" is not the password for the user, it's just what i used for an example. but i'm thinking your suggestion on having host and usernames as variables int he db file makes sense, and i just thought of something else.... i'm including a few pages, i should doublecheck that $visitor is defined ONLY once

edit:
i now know the original problem was that i was using mysql_pconnect(). when that didn't work i started on the forums and reasoning that out. i noticed in the db file (where i define the passwords) i later redefine bot $visitor and one other password for use in the forums. so i changed the forum one since only one page calls that. much easier to fix in one page than about a dozen pages.

anyway, as soon as i did that, i got this:

Quote: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/html/findyourdesire/join.php on line 34

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/html/findyourdesire/join.php on line 40
sending to sql: INSERT INTO users (username, password, email, last_login_ip, last_login_date, enroll, gender) VALUES (neo, 9cc9e1f6a22e05307d6831087ef5d1e6, , 192.168.1.1, 2003-08-20 18:32:09, 2003-08-20 18:32:09, M)
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/findyourdesire/join.php on line 173

Warning: Cannot add header information - headers already sent by (output started at /var/www/html/findyourdesire/join.php:34) in /var/www/html/findyourdesire/join.php on line 178

Warning: Cannot add header information - headers already sent by (output started at /var/www/html/findyourdesire/join.php:34) in /home/joshua/includes/fyd.funcs.php on line 42

Warning: Cannot add header information - headers already sent by (output started at /var/www/html/findyourdesire/join.php:34) in /home/joshua/includes/fyd.funcs.php on line 43

Warning: Cannot add header information - headers already sent by (output started at /var/www/html/findyourdesire/join.php:34) in /home/joshua/includes/fyd.funcs.php on line 44

Warning: Cannot add header information - headers already sent by (output started at /var/www/html/findyourdesire/join.php:34) in /home/joshua/includes/fyd.funcs.php on line 45

followed by the next page.
th header issues are an expected result of the debugging line i have in there. i do have a question now... the db has nothing in it. is that why i'm getting the invalid resource? or is that caused by something else?

and Suzanne, i don't know why, but it's you last post that made me think to check for a double declaration.

Suzanne — Wed, 20 Aug 2003 17:38:07 +0000

So your username is visitor and your password is "thepassword" and this doesn't work?

How do you have it in your script?

***

I should point out that my function has nothing to do with modules for PHP, but rather using mysql_pconnect() only works if PHP is a module, not compiled with Apache.

Try using the more standard (and probably better for your application in this case) mysql_connect() and set up a nice function to serve you.

<?php
$server = 'servername';
$username = 'username';
$password = 'password';
 
function connectdatabase() {
    $connected = mysql_connect($server, $username, $password);
 }
 
?>

m3rajk — Wed, 20 Aug 2003 17:30:15 +0000

i've used the shell to verify that both the username and password work. the file with the db functions has the variable $pw set as $pw='thepassword';
so unless it also has the '' it should be exactly the same thing as i type into the shell

Suzanne — Tue, 19 Aug 2003 16:13:54 +0000

Looks to me like that username or password is wrong. That's the error I get when I move things from one server to another and fail to change the information in my happy connection function first.

mairving — Tue, 19 Aug 2003 15:11:57 +0000

Have you trying connecting from the shell, assuming that you have shell access?

mysql db_name -u username -ppassword

This will tell you if your user can actually connect to mysql.

m3rajk — Tue, 19 Aug 2003 14:51:17 +0000

hmm...

suzanne: if that means cgi module then i can't use it.

mark: the mysql book i have suggests using it.

10:51 - made sure all host feilds related to visitor are localhost and flushed privileges, and double checked join.php

result of test

Quote: Warning: Access denied for user: 'visitor@localhost' (Using password: YES) in /var/www/html/findyourdesire/join.php on line 30

Warning: MySQL Connection Failed: Access denied for user: 'visitor@localhost' (Using password: YES) in /var/www/html/findyourdesire/join.php on line 30
cannot access db

Mark Hensler — Mon, 18 Aug 2003 22:00:29 +0000

Quote: Originally posted by m3rajk
there's just one machine. it's name is Ashes.
i've already switched them to localhost in that file. no change.

You need to change everythig in PHP to 'localhost', as well as the `Host` field in the `mysql` dabatase.

And try mysql_connect() instead of persistent connections. (personally, I never use persistent connections)