update question

[newtothis]

Can someone help me write this? Only one record can be Y while all the rest have to be N. All records have to be updated.

           ************

if id = sel_record then showcase = Y

And if does not equal sel_record then showcase = N

$sql = "UPDATE propertydata SET showcase = 'Y' WHERE id = '$sel_record'";

           ************

[Anon]

Maybe:

$sql = "UPDATE propertydata SET showcase = 'Y' WHERE id = '$sel_record'";
mysql_query($sql);
$sql = "UPDATE propertydata SET showcase = 'N' WHERE id != '$sel_record'";
mysql_query($sql);

Diego

[newtothis]

Perfect! Thanks.