mysqli_select_db() expects exactly 2 parameters, 1 given

mysqli_select_db() expects exactly 2 parameters, 1 given

am 25.05.2007 22:33:06 von Bob Lockie

I do: $db = mysqli_select_db( $database_name );
I get this error: HP Warning: mysqli_select_db() expects exactly 2
parameters, 1 given

I have MySQL server version: 4.1.22 and PHP 5.2.2.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: mysqli_select_db() expects exactly 2 parameters, 1 given

am 25.05.2007 22:43:47 von Dave W

mysqli_select_db requires the connection to be in the first argument. So:
$link = mysqli_connect('blah','blah','blah');
$db = mysqli_select_db($link,$db_name);

James Lockie wrote:
> I do: $db = mysqli_select_db( $database_name );
> I get this error: HP Warning: mysqli_select_db() expects exactly 2
> parameters, 1 given
>
> I have MySQL server version: 4.1.22 and PHP 5.2.2.
>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: mysqli_select_db() expects exactly 2 parameters, 1 given

am 25.05.2007 22:46:39 von Bob Lockie

David Weitz wrote:
> mysqli_select_db requires the connection to be in the first argument. So:
> $link = mysqli_connect('blah','blah','blah');
> $db = mysqli_select_db($link,$db_name);
>
> James Lockie wrote:
>> I do: $db = mysqli_select_db( $database_name );
>> I get this error: HP Warning: mysqli_select_db() expects exactly 2
>> parameters, 1 given
>>
>> I have MySQL server version: 4.1.22 and PHP 5.2.2.
>>
>
It is not plugin compatible with the mysql_ calls. :-(

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Notice: A non well formed numeric value encountered

am 22.09.2007 16:18:02 von Stephen Sunderlin

I'm getting the above NOTICE with the following statement:
Echo date('d/m/y',$CTS);

Where $CTS = 2007-09-22 10:09:31

And 31/12/69 is being echoed.


PHP 5.2.1
MYSQL 5.0.37-community-nt via tcp/ip

Thanks in advance for any insight.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: Notice: A non well formed numeric value encountered

am 22.09.2007 17:12:32 von Naintara

I don't see the NOTICE message.
Perhaps a timezone notice?

Lookup the date() function in the php manual.
The time parameter should be a unix timestamp value, so $CTS should contain
an integer value.
You can also find ways to convert the time value you have to unix
timestamp, in the manual.

-----Original Message-----
From: Stephen Sunderlin [mailto:stephen.sunderlin@verizon.net]
Sent: Saturday, September 22, 2007 7:48 PM
To: 'PHP-DB Mailing List'
Subject: [PHP-DB] Notice: A non well formed numeric value encountered

I'm getting the above NOTICE with the following statement:
Echo date('d/m/y',$CTS);

Where $CTS = 2007-09-22 10:09:31

And 31/12/69 is being echoed.


PHP 5.2.1
MYSQL 5.0.37-community-nt via tcp/ip

Thanks in advance for any insight.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: Notice: A non well formed numeric value encountered

am 22.09.2007 17:54:05 von Stephen Sunderlin

Thank you for your response.

The notice is in the Subject Line of the email:
Notice: A non well formed numeric value encountered

So you are saying I have to convert the current yyyy-mm-dd:HH:MM:SS date
format, to UNIX timestamp value then call Date() to format the UNIX
timestamp as Month, Day, Year?

If so, is it recommended to do that at the database level or the program
level.

I guess it would make sense to convert all dates to UNIX timestamp for
database storage then convert at necessary.

Any insight would be helpful.

Thanks!

-----Original Message-----
From: Naintara [mailto:naintara@vismaya.info]
Sent: Saturday, September 22, 2007 11:13 AM
To: 'PHP-DB Mailing List'
Subject: RE: [PHP-DB] Notice: A non well formed numeric value encountered

I don't see the NOTICE message.
Perhaps a timezone notice?

Lookup the date() function in the php manual.
The time parameter should be a unix timestamp value, so $CTS should contain
an integer value.
You can also find ways to convert the time value you have to unix
timestamp, in the manual.

-----Original Message-----
From: Stephen Sunderlin [mailto:stephen.sunderlin@verizon.net]
Sent: Saturday, September 22, 2007 7:48 PM
To: 'PHP-DB Mailing List'
Subject: [PHP-DB] Notice: A non well formed numeric value encountered

I'm getting the above NOTICE with the following statement:
Echo date('d/m/y',$CTS);

Where $CTS = 2007-09-22 10:09:31

And 31/12/69 is being echoed.


PHP 5.2.1
MYSQL 5.0.37-community-nt via tcp/ip

Thanks in advance for any insight.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: Notice: A non well formed numeric value encountered

am 22.09.2007 18:48:58 von Naintara

That's a good question.

I'm really not sure about which way is better, but yes, you could use
UNIX_TIMESTAMP() to query a datetime value from a MySQL field, convert it
to the UNIX timestamp value within the query, and then retrieve it in your
record set.
UNIX_TIMESTAMP() [MySQL function]

Or you could use php to convert a datetime value to UNIX timestamp.
mktime() [php function]

You could store the timestamp value in the database itself, and convert at
will in the program.
So many choices... I really wouldn't know which to recommend, a lot depends
on usage. The datetime column takes more storage than an integer column,
but it's human-readable.

If you mean storing an timestamp integer value in a particular database
field, that should also be fine.

There are a whole lot of issues with datetime related functions, like DST
(daylight savings time) or timezones, if all that is critical, you may look
into it.
There is a TIMESTAMP field type in MySQL, the usage has changed in MySQL
4.1 and up.
This is useful for recording time/date of db updates.

For usual work, I find that a datetime data type column works for me.
Then, if I know what I will be using the datetime value for, I sometimes
format the date within the query itself using DATE_FORMAT() as I like to
get the results that way rather than change it, of course, if you may be
presenting the datetime value in different ways, or if you want the
flexibility, then use php.

I hope this helps somewhat.

-----Original Message-----
From: Stephen Sunderlin [mailto:stephen.sunderlin@verizon.net]
Sent: Saturday, September 22, 2007 9:24 PM
To: 'Naintara'; 'PHP-DB Mailing List'
Subject: RE: [PHP-DB] Notice: A non well formed numeric value encountered

Thank you for your response.

The notice is in the Subject Line of the email:
Notice: A non well formed numeric value encountered

So you are saying I have to convert the current yyyy-mm-dd:HH:MM:SS date
format, to UNIX timestamp value then call Date() to format the UNIX
timestamp as Month, Day, Year?

If so, is it recommended to do that at the database level or the program
level.

I guess it would make sense to convert all dates to UNIX timestamp for
database storage then convert at necessary.

Any insight would be helpful.

Thanks!

-----Original Message-----
From: Naintara [mailto:naintara@vismaya.info]
Sent: Saturday, September 22, 2007 11:13 AM
To: 'PHP-DB Mailing List'
Subject: RE: [PHP-DB] Notice: A non well formed numeric value encountered

I don't see the NOTICE message.
Perhaps a timezone notice?

Lookup the date() function in the php manual.
The time parameter should be a unix timestamp value, so $CTS should contain
an integer value.
You can also find ways to convert the time value you have to unix
timestamp, in the manual.

-----Original Message-----
From: Stephen Sunderlin [mailto:stephen.sunderlin@verizon.net]
Sent: Saturday, September 22, 2007 7:48 PM
To: 'PHP-DB Mailing List'
Subject: [PHP-DB] Notice: A non well formed numeric value encountered

I'm getting the above NOTICE with the following statement:
Echo date('d/m/y',$CTS);

Where $CTS = 2007-09-22 10:09:31

And 31/12/69 is being echoed.


PHP 5.2.1
MYSQL 5.0.37-community-nt via tcp/ip

Thanks in advance for any insight.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: Notice: A non well formed numeric value encountered

am 22.09.2007 19:07:43 von Stephen Sunderlin

I have 3 Timestamp fields in a contact manager that record Edit date, Create
Date and Merge Date. Doesn't matter to me how it is stored at this point
however when I tried to call it up as just Month, Day, Year (with out the
timestamp) in php I got the "A non well formed numeric value encountered"
NOTICE.

You say I can convert a mysql timestamp value at will in the program (which
I think I am trying to do) and it is not working. Must I convert it with a
MYSQL function or a PHP function.

Any other ideas?

-----Original Message-----
From: Naintara [mailto:naintara@vismaya.info]
Sent: Saturday, September 22, 2007 12:49 PM
To: 'PHP-DB Mailing List'
Subject: RE: [PHP-DB] Notice: A non well formed numeric value encountered

That's a good question.

I'm really not sure about which way is better, but yes, you could use
UNIX_TIMESTAMP() to query a datetime value from a MySQL field, convert it
to the UNIX timestamp value within the query, and then retrieve it in your
record set.
UNIX_TIMESTAMP() [MySQL function]

Or you could use php to convert a datetime value to UNIX timestamp.
mktime() [php function]

You could store the timestamp value in the database itself, and convert at
will in the program.
So many choices... I really wouldn't know which to recommend, a lot depends
on usage. The datetime column takes more storage than an integer column,
but it's human-readable.

If you mean storing an timestamp integer value in a particular database
field, that should also be fine.

There are a whole lot of issues with datetime related functions, like DST
(daylight savings time) or timezones, if all that is critical, you may look
into it.
There is a TIMESTAMP field type in MySQL, the usage has changed in MySQL
4.1 and up.
This is useful for recording time/date of db updates.

For usual work, I find that a datetime data type column works for me.
Then, if I know what I will be using the datetime value for, I sometimes
format the date within the query itself using DATE_FORMAT() as I like to
get the results that way rather than change it, of course, if you may be
presenting the datetime value in different ways, or if you want the
flexibility, then use php.

I hope this helps somewhat.

-----Original Message-----
From: Stephen Sunderlin [mailto:stephen.sunderlin@verizon.net]
Sent: Saturday, September 22, 2007 9:24 PM
To: 'Naintara'; 'PHP-DB Mailing List'
Subject: RE: [PHP-DB] Notice: A non well formed numeric value encountered

Thank you for your response.

The notice is in the Subject Line of the email:
Notice: A non well formed numeric value encountered

So you are saying I have to convert the current yyyy-mm-dd:HH:MM:SS date
format, to UNIX timestamp value then call Date() to format the UNIX
timestamp as Month, Day, Year?

If so, is it recommended to do that at the database level or the program
level.

I guess it would make sense to convert all dates to UNIX timestamp for
database storage then convert at necessary.

Any insight would be helpful.

Thanks!

-----Original Message-----
From: Naintara [mailto:naintara@vismaya.info]
Sent: Saturday, September 22, 2007 11:13 AM
To: 'PHP-DB Mailing List'
Subject: RE: [PHP-DB] Notice: A non well formed numeric value encountered

I don't see the NOTICE message.
Perhaps a timezone notice?

Lookup the date() function in the php manual.
The time parameter should be a unix timestamp value, so $CTS should contain
an integer value.
You can also find ways to convert the time value you have to unix
timestamp, in the manual.

-----Original Message-----
From: Stephen Sunderlin [mailto:stephen.sunderlin@verizon.net]
Sent: Saturday, September 22, 2007 7:48 PM
To: 'PHP-DB Mailing List'
Subject: [PHP-DB] Notice: A non well formed numeric value encountered

I'm getting the above NOTICE with the following statement:
Echo date('d/m/y',$CTS);

Where $CTS = 2007-09-22 10:09:31

And 31/12/69 is being echoed.


PHP 5.2.1
MYSQL 5.0.37-community-nt via tcp/ip

Thanks in advance for any insight.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: Notice: A non well formed numeric value encountered

am 22.09.2007 19:33:36 von Naintara

I think for now you can use the MySQL function DATE_FORMAT()
This would work well for your columns. Look it up in the MySQL reference,
it's very easy to use.

You'll have something like contact_created_date
If a contact was created today, it'll be something like
SELECT DATE_FORMAT(contact_created_date, '%M %d, %Y');

=>September 22, 2007

Where contact_created_date is your field.

-----Original Message-----
From: Stephen Sunderlin [mailto:stephen.sunderlin@verizon.net]
Sent: Saturday, September 22, 2007 10:38 PM
To: 'Naintara'; 'PHP-DB Mailing List'
Subject: RE: [PHP-DB] Notice: A non well formed numeric value encountered

I have 3 Timestamp fields in a contact manager that record Edit date,
Create
Date and Merge Date. Doesn't matter to me how it is stored at this point
however when I tried to call it up as just Month, Day, Year (with out the
timestamp) in php I got the "A non well formed numeric value encountered"
NOTICE.

You say I can convert a mysql timestamp value at will in the program (which
I think I am trying to do) and it is not working. Must I convert it with a
MYSQL function or a PHP function.

Any other ideas?

-----Original Message-----
From: Naintara [mailto:naintara@vismaya.info]
Sent: Saturday, September 22, 2007 12:49 PM
To: 'PHP-DB Mailing List'
Subject: RE: [PHP-DB] Notice: A non well formed numeric value encountered

That's a good question.

I'm really not sure about which way is better, but yes, you could use
UNIX_TIMESTAMP() to query a datetime value from a MySQL field, convert it
to the UNIX timestamp value within the query, and then retrieve it in your
record set.
UNIX_TIMESTAMP() [MySQL function]

Or you could use php to convert a datetime value to UNIX timestamp.
mktime() [php function]

You could store the timestamp value in the database itself, and convert at
will in the program.
So many choices... I really wouldn't know which to recommend, a lot depends
on usage. The datetime column takes more storage than an integer column,
but it's human-readable.

If you mean storing an timestamp integer value in a particular database
field, that should also be fine.

There are a whole lot of issues with datetime related functions, like DST
(daylight savings time) or timezones, if all that is critical, you may look
into it.
There is a TIMESTAMP field type in MySQL, the usage has changed in MySQL
4.1 and up.
This is useful for recording time/date of db updates.

For usual work, I find that a datetime data type column works for me.
Then, if I know what I will be using the datetime value for, I sometimes
format the date within the query itself using DATE_FORMAT() as I like to
get the results that way rather than change it, of course, if you may be
presenting the datetime value in different ways, or if you want the
flexibility, then use php.

I hope this helps somewhat.

-----Original Message-----
From: Stephen Sunderlin [mailto:stephen.sunderlin@verizon.net]
Sent: Saturday, September 22, 2007 9:24 PM
To: 'Naintara'; 'PHP-DB Mailing List'
Subject: RE: [PHP-DB] Notice: A non well formed numeric value encountered

Thank you for your response.

The notice is in the Subject Line of the email:
Notice: A non well formed numeric value encountered

So you are saying I have to convert the current yyyy-mm-dd:HH:MM:SS date
format, to UNIX timestamp value then call Date() to format the UNIX
timestamp as Month, Day, Year?

If so, is it recommended to do that at the database level or the program
level.

I guess it would make sense to convert all dates to UNIX timestamp for
database storage then convert at necessary.

Any insight would be helpful.

Thanks!

-----Original Message-----
From: Naintara [mailto:naintara@vismaya.info]
Sent: Saturday, September 22, 2007 11:13 AM
To: 'PHP-DB Mailing List'
Subject: RE: [PHP-DB] Notice: A non well formed numeric value encountered

I don't see the NOTICE message.
Perhaps a timezone notice?

Lookup the date() function in the php manual.
The time parameter should be a unix timestamp value, so $CTS should contain
an integer value.
You can also find ways to convert the time value you have to unix
timestamp, in the manual.

-----Original Message-----
From: Stephen Sunderlin [mailto:stephen.sunderlin@verizon.net]
Sent: Saturday, September 22, 2007 7:48 PM
To: 'PHP-DB Mailing List'
Subject: [PHP-DB] Notice: A non well formed numeric value encountered

I'm getting the above NOTICE with the following statement:
Echo date('d/m/y',$CTS);

Where $CTS = 2007-09-22 10:09:31

And 31/12/69 is being echoed.


PHP 5.2.1
MYSQL 5.0.37-community-nt via tcp/ip

Thanks in advance for any insight.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: Notice: A non well formed numeric value encountered

am 22.09.2007 19:57:09 von Stephen Sunderlin

Naintara,

That worked!

I must have made a syntax error.

Thank you!

-----Original Message-----
From: Naintara [mailto:naintara@vismaya.info]
Sent: Saturday, September 22, 2007 1:34 PM
To: 'Stephen Sunderlin'
Cc: 'PHP-DB Mailing List'
Subject: RE: [PHP-DB] Notice: A non well formed numeric value encountered

I think for now you can use the MySQL function DATE_FORMAT()
This would work well for your columns. Look it up in the MySQL reference,
it's very easy to use.

You'll have something like contact_created_date
If a contact was created today, it'll be something like
SELECT DATE_FORMAT(contact_created_date, '%M %d, %Y');

=>September 22, 2007

Where contact_created_date is your field.

-----Original Message-----
From: Stephen Sunderlin [mailto:stephen.sunderlin@verizon.net]
Sent: Saturday, September 22, 2007 10:38 PM
To: 'Naintara'; 'PHP-DB Mailing List'
Subject: RE: [PHP-DB] Notice: A non well formed numeric value encountered

I have 3 Timestamp fields in a contact manager that record Edit date,
Create
Date and Merge Date. Doesn't matter to me how it is stored at this point
however when I tried to call it up as just Month, Day, Year (with out the
timestamp) in php I got the "A non well formed numeric value encountered"
NOTICE.

You say I can convert a mysql timestamp value at will in the program (which
I think I am trying to do) and it is not working. Must I convert it with a
MYSQL function or a PHP function.

Any other ideas?

-----Original Message-----
From: Naintara [mailto:naintara@vismaya.info]
Sent: Saturday, September 22, 2007 12:49 PM
To: 'PHP-DB Mailing List'
Subject: RE: [PHP-DB] Notice: A non well formed numeric value encountered

That's a good question.

I'm really not sure about which way is better, but yes, you could use
UNIX_TIMESTAMP() to query a datetime value from a MySQL field, convert it
to the UNIX timestamp value within the query, and then retrieve it in your
record set.
UNIX_TIMESTAMP() [MySQL function]

Or you could use php to convert a datetime value to UNIX timestamp.
mktime() [php function]

You could store the timestamp value in the database itself, and convert at
will in the program.
So many choices... I really wouldn't know which to recommend, a lot depends
on usage. The datetime column takes more storage than an integer column,
but it's human-readable.

If you mean storing an timestamp integer value in a particular database
field, that should also be fine.

There are a whole lot of issues with datetime related functions, like DST
(daylight savings time) or timezones, if all that is critical, you may look
into it.
There is a TIMESTAMP field type in MySQL, the usage has changed in MySQL
4.1 and up.
This is useful for recording time/date of db updates.

For usual work, I find that a datetime data type column works for me.
Then, if I know what I will be using the datetime value for, I sometimes
format the date within the query itself using DATE_FORMAT() as I like to
get the results that way rather than change it, of course, if you may be
presenting the datetime value in different ways, or if you want the
flexibility, then use php.

I hope this helps somewhat.

-----Original Message-----
From: Stephen Sunderlin [mailto:stephen.sunderlin@verizon.net]
Sent: Saturday, September 22, 2007 9:24 PM
To: 'Naintara'; 'PHP-DB Mailing List'
Subject: RE: [PHP-DB] Notice: A non well formed numeric value encountered

Thank you for your response.

The notice is in the Subject Line of the email:
Notice: A non well formed numeric value encountered

So you are saying I have to convert the current yyyy-mm-dd:HH:MM:SS date
format, to UNIX timestamp value then call Date() to format the UNIX
timestamp as Month, Day, Year?

If so, is it recommended to do that at the database level or the program
level.

I guess it would make sense to convert all dates to UNIX timestamp for
database storage then convert at necessary.

Any insight would be helpful.

Thanks!

-----Original Message-----
From: Naintara [mailto:naintara@vismaya.info]
Sent: Saturday, September 22, 2007 11:13 AM
To: 'PHP-DB Mailing List'
Subject: RE: [PHP-DB] Notice: A non well formed numeric value encountered

I don't see the NOTICE message.
Perhaps a timezone notice?

Lookup the date() function in the php manual.
The time parameter should be a unix timestamp value, so $CTS should contain
an integer value.
You can also find ways to convert the time value you have to unix
timestamp, in the manual.

-----Original Message-----
From: Stephen Sunderlin [mailto:stephen.sunderlin@verizon.net]
Sent: Saturday, September 22, 2007 7:48 PM
To: 'PHP-DB Mailing List'
Subject: [PHP-DB] Notice: A non well formed numeric value encountered

I'm getting the above NOTICE with the following statement:
Echo date('d/m/y',$CTS);

Where $CTS = 2007-09-22 10:09:31

And 31/12/69 is being echoed.


PHP 5.2.1
MYSQL 5.0.37-community-nt via tcp/ip

Thanks in advance for any insight.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: Notice: A non well formed numeric value encountered

am 22.09.2007 20:23:00 von Naintara

Glad I could help.

The problem you faced earlier could happen if you tried to use the
timestamp column values directly in the php date() function. If you see the
database your timestamp columns would have values in the following format
for its timestamp columns:

'1970-01-01 00:00:01'

This isn't the same as the unix timestamp integer value.

-----Original Message-----
From: Stephen Sunderlin [mailto:stephen.sunderlin@verizon.net]
Sent: Saturday, September 22, 2007 11:27 PM
To: 'Naintara'
Cc: 'PHP-DB Mailing List'
Subject: RE: [PHP-DB] Notice: A non well formed numeric value encountered

Naintara,

That worked!

I must have made a syntax error.

Thank you!

-----Original Message-----
From: Naintara [mailto:naintara@vismaya.info]
Sent: Saturday, September 22, 2007 1:34 PM
To: 'Stephen Sunderlin'
Cc: 'PHP-DB Mailing List'
Subject: RE: [PHP-DB] Notice: A non well formed numeric value encountered

I think for now you can use the MySQL function DATE_FORMAT()
This would work well for your columns. Look it up in the MySQL reference,
it's very easy to use.

You'll have something like contact_created_date
If a contact was created today, it'll be something like
SELECT DATE_FORMAT(contact_created_date, '%M %d, %Y');

=>September 22, 2007

Where contact_created_date is your field.

-----Original Message-----
From: Stephen Sunderlin [mailto:stephen.sunderlin@verizon.net]
Sent: Saturday, September 22, 2007 10:38 PM
To: 'Naintara'; 'PHP-DB Mailing List'
Subject: RE: [PHP-DB] Notice: A non well formed numeric value encountered

I have 3 Timestamp fields in a contact manager that record Edit date,
Create
Date and Merge Date. Doesn't matter to me how it is stored at this point
however when I tried to call it up as just Month, Day, Year (with out the
timestamp) in php I got the "A non well formed numeric value encountered"
NOTICE.

You say I can convert a mysql timestamp value at will in the program (which
I think I am trying to do) and it is not working. Must I convert it with a
MYSQL function or a PHP function.

Any other ideas?

-----Original Message-----
From: Naintara [mailto:naintara@vismaya.info]
Sent: Saturday, September 22, 2007 12:49 PM
To: 'PHP-DB Mailing List'
Subject: RE: [PHP-DB] Notice: A non well formed numeric value encountered

That's a good question.

I'm really not sure about which way is better, but yes, you could use
UNIX_TIMESTAMP() to query a datetime value from a MySQL field, convert it
to the UNIX timestamp value within the query, and then retrieve it in your
record set.
UNIX_TIMESTAMP() [MySQL function]

Or you could use php to convert a datetime value to UNIX timestamp.
mktime() [php function]

You could store the timestamp value in the database itself, and convert at
will in the program.
So many choices... I really wouldn't know which to recommend, a lot depends
on usage. The datetime column takes more storage than an integer column,
but it's human-readable.

If you mean storing an timestamp integer value in a particular database
field, that should also be fine.

There are a whole lot of issues with datetime related functions, like DST
(daylight savings time) or timezones, if all that is critical, you may look
into it.
There is a TIMESTAMP field type in MySQL, the usage has changed in MySQL
4.1 and up.
This is useful for recording time/date of db updates.

For usual work, I find that a datetime data type column works for me.
Then, if I know what I will be using the datetime value for, I sometimes
format the date within the query itself using DATE_FORMAT() as I like to
get the results that way rather than change it, of course, if you may be
presenting the datetime value in different ways, or if you want the
flexibility, then use php.

I hope this helps somewhat.

-----Original Message-----
From: Stephen Sunderlin [mailto:stephen.sunderlin@verizon.net]
Sent: Saturday, September 22, 2007 9:24 PM
To: 'Naintara'; 'PHP-DB Mailing List'
Subject: RE: [PHP-DB] Notice: A non well formed numeric value encountered

Thank you for your response.

The notice is in the Subject Line of the email:
Notice: A non well formed numeric value encountered

So you are saying I have to convert the current yyyy-mm-dd:HH:MM:SS date
format, to UNIX timestamp value then call Date() to format the UNIX
timestamp as Month, Day, Year?

If so, is it recommended to do that at the database level or the program
level.

I guess it would make sense to convert all dates to UNIX timestamp for
database storage then convert at necessary.

Any insight would be helpful.

Thanks!

-----Original Message-----
From: Naintara [mailto:naintara@vismaya.info]
Sent: Saturday, September 22, 2007 11:13 AM
To: 'PHP-DB Mailing List'
Subject: RE: [PHP-DB] Notice: A non well formed numeric value encountered

I don't see the NOTICE message.
Perhaps a timezone notice?

Lookup the date() function in the php manual.
The time parameter should be a unix timestamp value, so $CTS should contain
an integer value.
You can also find ways to convert the time value you have to unix
timestamp, in the manual.

-----Original Message-----
From: Stephen Sunderlin [mailto:stephen.sunderlin@verizon.net]
Sent: Saturday, September 22, 2007 7:48 PM
To: 'PHP-DB Mailing List'
Subject: [PHP-DB] Notice: A non well formed numeric value encountered

I'm getting the above NOTICE with the following statement:
Echo date('d/m/y',$CTS);

Where $CTS = 2007-09-22 10:09:31

And 31/12/69 is being echoed.


PHP 5.2.1
MYSQL 5.0.37-community-nt via tcp/ip

Thanks in advance for any insight.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php