[RESOLVED] mysql_fetch-ing - $row[' ']

[curb]

Based on table 1, I'm calling the teacher's id with $row['teacher_id'] which gives me the number ID. How can I get the teachers name and not the teacher_id based on the info provided from table 1?

Table 1
id | teacher_id
1 |2
2 |2
3 |1 (Ms. Parker)
4 |3 (Mrs. Story)

Table 2
id | teacher_name
1 |Ms. Parker
2 |Mr. Noggle
3 |Mrs. Story

[Kudose]

SELECT t2.teacher_name FROM Table2 AS t2, Table1 AS t1 WHERE t1.id=t2.id

[codered27]

make a left join of the tables

SELECT * from table1 TBL1 left join table2 TBL2 on TBL1.teacher_id=TBL2.id

then extract the names column of table2 from the result set

while($row = mysql_fetch_array($result))
{
print $row['teacher_name'];
}

[Kudose]

Is there a performance difference between our quires?

[curb]

I guess I spoke too soon. Table1 and table2 has a same field called "email" with different datas. The $row seems to override table2 field with table1.

How would I differentiate the two?

Example:

table1
email | [e-mail]

table2
email| [e-mail]

$teacher_id = $row['teacher_id'];
$teacher_name = $row['name'];
$email = $row['email'];
echo "id: $teacher_id <br>";
echo "name: $teacher_name";
echo "Class email: $email";
echo "Personal email: $email";
}

[bradgrafelman]

Kudose wrote:

Is there a performance difference between our quires?

Yours doesn't use the evil "SELECT *" ? :p

After fixing that, i would probably go with codered27's query. Why? Because he explicitly named the type of join to use along with the "ON ..." statement.

IIRC, MySQL's comma-separated-tables-are-left-joined behavior isn't standard.

[curb]

Got it working again. I used alias to separate the two fields. :p