Thanks Julie
This is exactly what I required, I thought it might have been quite simple to do but not quite that easy, but thank you for taking the time to reply and pointing me in the right direction
very best regards
Stewart
hi
I cant seem to find answer to my question ( but my apologies if this has been answeredvefore)so here goes
I would like to have groups of resources
ie
Engineers, welders etc, each group would have a max number eg 10 mech
engineers 10 elec engineers, 20 welders etc
when allocating...
Both lid field and matchid
lid tells me which league they all belong to (in this case is No 1 this is common)and the matchid is the game number which gives me the number 381(which also corresponds to the enry number in the db), I need to change the time section of the matchdate field by -7 hours...
Hi sorry for not giving enough info, hope this helps
This is my table
`lid` int(11) NOT NULL,
`matchid` int(11) NOT NULL auto_increment,
`matchdate` datetime NOT NULL,
`hometeam` varchar(30) NOT NULL,
`awayteam` varchar(30) NOT NULL,
`homescore` smallint(5) unsigned default NULL...
Please could someone offer advise on how to update a fields within an sql database
The fields contains date and time
in this format "2005-10-17 08:00:00"
I require to update 381 consecutive entries with individual entry data out of around 700 or so
Could someone offer the correct syntax I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.