question about join query

[sherri guthrie]

i'm trying to compile data from 2 different tables for a report. this code:

$result4 = mysql_query("select reportequipment.id, equipment.name,reportequipment.qty from reportequipment LEFT JOIN equipment
ON reportequipment.id = equipment.id where webid='$myid'")or die(mysql_error());


$i = 0;
while ( $row = mysql_fetch_array($result4) )
$i++;


returns the row reportequipment.id, but equipment.name is blank.

my results are:

id# name qty
1 (blank) 3

i need :

id# name qty
1 vest 3


thanks for taking the time to assist.