Shawn McKenzie wrote:
> Boyd, Todd M. wrote:
>  > Jesus Christ... everyone on this list must've had a long week, because
>> you guys are going blind. :D
>> 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.
>> # BAD:
>> $db = mysql_connect([options]);
>> $result = mysql_query([some query], $db_connect); # what's $db_connect?
>> who knows!
>> # GOOD:
>> $db = mysql_connect([options]);
>> $result = mysql_query([some query], $db); # same resource link from
>> mysql_connect
>> See?
>> HTH,
>> // Todd
> Yes, and I would also strongly urge (scream at) PJ, to turn on E_ALL
> error reporting in any script he has problems with.
> #1 you'll figure out the problem because the errors will tell you
> exactly what the problem is "undefined variable db_connect", etc...
> #2 if you can't figure it out, someone here can easily if you give the
> errors.
> Virtually every problem you've posted throws an error(s) that will tell
> you what the F*** is the problem!
Ok, ok, I understant the frustrations....
But, yes, I think that some of the suggestions were rather hastily made
as most of the guys must be very busy and as we are all somewhat normal,
we do make mistakes. I mixed up some suggestions with other errors of
mine and so we had spaghetti. So, now let's kiss and make up... or as
the Italians would say, "Amici, come prima". :-)

I'm glad you mention the error reporting and I admit i haven't been
doing much of that. I do not understand how it should be set up or where
I should look for the errors.
I did try
but it meant absolutely nothing. I could not find any logs for mysql or
php errors and none appeared magically in the page.
Perhaps you could steer me to an explanation somewhere. I was able to
save some grief for all as I dif manage to find some guidelines on the
mysql manual site that were pretty helpful.
Thanks for your tolerance of my ignorance - love you all!


Phil Jourdan ---

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to