Slette gamle referencer fra databasen

Hej Starfish

Her er en løsning i PHP:

$sql=\"select * from user_kommune\";
$result=mysql_query($sql);
while ($row=mysql_fetch_array($result))
{
  $sql=\"select * from users where username=\'$row[username]\'\";
  $result=mysql_query($sql);
  if (mysql_num_rows($result)==0)
  {
    $sql=\"delete from user_kommune where username=\'$row[username]\'\";
    mysql_query($sql);
  }
}


Hilsen

Mads