SQL Syntax error

[[email protected]]

 

I am getting a Sql Syntax error, whats wrong?? I am trying to insert unique emails from submit email table to unique table.

 

<?php
require('includes/connection.php');
$result = mysql_query("SELECT DISTINCT email_address FROM submit_emails")or die(mysql_error());
if(!empty($result))
{
while($row = mysql_fetch_array($result))
  {
  $e = $row['email_address'];
  $query = mysql_query("INSERT INTO unique (email) VALUES ('$e')")or die(mysql_error());
  }
 }
?>

 

 

[Alex]

unique is a mysql reserved word. It's suggested that you don't use mysql reserved words for things like columns, tables and such, but if you must use back ticks (`):

 

$query = mysql_query("INSERT INTO `unique` (email) VALUES ('$e')")or die(mysql_error());

[[email protected]]

 

@Alex : What is the Sql script to delete duplicate rows in table* ??