473,385 Members | 1,780 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

advise needed

Hi all.

First. I've no access to mysql NG, so I ask here.

We are looking for a system where user pay for having their article on
homepage.

Only 5 articles are shown every time.
The length of the service is 2 weeks.
The articles should be shown equally between clients.
If a user select a particular object in search engine, then coming back on
the homepage the shown article should reflect their need.

How to create a mysql query to get equally chances between articles ?

If only 2 announces of 5 are bought, I then want to fill the free places
with professionals articles.

I'd like to get random article from professionals, but not 2 articles from
the same pro. How to do so ? also with query (not with PHP)

If isn't possible, on PHP should I get all announces then try to find
randomly between results ?

Bob
Jul 17 '05 #1
0 1162

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: GM | last post by:
Hello... Please advise me where can I post a message about job seeking for the small developers team (ASP, XML/XSLT, *script skills)? Thanks a lot ahead. Please, advise me to:...
3
by: Michael Crawford | last post by:
Hi, Where would one start for this type of application: I want to create an vb.net container application that has the gives the end user the ability to install and uninstall plugins or add-in...
4
by: Craig Kenisston | last post by:
Hi, I'm an ex-Delphi developer and I'm used to the ModelMaker Case tool for Delphi. Now I'm starting a large project in C# and I need some help in design. I'm looking for case tools for...
0
by: serge calderara | last post by:
Dear all, We have some old application which collect data from different source and store those data in an access 97 database. I will cal those type of application "OLD APP" Those OLD APP are...
2
by: Mike Button | last post by:
Hello all, I am really really desperate on what I should do, and I am asking for help from anyone in this newsgroup, here's the situation: I am creating a form that is being run on a server...
13
by: Pedro Graca | last post by:
I'm sure this isn't very pythonic; comments and advice appreciated def curious(text): """ Return the words in input text scrambled except for the first and last letter. """ new_text = "" word...
11
by: garyusenet | last post by:
For this first time today I used the System.Diagnositcs namespace to launch a program from my c# code. The program launches OK but I have something which has completely stumped me. The...
2
by: Michael | last post by:
Hi, I try to use mysqli object instead of standard mysql functions. Is it ok to create mysqli object within my class or schould I pass mysqli object to my object. The problem is, with code...
13
by: Alexander Vasilevsky | last post by:
What ASP.Net hosting you advise me? http://www.alvas.net - Audio tools for C# and VB.Net developers
5
by: John | last post by:
Hi I have a third party telephony app that can inform of the any incoming call tel number by one of two methods; a) It can run a windows app with tel number passed as parameter, or b) It...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.