> Jokes aside, I still don't get it.
=the word "it" is part of the difficulty everyone faces in thinking about whether they
could help or not - what
"it" is, is not apparent
1 there is a problem with a mysql_pconnect() call, and
2 there is a problem with a mysql_query() call.
Which one is "it"?
=the confusing presentation of the question, even more confused by the lack of
substance/focus in the rejoinder,
is not helping.
=the very first suggestion that those who have answered more-or-less this exact
'pconnect' question many times a
week for ..., is a not-so-subtle hint to RTFM (and/or to review the list archives).
When you read up about how
to write variables and constants, and how to use the mysql_... functions, then more
will become obvious, and
less sarcasm will come your way.
=worse, you have quoted incomplete/inaccurate code fragments, so immediately the
question arises: "what else has
been left out?" (the answer being closely related to "it").
=The manual clearly says that missing out certain calls may not matter because MySQL
will make assumptions and
attempt to carry on, but the instant problems arise, surely it would be better to
follow all the examples in the
manual - which step through all of the calls, in sequence?
=next point: if you have a problem with a series of instructions, go back to first
principles, break things down
and throw in echo/printr statements to 'prove' any and all assumptions - particularly
the first time you try out
some code.
=last point: EVERY call to a client-server function should be checked (there's RTFM
again), this will show if
the fault lies at 'pconnect', at 'open', and/or at the 'query' stage.
=dn
PS lecture mode off - please take advantage of our 'two-fer' special offer: any two
well formed questions sent
to the list this week will be answered for the same price as one!
> $host = "localhost";
> $MyAccount = "AccountName";
> $MyTable = "Table1";
> $MyPassword = "beep";
>
> This works:
> mysql_pconnect($host,"AccountName","beep");
> $news = mysql_query("SHOW TABLE STATUS FROM AccountName LIKE 'Table1'");
>
> Why doesn;'t this?
>
> $myconnection = mysql_pconnect($host,$MyTable,$MyPassword);
> ...
> $news = mysql_query("SHOW TABLE STATUS FROM $MyAccount LIKE
> '$MyTable'");
>
> I have tried variations with or without " and '. Is there a way to make this
> work? Or do I have to do as above every time?
>
> > >"$host" :)
>
> Your telling me to put $host in "$host"? OK:
>
> $myconnection = mysql_pconnect("$host","$MyAccount","$MyPassword");
>
> It doesn't work?! Neither does:
>
> $myconnection = mysql_pconnect($host,$MyAccount,$MyPassword);
> $myconnection = mysql_pconnect('$host','$MyAccount','$MyPassword');
>
> If I try this, $stringing just $host, it works!?
>
> mysql_pconnect($host,"AccountName","beep");
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
