[Resolved] [Resolved] mysql_fetch_array

jeffgman

What am I doing wrong with this code:

foreach($order_qty as $id_no => $val) {

$detailqry2 = "SELECT * FROM misc_order_detail, misc_order_items WHERE misc_order_detail.order_no = '".$order_no."' AND misc_order_items.id_no = '".$id_no."'";

$result2=mysql_query($detailqry2, $conn);

while ($row=mysql_fetch_array($result2, $conn)) {
	$description=$row["description"];
    $vpc=$row["vpc"];
    $min=$row["min"];
    $max=$row["max"];
    $order_qty2=$row["order_qty"];

$message .= '
<TR>
	<TD>".$description."</TD>
	<TD>".$vpc."</TD>
	<TD><center>".min."</center></TD>
	<TD><center>".$max."</center></TD>
	<TD><center>".$package_qty."</center></TD>
	<TD><center>".$order_qty2."</center></TD>
</TR>
';
}
}

The output just looks like this:

Description
VPC
Min
Max
Pkge Qty
Order

".$description."
".$vpc."
".min."
".$max."
".$package_qty."
".$order_qty2."

Thanks for the help.

devinemke

that's exactly what one would expect the output to look like when you encapsulate the entire string in single quotes.

i think you probably want this:

$message .= ' 
<TR> 
    <TD>' . $description . '</TD> 
    <TD>' . $vpc . '</TD> 
    <TD><center>' . $min . '</center></TD> 
    <TD><center>' . $max . '</center></TD> 
    <TD><center>' . $package_qty . '</center></TD> 
    <TD><center>' . $order_qty2 . '</center></TD>
</TR> 
';

jeffgman

Great, thanks for the help. Those darn quotes.