Started in 1980 with BASIC on a Sinclair ZX80. Various flavours of BASIC later, went to Uni and did a final year project using a dynamically assigned 48 processor array (Transputers - who remembers them?) to calculate fractals, stint in support, LAMP stack coder from 2004, never looked back.

Kids nowadays eh? They've got it easy! GUI? I'd have killed for a GUI! We had to code on clay tablets

Apr
27
awarded php
Mar
7
comment two kind of date formats data loaded on mysql field
You've said that the old format is d-m-Y but is the year stored as a two or four digit number? If the former, there's not a lot you can do for dates from 2001 onwards. If the latter, a simple update with some text extraction/concatenation functions should sort your data out. Again, what have you tried so far?
Mar
7
comment two kind of date formats data loaded on mysql field
What have you tried so far? Is the only data in the table from the legacy table, or has new data been added to it since import? What sort of solution are you looking for? How do you identify legacy data? etc
Feb
24
reviewed Approve suggested edit on How to keep track of sub-second time
Feb
24
reviewed Approve suggested edit on How to test function depending on other objects in jasmine unit test
Feb
24
reviewed Approve suggested edit on Publish-AzureRmVMDscConfiguration create archive with duplicate and nested modules
Feb
24
reviewed Approve suggested edit on SharePoint Foundation 2010 Client Object Model Authentication
Feb
24
reviewed Approve suggested edit on How to renumber primary index
Jan
19
reviewed Approve suggested edit on jQuery can't catch keyup target element in designmode
Jan
19
reviewed Approve suggested edit on How to change the source of an image with htaccess?
Jan
19
reviewed Approve suggested edit on PHP code optimization technique during echo statement
Jan
14
reviewed Approve suggested edit on How to get the Tor ExitNode IP with Python and Stem
Jan
14
reviewed Approve suggested edit on How can I get all a form's values that would be submitted without submitting
Jan
12
reviewed Approve suggested edit on How to increase UINavigationBar height?
Jan
12
reviewed Approve suggested edit on Yii2 ActiveRecord sorting by translatable field
Jan
11
reviewed Approve suggested edit on Unexpected number of decimals result from integer division SQL query
Jan
11
reviewed Approve suggested edit on Is there any "vqmod" to allow multiple image uploading?
Dec
6
comment How to create a linked mysql database
To try speeding up, add an index on the timestamp field. It'll increase storage requirements but speed up your query. Also, as @FélixGagnon-Grenier said, if it's taking 10 hours to run, you have other problems that you need to fix
Dec
4
answered How to create a linked mysql database
Nov
30
comment PHP Check if multiple conditions are true
Your answer is very confusing. You never take into account what would happen if both iron and gold are above 500. Your level checking of gold and iron in two different orders is redundant (remove all the brackets and you're left with a simple set of or conditions) and you should be checking for < rather than >. You should check for the success first (gold and iron both above 500) and then, if this fails, check which ones failed.
1 2 3 4 5