Hi I asked a question and had a response and answer within the hour - I will try my lucj and ask another
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********" Regards John Berman [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
