Shopping Cart Rewrite
| From: | beno | Date: | Thu, 05 Dec 2002 14:56:53 +0000 |
| Subject: | Shopping Cart Rewrite | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-127150@lists.php.net to get a copy of this message | ||
Hi;
PHP isn't my strong language so I need your help. I'm writing a patch to a shopping cart called fishcart < http://fishcart.org > The following code works well in another page. I pass the variable $related to the page that I'm patching:
<?
$fcrp=new FC_SQL;
$fcrp->query("select relprod from cubaprodrel where relsku='$related' order by relseq");
$fcrp->next_record();
while( $fcrp->next_record() ){
$rsku=$fcrp->f('relprod');
$fcrpl->query("select * from cubaprodlang where prodlsku='$rsku' ".
"and prodlzid=$zid and prodlid=$lid");
$fcrpl->next_record();
$pname = strip_tags($fcrpl->f("prodname"));
$pheight = strip_tags($fcrpl->f("prodpich"));
$ppic = strip_tags($fcrpl->f("prodpic"));
$ptpic = strip_tags($fcrpl->f("prodtpic"));
?>
There is already an established connection to the d'base. The first line of code works fine. The query doesn't appear to choke. But the third line pointing to the next_record() chokes. Any suggestions, or isn't this enough to go on?
TIA,
beno