forked from science-ation/science-ation
1dad6505eb
- Prevent the user from setting zero, or more than one, primary contact. - Add a primary column to the contacts table, so they can see the automatic set/unset operations on the primary contact.
12 lines
291 B
PHP
12 lines
291 B
PHP
<?
|
|
function db_update_81_post()
|
|
{
|
|
$q = mysql_query("SELECT DISTINCT award_sponsors_id FROM award_contacts");
|
|
while($i = mysql_fetch_object($q)) {
|
|
$asid = $i->award_sponsors_id;
|
|
mysql_query("UPDATE award_contacts SET `primary`='yes' WHERE award_sponsors_id='$asid' LIMIT 1");
|
|
}
|
|
}
|
|
?>
|
|
|