Well now i m retrieving results into an array
Then i m using sort($myarray)
but the problem is that it sorts in this way
(
e.g.
ABB
MBB
ZZZ
abc
def
ztt
)
i.e it sorts capital letters first n then it sorts the small letters
but i want the display to sort in ascending order whether
Ron,
Unless you have a good reason for doing it this way round, I suggest
you would be better
off using the database's own date function. Pretty much any db will have
TODAY() or DATE()
type functions. Advantages-
a) They will emit the data in the right format, in fact you can just
insert
Actually,
If you add the following line to my.cnf you'll get the same results,
permanently
[mysql]
default-character-set=utf8
[mysqld]
default-character-set=utf8
The last statement should be added AFTER all other configs... if not,
it will not work. In other works, add the line at the end o
Renich Bon Ciric wrote:
Firs of all, I wanna say I have spent a whole week looking for answers
elsewhere. The reason of this message is to look for a practical solution.
I just spent the last 2-3 days converting my entire database (and
website) from charset latin1 (ISO-8859-1) to utf8. Al
Yep, it does, in fact, if you enter the query to the mysql prompt, it
works fine.
Bastien Koert wrote:
can you cut'n'paste the query into the GUI tool for the db and test the
query there?
Bastien
From: Renich Bon Ciric <[EMAIL PROTECTED]>
To: php-db@lists.php.net,Bastien Koert <[EMAIL PR
can you cut'n'paste the query into the GUI tool for the db and test the
query there?
Bastien
From: Renich Bon Ciric <[EMAIL PROTECTED]>
To: php-db@lists.php.net,Bastien Koert <[EMAIL PROTECTED]>
CC: php-db@lists.php.net
Subject: Re: [PHP-DB] Possible MySQLi extension BUG!
Date: Fri, 09 Sep 20
1.- Yes, Everything is UTF-8 with utf8-general-ci as collation
2.- Yes, as I said before
3.- I need to ashure that the query gets there as it is...
Bastien Koert wrote:
Questions:
1. what is the current database collation and character set? check with
whatever GUI tool you use to admin the db
Questions:
1. what is the current database collation and character set? check with
whatever GUI tool you use to admin the db
2. Are they the same? ie UTF-8
3. the query of course would be correct since it hasn't touched mysql yet.
Its a straight representation from PHP.
Notes:
1. Spaces in
you gave yourself half of the answer:
date('Y-m-d H:i:s');
http://uk.php.net/manual/en/function.date.php
do you work on a pc?
there's also a *.chm to download, which I find very convenient:
http://uk.php.net/download-docs.php
or, a firefox search extension, somewhere, to add to that top right
sea
Ok,
Firs of all, I wanna say I have spent a whole week looking for answers
elsewhere. The reason of this message is to look for a practical solution.
My Systems:
Server:
Fedora Core 4 (up2dated)
PHP5.04 (cli)
MySQL 14.7 Distrib 4.1.12
using mysqli extension
Apache/2.0.54 (Fedora)
Workstation:
You need to use:
date('Y-m-d H:i:s');
It's in the comments at:
http://www.php.net/date
Jordan
On Sep 9, 2005, at 12:52 PM, Ron Piggott wrote:
Question:
I am trying to for the first time create a table with a column that is
defined as datetime
I wanted to populate that column with the dat
use timestamp column type and populate it by
$date = strtottime(date(r));
then when you want to display it
$date = date('r',$row['datefieldname']);
Bastien
From: "Ron Piggott" <[EMAIL PROTECTED]>
Reply-To: "Ron Piggott" <[EMAIL PROTECTED]>
To: "PHP DB"
Subject: [PHP-DB] DATE(r)
Date: Fri,
Question:
I am trying to for the first time create a table with a column that is
defined as datetime
I wanted to populate that column with the date(r) command.
date(r) on my web site gives this response:
Fri, 9 Sep 2005 13:32:19 -0400
How may I manipulate date(r) to give a format which is comp
13 matches
Mail list logo