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 st

Re: [PHP] ordering a query

2001-09-07 Thread Tom Carter
uot;George 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

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 qu