Hi.
On Sun 2002-08-18 at 11:13:36 +0100, [EMAIL PROTECTED] wrote:
>
> I asked a question and had a response and answer within the hour - I
> will try my lucj and ask another
Well, but never forget that you ask for other's time, so be sure to
have made your homework first and really cannot come up with an own
solution.
> In my table I have amongst other things two fields ProjectPrice and
> ProjectBalance and in this example they are currently
>
> Projectprice = 100
> Projectbalance = 90
>
> Now I only want my select statement to work if project balance it at
> least or greater than 90% of the Projectprice - Im sure this must be
> possible
>
>
> sqlst = "select * FROM sfProducts WHERE ****the calculation********"
Well, that is basic mathematics:
... WHERE Projectbalance >= 90/100 * Projectprice
Regards,
Benjamin.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
