i need a program to download all news from each page from link
lynx -source [login to view URL]
no duplicates.
it will write to this table. it will compare link for duplicates
news_date is the date of the story
newskey is AA the symbol i wll need to pass the symbol as a variable
mysql> desc news;
+--------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+----------------+
| id | bigint(20) | NO | PRI | NULL | auto_increment |
| title | varchar(255) | NO | | | |
| link | varchar(255) | NO | | | |
| news_date | datetime | NO | | | |
| news_summary | text | NO | | | |
| newskey | varchar(255) | NO | | | |
+--------------+--------------+------+-----+---------+----------------+
6 rows in set (0.00 sec)
mysql>