woopwoop

I have a table where there are a bunch of fields. I'm trying to extract information for rows with a unique 'code' where subject='subject'. I also need the 'title' field entry from that row.

Here's my query:

$query="select distinct(code), title from tablename where subject='$subject' order by code asc";


Is this correct or can it cause problems that of the 2 variables I'm pulling, I'm specifying 1 as disctinct?

__________________
Connect with me @ TW:LI:FB | MyWeb | D/L domains4sale | Morecambe London Student Forums Student Books UK promotions agencies

Skinner

theoretically if you ask the puritans your not supposed to pull more than one column when specifying distinct. As your using orderby the distinct you may wanna alias it and set distinct code as distcode then order by distcode, otherwise some SQLs will order by all the code not just the distinct ones. (there maybe 1000 code lines but only 15 distinct ones).

I personally think if it works then its ll good

__________________
Browse:

accelerator

For php questions I recommend:

PHP Freaks Forums - Index

Rgds

__________________
LowPrices.co.uk | My Twitter | KeyphraseDomains.co.uk | Mens Shirts | Hotels in Bath | Money Off Code