Hiya,
I have a database about projects in a company, they all have a start
year and end year. If the projects have not ended then they get a end year
of 0000. I have made a SQL command, given a year, works out with projects
are running in that year.
The company I am doing this for, wants basically a drop down box which
says (1950- 8 Projects) and such like. Now with the current command I have
it would mean 92or so SQL commands as the company has records back to 1910.
Is there a way to do this in one command? I have searched all the
mannual and I can work out something similair to a for loop in SQL. Would
variables help?
Any help would be greatly appreciated.
Have a great New Year.
Steve
---------------------------------------------------------------------
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
