I wrote the following script to join the subject and title tables. Just want to know if this the correct method to use. Also how would I display a field from two different tables who have the same name. (eg : Sub_id). I used the indexed method for the one field in this program. Would this be the only way to display the value. I tried echo $row[subject.sub_id]; but this did not seem to work.
$title = "Table Records";
//link to mysql
$link_id = mysql_connect('localhost', 'root', '';
echo "Connected to the MySQL server successfully <br>";
die ("Connection to the MySQL server was unsuccessful"