Re: stupid error, please kick me (and send me a solution)

From:	Paul DuBois	Date:	Tue, 04 Jun 2002 00:14:35 +0000
Subject:	Re: stupid error, please kick me (and send me a solution)
References:	1	Groups:	php.general
Request:	Send a blank email to php-general+get-100489@lists.php.net to get a copy of this message

At 18:09 -0400 6/3/02, Jule Slootbeek wrote:

Hey guys, i'm getting this error with the following sql script using php: --error-- Warning: Supplied argument is not a valid MySQL-Link resource in /var/www/phpquiz/register_user.php on line 12 --error-- --script-- $link_glob = "mysql_connect('$host_glob', '$un_glob', '$pw_glob')";

Why is your mysql_connect() call enclosed within quotes? All you're doing here is assigning a string to $link_glob. The script can't possibly work. Note, too, that even if you take out the quotes, you don't check the return value from mysql_connect(), so you'll never find out if it fails.

$query = "INSERT INTO user values('0', '$fname', '$lname', '$email', '$username', PASSWORD('$password')"; $result = mysql_db_query('$db_glob', '$query', $link_glob'); if (!$result) { echo "Your Information could not be entered into the database, Please contact the <a href=mailto:$webmaster>webmaster</a>. " . mysql_errno() . ": " . mysql_error() . " "; } else { echo "Your Information has successfully been entered into the database! "; -- Jule Slootbeek jslootbeek@clarku.edu http://blindtheory.cjb.net