Have 2 tables - one for new titles and the other for authors.
I want to tag the "new titles" table with the "author" value if the author's name appears in list of new titles.
As you can see from my code, I don't have a clue what is wrong but its a type of query that I will be using a lot.
Suggestions where to start?
<?
$sql="SELECT author FROM author_list ";
$rs = mysql_query($sql);
While($row = mysql_fetch_array($rs)){
$id= ['author'];
$result = mysql_query("SELECT author, title from author_list, title_list WHERE title like '.$id.' ");
?>