RE: limit stop count

2004-03-17 Thread Rogers, Dennis
SELECT COUNT(*) FROM tbl WHERE where_clause limit 200; -Original Message- From: Lorderon [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 17, 2004 6:45 PM To: [EMAIL PROTECTED] Subject: limit stop count How can I limit a count to stop when he reaches 200 rows? SELECT COUNT(*) FROM tbl

Query help - add results then divide by

2004-02-25 Thread Rogers, Dennis
Good afternoon, How can I take the 3 results below add them together then divide by 131.77? Can it all be done in one SQL statement? Thanks in advance. mysql describe ads; +---+---+--+-+++

RE: Query help - add results then divide by

2004-02-25 Thread Rogers, Dennis
Thanks so much!! SELECT (SUM(( ads.col * 1.91) * ads.depth ) / 131.77) * 100 FROM ads WHERE date = '2004-02-26' AND editionID = '13' AND ads.page = '16' -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 5:55 PM To: Rogers, Dennis Cc

RE: mysql Digest 16 Jun 2003 00:46:21 -0000 Issue 2497

2003-06-15 Thread Rogers, Dennis
How do I unsub from this list? The unsub link doesn't work? ?php If( $_POST['beer'] == 24) { echo(Life is good!); exit(1); ? } echo(Quick it's all most closing time!!!); more_help(); ? -Original Message- From: [EMAIL PROTECTED]