On 28/3/03 11:44 am, "Philip J. Newman" <[EMAIL PROTECTED]> wrote:
> $mydate = "20030328231154";
>
> $myPrintDate=date ("l dS of F Y h:i:s A",$mydate);
>
> echo "$myPrintDate";
>
> Whats wrong
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/un
> $mydate = "20030328231154";
>
> $myPrintDate=date ("l dS of F Y h:i:s A",$mydate);
>
> echo "$myPrintDate";
>
> Whats wrong
$mydate should be a unix style timestamp not a MMDDHHMMSS type
date/time format...
Check the functions time() and mktime() to help you generate unix
timestamps.
HTH
R
$mydate = "20030328231154";
$myPrintDate=date ("l dS of F Y h:i:s A",$mydate);
echo "$myPrintDate";
Whats wrong
--
Philip J. Newman.
Head Developer
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
A MySQL timestamp is different to a MySQL timestamp.
$time = time(); will produce a unix timestamp
what you want is
$time = date('Y-m-d');
to give a value in the format -MM-DD
I think you can also use NOW():
$query = "INSERT INTO contacts (id, name, pass, email, dateAdded) VALUES
(NULL, '
show us your database table structure (the whole thing). the NOW() will always work
with a "date"
or "timestamp" field
- Original Message -
From: "- [ Paul Ferrie ] -" <[EMAIL PROTECTED]>
To: <>
Sent: Monday, January 06, 2003 11:28 AM
Subject:
Well i am still getting all the zero's
: ( : (
"- Edwin" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> "- [ Paul Ferrie ] -" <[EMAIL PROTECTED]> wrote:
> > So
> >
> > Is NOW() a mysql function?
>
> Well, you can check for yourself ;)
>
> It should
"- [ Paul Ferrie ] -" <[EMAIL PROTECTED]> wrote:
> So
>
> Is NOW() a mysql function?
Well, you can check for yourself ;)
It should be somewhere around here:
http://www.mysql.com/doc/en/Date_and_time_functions.html
- E
...[snip]...
__
So
Is NOW() a mysql function?
"Stephan Seidt" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> yep i guess that, so NOW() is a mysql function.
>
> - [ Paul Ferrie ] - wrote:
> > So Jason what your saying is this
> >
> > $query = "INSERT INTO contacts
On Tuesday 07 January 2003 00:49, - \[ Paul Ferrie \] - wrote:
> So Jason what your saying is this
>
> $query = "INSERT INTO contacts (id, name, pass, email, dateAdded) VALUES
>
> > (NULL, '$name', '$pass', '$email', '$time')";
>
> Should be
>
> $query = "INSERT INTO contacts (id, name, pass, email
yep i guess that, so NOW() is a mysql function.
- [ Paul Ferrie ] - wrote:
So Jason what your saying is this
$query = "INSERT INTO contacts (id, name, pass, email, dateAdded) VALUES
(NULL, '$name', '$pass', '$email', '$time')";
Should be
$query = "INSERT INTO contacts (id, name, pass, email
So Jason what your saying is this
$query = "INSERT INTO contacts (id, name, pass, email, dateAdded) VALUES
> (NULL, '$name', '$pass', '$email', '$time')";
Should be
$query = "INSERT INTO contacts (id, name, pass, email, dateAdded) VALUES
> (NULL, '$name', '$pass', '$email', NOW())";
??
cheers
On Tuesday 07 January 2003 00:19, - \[ Paul Ferrie \] - wrote:
> hey guys could someone help me
> I have created a user login register system in flash with PHP and Mysql.
> Everthing Now works fine aprt from the time stamp of when the user
> registered.
>
> Code ---
nope it still comes up with all the zero's
:(
"Stephan Seidt" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> What sort of mysql field type did you use for dateAdded ?
> You need UNIX_TIMESTAMP (or sth like that) for unix timestamp format.
>
> - [ Paul Ferrie ]
What sort of mysql field type did you use for dateAdded ?
You need UNIX_TIMESTAMP (or sth like that) for unix timestamp format.
- [ Paul Ferrie ] - wrote:
hey guys could someone help me
I have created a user login register system in flash with PHP and Mysql.
Everthing Now works fine aprt from th
hey guys could someone help me
I have created a user login register system in flash with PHP and Mysql.
Everthing Now works fine aprt from the time stamp of when the user
registered.
Code ---
// Get current date & time
$time = time();
// Connects to the Database.
$
MySQL syntax is MMDDHHMMSS or "-MM-DD HH:MM:SS"
---John Holmes...
- Original Message -
From: "Chuck Payne" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 18, 2002 11:25 AM
Subject: [PHP] Time Stamp
> Hi,
>
>
Hi,
I have a form that I am using to update a mysql table but I can get
timestamp to update. How can I pass that information to pass on. I have
"READ" all books and feel I have correct systax but it just not working...
This should pass the time right?
Chuck Payne
Magi Design and Support
-
I am using PHP with MySQL and have a timestamp field in my db table. What
would be the easiest way to get the newest timestamp out of the db?
Thanks in Advance
Steve
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
ow3
--
PHP G
18 matches
Mail list logo
