> -----Original Message----- > From: Chris [mailto:dmagick@xxxxxxxxx] > Sent: Thursday, February 26, 2009 6:38 PM > To: Boyd, Todd M. > Cc: PHP General list > Subject: Re: Re: catch the error > > 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. Yes, it was solved before I replied. I just wanted to point out why it worked in the situations that it did and why it did not work in the situations that it did not. As the OP had been staring at it for too long, all of the code started to blur together. :) Anyway, it's a moot point now. I think the information you provided about the link identifier was solid advice... I was just trying to point out that using two different variables when specifying the link identifier in mysql functions was what gave him so much guff. // Todd -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
