Thanks for that,
Maybe its just a personal thing but I always prefer to store dates as the Unix date rather than a date format and then format it accordingly on output.
Im lost as to how php isnt calculating these as it is the others?
Morning all,
I have a table containing 4k+ records each has a date stored as a text field in the format d/m/yy (ie 01/01/99 or could be 1/1/99).
Ive ran a script against the table to populate the UNIX date for each record using a straight forward logic of splitting the date into its day/month...
Apologies but again Im feeling dense.
I have already added then removed then added again the correct IP address to the Remote Access Hosts list.
Are you talking about something different to that when you say about using MySql Administrator and setting it for the user?
I cant seem to find...
Im going to sound dim because Ive never needed to do that before, the site is on shared hosting and I dont have command line access however if I attempt to do a flush privileges in phpMyAdmin I get an "Access denied you need the RELOAD permisson"
Just to give an update on the original problem...
Hi all,
I have a client on one server who logs into my content management system on another server, this CMS then connects to his database (on his server) to carry out the updates.
All was fine and dandy until yesterday.
My hosting company moved all sites over to a new server and as a result...
...each one as a calculation from a Query.
eg
Record 1 may have data values of 95.00, 3 and 20% while the calculation field holds:
([data1] * [data2]) * [data3]
While record 2 could be 15/04/2010 and 5 with the calculation being:
Add_weeks_function([data1],[data2]
The document then would...
Im not sure what you mean?
Ive created functions for the likes of calculating tax, bandwidths, National Insurance etc however I now need to store the links to these in a database so that I can run a report which will produce something along the lines of the link I've given you.
Basic business case is the production of a large number of test data documents. Currently each year we revise these documents with updated information. The calcuations are generally the same but certain figures need to change such as starting dates for the test, bandwidth levels etc.
One of the...
...For instance in its simplest form, the table could contain 3 fields
Data1
Data2
Calculation
You could enter
2
3
Data1 + Data2
or
2
3
(Data1 * Data2) + Data 1
Then set up queries to format output giving me
2 + 3 = 5
(2 * 3) + 2 = 8
The database Im looking at will be a fair bit more...
...of SMP_Weekly_Rate which would then be used to
a) populate that amount within the document and
b) calculate other values such as 4 weeks SMP = 4 * SMP_Weekly_Rate or a daily rate of SMP_Weekly_Rate / 7.
Ive written the calculations as a handful of functions within VBA however I cant seem...
Morning (or afternoon depending on where you are!)
I have a problem with a very basic session script.
I have two pages, page1 and page2, for debugging purposes currently each page starts with
session_start();
if(!isset($_SESSION['userid'])) {
echo "no session";
} else {
//do code for page...
Hi all,
For some reason our organisation decided to issue a 16 item Questionnaire to our members via an email rather than secure form. Now I have the task of collating the results which is proving to be a pain!
Basically, we sent a couple of paragraphs of text followed by the 16 Questions and...
HI,
I am attempting a straight forward join but cant seem to get it to work.
Two tables (fullsubs) and (towns) the fullsubs table holds among other things the UK postcode of the member. Table two contains the prefixes of postcodes (2 chars) and the correspoding town/city.
I want to get a...
Iwould also add a very simple one to look for in cases where links are appearing differently across browsers.
Make sure you havent visited the link in one of the browsers and not the other otherwise you'll be seeing any a:visited definition in one and a standard a: in the other.
That once...
I was originally going to use the google maps api but the AA site adds in traffic information such as location of speed cameras, current roadworks etc which is ideal for what I need it for.
I would have hoped that the data legalities wouldnt be a problem as I was just hoping to pass people to...
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.