order by
Posted: Fri Jul 11, 2008 5:22 pm
Hey all, see if you can figure this one out..
I'm trying to display all customer payments from oldest to newest, and its doing that, but its breaking it up by customer!
Example:
1-1-08 customer a
2-2-08 customer a
3-3-08 customer a
1-2-08 customer b
2-3-08 customer b
3-4-08 customer b
Any help making it look like so:
1-1-08 customer a
1-2-08 customer b
2-2-08 customer a
2-3-08 customer b
3-3-08 customer a
3-4-08 customer b
Please?
Nubsauce
Code: Select all
$links33 = @mysql_query("SELECT * FROM ".$mysql_pretext."_customer_payments WHERE customer_id = '$customerid' ORDER BY date ASC");Example:
1-1-08 customer a
2-2-08 customer a
3-3-08 customer a
1-2-08 customer b
2-3-08 customer b
3-4-08 customer b
Any help making it look like so:
1-1-08 customer a
1-2-08 customer b
2-2-08 customer a
2-3-08 customer b
3-3-08 customer a
3-4-08 customer b
Please?
Nubsauce