MySQL Forums
Forum List  »  Knowledge Base

question about join query
Posted by: sherri guthrie
Date: October 19, 2009 07:11AM

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

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

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

returns the row, but 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.

Options: ReplyQuote

Written By
question about join query
October 19, 2009 07:11AM
October 19, 2009 03:33PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.