How can I write a sort to sort on 2 columns, one ascending, one
descending?
$get_list = "select * from access_tracking where user = '$user_id' order
by time,date_accessed desc"
But the ordering seems backwards sorted by date first, and then time.
TIA!!
Robert
--
PHP Database Mailing List (http
Robert,
You should be able to just do:
SELECT * FROM access_tracking WHERE user = '$user_id' ORDER BY time
DESC,date_accessed ASC;
Just experiment with the ORDER BY columns and the ASC and DESC orders to get
the results you're looking for.
Hope this helps,
Rich
> -Original Message-
> Fr
I asked this question several weeks ago; search for kc68 on this list
archives and you should find the more complete response. The coding with
my fields is:
?sort_field=cbc asc, net_receipts&sort_order=desc Play with the order and
asc and desc as another response suggested. What's confusing i
I've used mysql a little, but now I'm working with a MS SQL SERVER 2000
database. We have a proprietary application/hardware setup where
when a person enters the building, the time they enter the building
is automatically put into the database in a field called eventtime, and
their access card
SELECT count(id) FROM users WHERE DATEDIFF(eventtime,GETDATE(),d) == 1;
Or something along those lines, all the date functions are very well
documented in the "digital books" that come with Enterprise Manager.
Open up the reference, and search for datediff, and there should be a
link in there for
Craig Hoffman wrote:
Is it possible to write one INSERT statement to populate multiple tables?
__
Craig Hoffman - eClimb Media
v: (847) 644 - 8914
f: (847) 866 - 1946
e: [EMAIL PROTECTED]
w: www.eclimb.net
_
Nope. One record, one inse
Craig Hoffman wrote:
Here is the problem I am experiencing: I have a form that collects data
and I would like it to send it to three tables in a MySQL DB. One
table is called TRAININGLOG , other is called CORE and the third is
USERS. The USER table is the main table that contains the prima
Aj Seelund wrote:
ok, this might be difficult to explain, but this is what im trying to do...
i have a table in my db call db_blog. in it i have an auto_increment
column called entryNum. i use that strictly for order when i view the
blog. i also have a column called comNum. each row in the t
Hello all
Can someone tell me why PHP give all this erros, when it really opens
the file and displays all it's contents ?
Uploading files...
File Type: text/plain
UP: /tmp/teste.txt
UP2: teste.txtFile uploaded successfully
*Warning*: fopen(teste.txt): failed to open stream: Permission denied i
hi,
i've read the blob document in MySQL manual and i know it is similar to a
text field and can store large amount of binary data..however, in phpMyAdmin
2.5.4, i can't see the contents of my blob fields... how do you view it?
sorry for my ignorance..
hwee
- Original Message -
From:
$data = mysql_query("select from ");
while ($d = mysql_fetch_array($data)) {
echo $d['']."";
}
.. or something like that.
-Micah
On Tuesday 16 March 2004 05:16 pm, Ng Hwee Hwee wrote:
> hi,
>
> i've read the blob document in MySQL manual and i know it is similar to a
> text field an
On Mar 16, 2004, at 5:17 PM, [EMAIL PROTECTED] wrote:
From: Adam Williams <[EMAIL PROTECTED]>
Date: March 16, 2004 7:32:57 AM PST
To: [EMAIL PROTECTED]
Subject: mssql query
I've used mysql a little, but now I'm working with a MS SQL SERVER 2000
database. We have a proprietary application/hardware
Hi All,
Where do I get mssql.so to connect mssql with my PHP4.0.6 and PHP4.3.3
Regards,
Santos Kumar.M
13 matches
Mail list logo
