Monday, January 19, 2009

MySQL the demand

Customer: [Aksarin] Constantine (mihakot)
Category: Scripts/of the Web- application
Budget: 10 USD there is a table with the news. Each news has a field of int c by the certain number. Task. It is necessary to select all news in which: 1. number in this field of more than determined. (it is assigned originally) 2. during the day must not be more than 2-3 news. (in the day must not be more than 3 news. the period of [vyborki] recent days ORDER BY Of date DESC) 3. in all is selected 8-9 news. 4. by one demand. Propose versions. The first proposed working result wins. [z].[y]. of proposal of the type SELECT * OF FROM of devki WHERE of chislo>5 LIMIT 9 are sent immediately. Read conditions. If understandably do not ask.http: / / www.weblancer.net / projects / 92039.html

No comments: