Selecting DISTINCT question ...

[iPixel]

Ive got this table .. it contains first name, last name, address1, address2, city, state, zip, email, phone etc....

 

I want to write a query that will select everything from that table, but only unique addresses... so

if address

 

12-85 Jewel Ave

Fresh Meadows NY 11365

 

exists twice... only return the first record.

 

im running this ...

 

$query = "SELECT DISTINCT address1 FROM imgcon WHERE denygift = 'NO' AND send_gift = 'PEN'";
$sql = mysql_query($query) or die(mysql_error());

while($result = mysql_fetch_assoc($sql))
{
	echo $result['fname'] . " " . $result['lname'] . " - ";
	echo $result['address1']; 
	?> <BR>x<BR> <?
}

 

but fname and lname are not pulled... how do i get that.

 

Thanks

~iPixel

[Barand]

To pull them you have to select them

 

try

SELECT fname, lname, address1 
FROM imgcon 
WHERE denygift = 'NO' AND send_gift = 'PEN'
GROUP BY  address1