Удалени дубликатов если нет понятия о дубле??

include ("db.inc");

function delete_id ($subject,$m_id)
{
global $db,$dname;
$db->sql_query("DELETE FROM ".$dname."_board000 where (m_id!='$m_id' && subject='$subject')");
}

function select_id ($subject)
{
global $db,$dname;
$result = $db->sql_query("SELECT * from ".$dname."_board000 where (subject='$subject')");
$m_id = -1;
if ($db->sql_numrows($result)>1)
{
$row_cat = $db->sql_fetchrow($result)) - на это ругает
$m_id = intval ($row_cat['m_id']);
}
return $m_id;
}

function delete_dubl ()
{
global $db,$dname;
$result = $db->sql_query("SELECT * from ".$dname."_board000");

while ($row_cat = $db->sql_fetchrow($result))
{
$subject = $row_cat['subject'];
$m_id = select_id ($subject)
if ($m_id != -1) delete_id ($subject,$m_id);
}
}

<?

$dname = "web";
$dbhost = "localhost";
$dbuname = "web";
$dbpass = "web";
$dbtype = "MySQL";

include ("db.inc");

function delete_id ($subject,$m_id)
{
global $db,$dname;
$db->sql_query("DELETE FROM ".$dname."_board000 where (m_id!='$m_id' && subject='$subject')");
}

function select_id ($subject)
{
global $db,$dname;
$result = $db->sql_query("SELECT * from ".$dname."_board000 where (subject='$subject')");
$m_id = -1;
if ($db->sql_numrows($result)>1)
{
$row_cat = $db->sql_fetchrow($result);
$m_id = intval ($row_cat['m_id']);
}
return $m_id;
}

function delete_dubl ()
{
global $db,$dname;
$result = $db->sql_query("SELECT * from ".$dname."_board000");

while ($row_cat = $db->sql_fetchrow($result))
{
$subject = $row_cat['subject'];
$m_id = select_id ($subject);
if ($m_id != -1) delete_id ($subject,$m_id);
}
}

?>

<?

$dbname = "web";
$dbhost = "localhost";
$dbuname = "web";
$dbpass = "web";

$base_connect = mysql_connect($dbhost, $dbuname, $dbpass)
or die('Невозможно подключиться.');

@mysql_select_db($dbname, $base_connect)
or die('Невозможно подключиться к базе.');

$query = "select * from board000";

$results = mysql_query ($query, $base_connect)
or die('Невозможно выполнить запрос.');

while ( $result = mysql_fetch_assoc ( $results )) {

$query = "delete from board000 where subject='" . $result['subject'] . "'";

@mysql_query($query, $base_connect)
or die('Невозможно выполнить запрос.');

}

mysql_close($base_connect);

?>

KosoyRoman:

<?

$dbname = "web";
$dbhost = "localhost";
$dbuname = "web";
$dbpass = "web";

$base_connect = mysql_connect($dbhost, $dbuname, $dbpass)
or die('Невозможно подключиться.');

@mysql_select_db($dbname, $base_connect)
or die('Невозможно подключиться к базе.');

$query = "select * from board000";

$results = mysql_query ($query, $base_connect)
or die('Невозможно выполнить запрос.');

while ( $result = mysql_fetch_assoc ( $results )) {

$query = "delete from board000 where subject='" . $result['subject'] . "' and id<>" . $result['id'];

@mysql_query($query, $base_connect)
or die('Невозможно выполнить запрос.');

}

mysql_close($base_connect);

?>

solnikolay:
Эээххххх :)

@mysql_query($query, $base_connect)
or die('Невозможно выполнить запрос.');

}

solnikolay:
Да. 10 зайцев.