Search results for query: *

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...

yes the calculation would need to be performed.

Sorry but I mustnt be putting across the query very well. I have written many a VBA function for this, all of these functions can and are used in Queries. What I want to do is have a table which stores 500 or so different records, each record will have at least one data value (but usually...

Apologies, Access

emmm the one this thread is related to.

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...

Hi all, The heading probably doesnt make it clear at all what Im after, I want to setup a database which will allow the user to enter a calculation within a field. For instance in its simplest form, the table could contain 3 fields Data1 Data2 Calculation You could enter 2 3 Data1 + Data2...

Hi, I have inherited a large document which needs to be updated annually (it relates to Statutory Payments in UK PAYE). Dates and values need to be updated which is a real pain time wise. Im looking to automate as much as possible so because a number of things are repeated within the document...

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...

Thank you

I now get a "#1054 - Unknown column 'postcode' in 'where clause'" error.

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...