RE: [PHP] Ordering a query

2001-09-08 Thread Matthew Loff
You could insert a ternary operation... ($order?$order:defaultfield) Is the same as: if($order) echo $order; else echo defaultfield; ... $result = mysql_query(SELECT articles.title,vote.votes,vote.total,articles.date,staff.firstname,artic les.content,articles.id FROM

Re: [PHP] ordering a query

2001-09-07 Thread George Pitcher
It is simply ordering them as type data rather than as type integer. Change your data type in the db. George, a newbie - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 07, 2001 9:16 AM Subject: [PHP] ordering a query Me again :) I have a query

Re: [PHP] ordering a query

2001-09-07 Thread Tom Carter
Pitcher [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, September 07, 2001 9:00 AM Subject: Re: [PHP] ordering a query It is simply ordering them as type data rather than as type integer. Change your data type in the db. George, a newbie - Original Message