Variable Problem

[adamboalt]

I am retrieving the info ok from the db. Zip comes out fine but I can not write the emailreport????

$result5 = mysql_query("SELECT zip FROM cart WHERE session = '$cart_id' AND (reshs = 'y' OR reshb = 'y')",$db);

while ($resemail = mysql_fetch_array($result5)) {

if ($resemail["reshs"] == 'y' && $resemail["reshb"] == 'n') { $emailreport = "Seller Report"; }
if ($resemail["reshs"] == 'n' && $resemail["reshb"] == 'y') { $emailreport = "Buyer Report"; }
if ($resemail["reshs"] == 'y' && $resemail["reshb"] == 'y') { $emailreport = "Seller Report, Buyer Report"; }

$AdminMessage2 .= "<b>".$resemail[zip]." (".$emailreport.")</b><br>";

}

Thanks,
Adam

[steadyguy]

Looks like you're only fetching 'zip', not 'reshs' or 'reshb' ... so when you test for them, they're never true. Try changing the query to ...

"select zip, reshs, reshb from cart where session = '$cart_id' and (reshs = 'y' OR reshb = 'y')"

Hope that helps.