linking table

Language: PHP
Mac. I think our tables must be linked like this. 
 
(Course_student.cid)=(course.cid)
(Course_student.sno)=(student.sno)
This is how I did on my tables but the problem is that I can not view ';sno'; from the table ';student'; on the table(course_student). Where must I check the errors.

Language: PHP
WHERE course_student.cid = course.cid
AND course_student.sno = student.sno

Language: PHP
> WHERE course_student.cid = course.cid
> AND course_student.sno = student.sno
>

Language: PHP
function getStudCrs($regStud){
		conDB();
		$sql = "SELECT b.cname FROM course_student a, course b
				WHERE a.sno = $regStud AND a.cid = b.cid ORDER BY b.cname";
		$result = mysql_query($sql);
		while($selRows = mysql_fetch_array($result)){
		echo $selRows[';cname';] . "<br>";
		}
		mysql_close();
	}

Language: PHP
sql query to find a row {
I have the row
Using this info, create another sql query that targets another table- this query is run within the bracket of the first query, but has it owns brackets
get the info
 
} //close original bracket

Language: PHP
SELECT * FROM course_student WHERE cid = $courseid ORDER BY sno ASC
....
while($studentrow = mysql_fetch_array($studentresult, MYSQL_ASSOC))
	{
	          $sno = $studentrow[';sno';];
 
                           SELECT * FROM student WHERE sno = $sno
                           .....
                           from here you can get what ever info you want from a student table.
 
 
}

Language: PHP
//=========================
//INSERT DATA INTO DATABASE
//=========================
$sql = "INSERT INTO student(sname, init, fname, title, msname, dob, gen, lang, 
		idno, telh, telw, cel, fax, email, address) VALUES (';$surname';, ';$initials';, 
		';$ffname';, ';$title';, ';$psurname';, ';$dob';, ';$gender';, ';$loc';, ';$idno';, 
		';$htel';, ';$wtel';, ';$cpnumber';, ';$fax';, ';$email';, ';$postadd';)";
$result = mysql_query($sql) or die (mysql_error());
 
//=========================================
//GET AUTO INCREMENT FROM LAST INSERT TABLE
//=========================================
$student_id=mysql_insert_id();
 
$sql2	= "INSERT INTO course_student (sno, year) VALUES (';$student_id';, ';now()';";		
$result2 = mysql_query($sql2) or die (mysql_error());
 
if	(($result) && ($result2)) {
	echo "Registration successful.";
	}
	else {
	echo "There was a problem with the registration. Please try again";
	}
}