![Picture of Marcos Yoshida Picture of Marcos Yoshida](/graphics/unknown.gif)
Marcos Yoshida - 2012-06-04 22:04:02
I'm trying to generate a list with many barcodes using MySql. The data is change but the barcode image repeats, why? Is there an work arround solution?
Follow the script:
$sql=mysql_query("SELECT Tab_Stock_Mov.PartNumber, SerialNumber, NF_inv, BinLocation
FROM Tab_Stock_Mov LEFT JOIN Tab_CadPro ON Tab_Stock_Mov.PartNumber = Tab_CadPro.PartNumber WHERE Tab_Stock_Mov.NF_Inv = '$inv'" ) or die(mysql_error());
echo "<table border=1 width=50% cellspacing=7 style='position:absolute; left: 0px; top: 0px'>";
while($result_sql_cat = mysql_fetch_object($sql)){
$sn=$result_sql_cat->SerialNumber;
$pn=$result_sql_cat->PartNumber;
$barnumber=$pn;
$bcode=$bar->genBarCode($barnumber,"jpg","bcimage");
echo "<TR HEIGHT=1><TD WIDTH=20%><FONT FACE='Ariel' SIZE=3> PN: $barnumber </FONT></TD>";
echo "<TD WIDTH=20% ALIGN=CENTER VALIGN=BOTTOM><img src='bcimage.jpg'>";
echo "</TD></TR>";
$barnumber=$sn;
$bcode=$bar->genBarCode($barnumber,"jpg","bcimage2");
echo "<TR><TD WIDTH=20%><FONT FACE='Ariel' SIZE=3> SN: $barnumber </FONT></TD>";
echo "<TD WIDTH=20% ALIGN=CENTER VALIGN=BOTTOM><img src='bcimage2.jpg'>";
echo "</TD></TR>";
$bar->error(true);
}
echo "</table>";
Thanks