Boyd, Todd M. wrote:
-----Original Message-----
From: Chris [mailto:dmagick@xxxxxxxxx]
Sent: Thursday, February 26, 2009 4:16 PM
To: Boyd, Todd M.
Cc: PJ; PHP General list
Subject: Re: Re: catch the error
In examples sent to you, people foolishly replaced your $db var with
$db_connect ONLY FOR PART OF THE SCRIPT. You've defined your
database
connection as $db_connect in some versions of the source, but then
you
reference $db (without _connect) in your mysql_select call in that
same
source.
$db = mysql_connect([option list here]); # <-- this code
instantiates
a
connection
mysql_select_db([some name], $db); # notice how $db is here?
$result = mysql_query([some query], $db); # it's here, too!
$db becomes your resource link when you use mysql_connect. That
resource
link must then be passed to your mysql functions. Otherwise, they
have
no idea which database connection you are attempting to use.
RTFM?
If no connection is specified, the last one is used.
It is an optional argument (only *really* needed when you have
multiple
connections in the same script).
RTF E-mail I sent?
He had used $db_connect instead of $db. $db_connect hadn't been set to
anything. He was specifying a connection, but it was null. Unless it
falls back to the last connection used in the case of an empty variable,
then this was most likely (read: proven to be) the problem.
The last two emails I saw (no I haven't read the whole thread) were:
>> $db = mysql_connect($db_host, $db_user, $db_pass);
>> > >> mysql_select_db($db_name,$db);
<snip>
>> > >> $result1 = mysql_query($sql1,$db);
and
> $db = mysql_connect($db_host, $db_user, $db_pass);
> mysql_select_db($db_name,$db);
which have the right variables.
Plus I was picking on the "you must do this" - using the link identifier
is an optional thing as I already said.
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php