RE: [PHP-DB] SQL Guru Question:
| From: | Snijders, Mark | Date: | Tue, 26 Nov 2002 12:31:27 +0000 |
| Subject: | RE: [PHP-DB] SQL Guru Question: | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-23669@lists.php.net to get a copy of this message | ||
don't think it won't work all in mysql... but what db are we talking about?
Well, have you tried it like that?
If that doesn't work you could try this:
select
@calc:=(round(pr_contents * 12)+ round(pr_buildings * 12)),
(@calc * .33) as agent,
(@calc * .5) as manager
from pipeline
Regards
Joakim
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php