Re: MySQL Question
| From: | stephan dot schoell at chhos dot mail dot abb dot com | Date: | Wed, 05 Jul 2000 15:13:14 +0000 |
| Subject: | Re: MySQL Question | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-4974@lists.php.net to get a copy of this message | ||
do any of you know if this command will work in a MySQL query:
AND impression <= impressionmax AND click <= clickmax
???
Where do impression, impressionmax, click and maxclick come from? Are they db
fields? If yes, it should work. But if you would like to refer to scripts
variables (e.g. $impressionmax, $clickmax) you should write:
select * from tbl_blah where row1='hello'
AND impression <= '$impressionmax' AND click <= '$clickmax'
or - if they are numerical values -
AND impression <= $impressionmax AND click <= $clickmax
In any case: the mysql manual tells you everything!
HTH
-Steff
webmaster@posh.ch
www.posh.ch