Hi guys,
I'll answer this and the previous mail.
First, thanks for the insight.
1. There is such a function as "mysql" whose arguments are
mysql("database","query",[resource id])
very useful as it avoids having to call mysql_connect_db()
As for printing the query, I had done that, and everything was fine. I have
however, found the problem!
(sorry about the waste of bandwidth, but maybe someone will avoid making the
same mistake).
The problem was not related to variable scope, but rather because the
variable "1234" had some HTML formatting added to it somewhere in the
script.
The problem, evidently, is that echoing the variable didn't show the html
formatting (it was something like "<font color=black>" in an obvious way!
I wish there were a php debugger.
Again, thanks for the suggestions,
Martin
"CC Zona" <[EMAIL PROTECTED]> wrote in message
9cs5ef$6js$[EMAIL PROTECTED]">news:9cs5ef$6js$[EMAIL PROTECTED]...
> In article <9crr9l$4c4$[EMAIL PROTECTED]>,
> [EMAIL PROTECTED] ("martin helie") wrote:
>
> > assuming:
> >
> > $var="1234"; (type does not seem to matter)
> >
> > this query returns no error, but no result either:
> >
> > mysql("database","SELECT * FROM table WHERE id='$var'");
>
> When you call mysql_query is it perhaps from inside a function, where
> variable $var has not been passed or made global?
>
> (BTW, whenever you experience problems with a query, it's a good idea to
> echo the query string to the browser. Often, this simple step makes it
> very clear where the problem lies. Using mysql_error() and $php_errormsg
> on a query failure also can give you very useful information.)
>
> --
> CC
>
> --
> PHP Database 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 Database 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]