Re: Passing Variables
| From: | Michael Virnstein | Date: | Thu, 23 May 2002 14:34:35 +0000 |
| Subject: | Re: Passing Variables | ||
| References: | 1 | Groups: | php.general php.windows |
| Request: | Send a blank email to php-general+get-98918@lists.php.net to get a copy of this message | ||
$this usually is a self-reference inside a class.
Use it with care!
try to "echo $sql;", perhaps this tells you more.
Regards Michael
"James Opere" <J.OPERE@CGIAR.ORG> schrieb im Newsbeitrag
news:FC788AB9771FD6118E6F0002A5AD7B8F7268AB@ICRAFNTTRAIN...
> Hi All,
> I'm trying to pass variables from one form to the other.I have a problem
> when i want to do the the following:
> 1.COUNT($variable)
> 2.DISTINCT($variable)
> .............
> I realise i can not use the brackets in my query and the variable be
> recognised.When i add COUNT without the brackets i still get an error.
> Example.
> test.html
> <form action="me.php" method="post">
> <input type="text" name="this">
> ..............
> This is sent to :
>
> me.php
> <?php
> $db=mysql_connect('localhost','','');
> mysql_select_db($database,$db);
> $sql="select COUNT($this) from $table group by $this";
> ................
> ?>
> This gives an error.
> Please help.
>