newb: table merge issues

[doofy]

Hi there,

 

I'm new to this (2 days into it) but I've managed to rummage together 2 tables, and PHP to input into the database. My issue now is that I want to merge one of the two tables into the other. I've managed to do this, but for some reason I'm getting duplicate entries from the 2nd table.

 

Code:

//mysql connection

 

$query = "SELECT ArticleDescription, URL FROM top_web_articles"or die ("query is messed up");

 

$result = mysql_query($query);

while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {

 

mysql_query("INSERT INTO web_articles (ArticleDescription, URL) SELECT ArticleDescription, URL FROM top_web_articles") or die ("Failed merge!");

}

echo ("Successful merge!");

?>

 

Does anyone have any suggestions as to where I went wrong?

 

Thanks in advance,

Doofy.

[doofy]

I removed the broken while loop, and added SELECT UNIQUE. Problem solved, please close.

 

Cheers,

Doofy