Print results from a left join

[phpretard]

I need to echo the "reward.id"

 

 

	

$sql = "select 
reward.id, reward.location, reward.industry, reward.title, reward.stamp, 
industry.id, industry.label, industry.location 
FROM reward 
LEFT JOIN industry ON industry.id = reward.industry
where (industry.label = '".$_GET['ind']."' and industry.location = '".$_GET['loc']."')";

$result = mysql_query($sql) or die(mysql_error());

while($info = mysql_fetch_assoc($result)){
             echo $info['HOW TO I PRINT reward.id'];
}free($result );

 

Any thoughts?

[ZacTopher]

give the reward.id a name in the query and reffer to this in the echo

[phpretard]

Well that solved it.  but i don't see a "solved" option  THANK YOU!

[ZacTopher]

You're welcome.

 

They're currently working on implementing the "solved" mod after the last forum upgrade

[phpretard]

If they need help there are some great forums out there