[cobalt-users] All the way from Germany...

["Steve Boardwell" <ste_vo2@xxxxxxxxxxx>]

Hi, It seems to say on the internet that you guy/s are regular profis with 
SQL and such so I was wondering if you could help me with some mySQL 
programming. I have a table that looks like this:
id
Xcoord
Ycoord
loadtime
loadtimeindex

loadtimeindex should be as follows;
loadtime < 1001 loadtimeindex = 1
loadtime 1000<2001 loadtimeindex = 2
loadtime 2000<4001 loadtimeindex = 3
loadtime 4000<6001 loadtimeindex = 4
loadtime 6000<10001 loadtimeindex = 5
Now, loadtime is a figure between 1 and 10000. When I type in a loadtime, i 
would like that a loadtimeindex is entered aswell. or that loadtime is 
recoded to something like the above. is this possible? if so, how?

Many thanx in advance,

Ste Boardwell (i know it doesn't sound German, I'm studying over here :-) )
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.