note 116298 rejected from function.mysql-fetch-array by tularis
| From: | tularis@php.net | Date: | Tue, 09 Dec 2014 13:07:48 +0000 |
| Subject: | note 116298 rejected from function.mysql-fetch-array by tularis | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-201100@lists.php.net to get a copy of this message | ||
Note Submitter: emerson dot basoalto at gmail dot com
----
Dear
I a have problem with this BD consult
$sql_productos = "SELECT p.quantity, pr.price, pl.name FROM co_cart_product as p,
co_product_lang as pl, co_product as pr where p.id_cart='$TBK_ORDEN_COMPRA' and
p.id_product=pl.id_product and p.id_product=pr.id_product and pl.id_lang=5 order by p.id_cart";
$result_pfinales = mysql_query($sql_productos, $conexion);
$z=0;
while($myrow_not = mysql_fetch_array($result_pfinales))
{
$z++;
echo "<table width='550px' align='center'> ";
echo "<th width='200px' align='left'>";
print utf8_encode($t_producto=$myrow_not[name]);
echo "</th>";
echo "<th width='73px' align='left'>";
print round($t_producto=$myrow_not[quantity]);
echo "</th>";
echo "<th width='85px' align='left'>";
print '$'; print' '; print
number_format($t_producto=$myrow_not[price],0,',','.');
echo "</th>";
echo "</th>";
echo "<th width='385px' align='left'>";
print '$'; print' '; print
round(($t_producto=$myrow_not[price])*$t_producto=$myrow_not[quantity]);
echo "</th>";
echo "</table>";
This code do not print the info of the BD, i need help please
Thanks.