Quick PHP Question

GreyWing · 30-10-2008, 04:15:40 AM

Does anyone know what I can add to get the results to sort by the order_id field, and is descending order?

any help appreciated, cheers GW

$SQL = "SELECT * FROM jos_vm_order_user_info";
$result = mysql_query($SQL);

while ($db_field = mysql_fetch_assoc($result)) {
print $db_field['order_id'] . " ";
print $db_field['title'] . " ";
print $db_field['first_name'] . " ";
print $db_field['last_name'] . " ";
print $db_field['address_1'] . " ";
print $db_field['address_2'] . " ";
print $db_field['city'] . " ";
print $db_field['zip'] . " ";

}

mysql_close($db_handle);

}
else {
print "Database NOT Found ";
mysql_close($db_handle);
}

?>

woopwoop · 30-10-2008, 04:35:35 AM

$SQL = "SELECT * FROM jos_vm_order_user_info order by order_id DESC";

I think if you replace your $SQL line with the line above it'll do what you want.
(btw/ change DESC to ASC for ascending)

GreyWing · 30-10-2008, 10:53:26 AM

Cheers mate I'll give it a try,

Thanks
GW

GreyWing · 30-10-2008, 02:58:57 PM

Cheers mae it worked 100%, saed me some time there, owe you one.

Thanks
GW

woopwoop · 30-10-2008, 03:09:53 PM

No probs GW you made me feel like an expert for today!
(usually I'm the person asking php questions on google groups)

30-10-2008, 04:15:40 AM	#1 (permalink)
GreyWing Join Date: Aug 2006 Location: Barnsley Posts: 3,176 No Classified Ratings Domain Trader Rating: (100% / 18)	Quick PHP Question Does anyone know what I can add to get the results to sort by the order_id field, and is descending order? any help appreciated, cheers GW $SQL = "SELECT * FROM jos_vm_order_user_info"; $result = mysql_query($SQL); while ($db_field = mysql_fetch_assoc($result)) { print $db_field['order_id'] . "<BR>"; print $db_field['title'] . "<BR>"; print $db_field['first_name'] . " "; print $db_field['last_name'] . "<BR>"; print $db_field['address_1'] . "<BR>"; print $db_field['address_2'] . "<BR>"; print $db_field['city'] . "<BR>"; print $db_field['zip'] . "<BR> <BR> <BR>"; } mysql_close($db_handle); } else { print "Database NOT Found "; mysql_close($db_handle); } ?> __________________ Make cash from your website, any website, any sector... That.co.uk Find out more

30-10-2008, 04:35:35 AM	#2 (permalink)
woopwoop Join Date: Jan 2007 Posts: 1,586 No Classified Ratings Domain Trader Rating: (100% / 20)	$SQL = "SELECT * FROM jos_vm_order_user_info order by order_id DESC"; I think if you replace your $SQL line with the line above it'll do what you want. (btw/ change DESC to ASC for ascending) __________________ Connect with me @ TW:LI:FB \| MyWeb \| D/L domains4sale \| Morecambe London Student Forums Student Books UK promotions agencies

30-10-2008, 10:53:26 AM	#3 (permalink)
GreyWing Join Date: Aug 2006 Location: Barnsley Posts: 3,176 No Classified Ratings Domain Trader Rating: (100% / 18)	Cheers mate I'll give it a try, Thanks GW __________________ Make cash from your website, any website, any sector... That.co.uk Find out more

30-10-2008, 02:58:57 PM	#4 (permalink)
GreyWing Join Date: Aug 2006 Location: Barnsley Posts: 3,176 No Classified Ratings Domain Trader Rating: (100% / 18)	Cheers mae it worked 100%, saed me some time there, owe you one. Thanks GW __________________ Make cash from your website, any website, any sector... That.co.uk Find out more

30-10-2008, 03:09:53 PM	#5 (permalink)
woopwoop Join Date: Jan 2007 Posts: 1,586 No Classified Ratings Domain Trader Rating: (100% / 20)	No probs GW you made me feel like an expert for today! (usually I'm the person asking php questions on google groups) __________________ Connect with me @ TW:LI:FB \| MyWeb \| D/L domains4sale \| Morecambe London Student Forums Student Books UK promotions agencies

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Domain Name Community	Replies	Last Post
quick question please....??	Paulo1Chop	General Board	10	10-10-2007 04:31:38 PM
quick question on bad faith	Mendis	Domain Name Disputes	4	22-03-2006 09:59:30 PM