Use strtotime() to cast time string to a timestamp,
then the time can be formatted with date()
code green
Last Activity: Nov 21 '11, 04:59 PM
Joined: Mar 16 '07
Location: England
-
Maybe a two step process?
Use LOAD DATA LOCAL INFILE (although I have never used this) to import the data into a temporary table.
Then use INSERT INTO ..... ON DUPLICATE KEY UPDATE query to update the main tableLeave a comment:
-
I think the space in Program Files causes the problem.
It needs to be written Pro~1 or something like that.
Please research this, because although I have experienced the problem I can only vaguely remember the details...Leave a comment:
-
You can write HTML to a xls file.
Write as one big string or multiple strings to the file and saves as .xls.
Tables and fonts will appear no problem, but formatting needs to be inline as css file cannot be seen.
Pictures are trickier but can be doneLeave a comment:
-
Do you have a database called `mysql` within the MySQL environment?
Does this have a proc table?Code:SHOW DATABASES
Does the table have any stored proceduresCode:SHOW TABLES FROM mysql
Code:SELECT * FROM mysql.proc
Leave a comment:
-
I tend to use static methods for commonly used utility functions.
I'm not sure about static variables though, these are almost global.
A more OOP way I suppose would be an abstract class from which other classes inherit, but as the other classes are unrelated this doesn't seem logical.
I am also intersted in any other solutions provided.Leave a comment:
-
Did you not read my post?
They are not 'set' for any particular database.
They are system procedures and the standard seems to be that they are stored in the `mysql` database in a table called `proc`.
You can query this database like any other.Leave a comment:
-
They are not stored in your database.
Well I can only speak for phpMyAdmin, the procedures are stored in a table called `proc` in the system database `mysql`Leave a comment:
-
It looks OK, although which ntwdblib.dll do you have?
version 2000.2.8.0 does not work on server 2005.
You need version 2000.80.194.0.
Maybe it is your DNS, try the ip address rather than domain name 123.45.678.90Leave a comment:
-
code green replied to Parse error: syntax error, unexpected T_STRING in C:\wamp\www\fuction\conn.php on linin PHPYou have missed closing an opened quotationLeave a comment:
-
SEESION is useful for this type of problemLeave a comment:
-
I suggest some error trapping in there to find at what point it is failing.
Also try simple test code to check there is communication between each interface.
Sometimes the connectivity needs a bit of a kick, I used to send the port high tnen low then high again, and variations of to 'wake up' the chip.Leave a comment:
-
You need UPDATE with a JOIN.
There are about three ways of writing the query, I am not sure which if not all are valid in Access. But basicallyCode:UPDATE table1 JOIN table2 ON table1.id = table2.id SET table1.field1 = table2.field1 WHERE table1.field2 = table2.field2
Leave a comment:
-
Unlees you really need to, images are better stored directly on the server.
Then in your table have an extra column that stores the filename.
The database can quickly grow storing blob data.Leave a comment:
-
No idea without any code, but possible pitfalls are:
case sensitive filenames,
directory structure,
back/forward slashesLeave a comment:
-
You have chopped the error message that indicates the problem.
It looks like you are overwriting the element so try...Code:if(!isset($_SESSION['UserName_Ses']) ['UserName_Ses'] = "";
Leave a comment:
-
Solved. It is escaped with a double percent like so '%%'Leave a comment:
-
Keep % sign using sprintf()
I use %s as placeholders in a text file and something likeTo read a line.Code:$line = sprintf(fgets($fp),$tc,$tc);
So $tc will replace %s in $line.
But if line contains "charge a 2% surcharge" then $tc also replaces the '%'.
How do I get round this and leave '%' untouched and only replace '%s'?
Tried backslash, that doesn't work -
Radio buttons ARE a choose only one option. You need to use checkboxesLeave a comment:
-
Interesting link William.
I'm afraid I could not understand the OP last questionLeave a comment:
No activity results to display
Leave a comment: