Henter forkert i database ?
Hvad er der forkert ? nedenstående kode laver outputtet:7042 010; 1; 20.000; Stk.; 29.00; .. osv
men der hvor der står 1 skal der stå en produktnavn ??
Her kommer koden --»
$item_res = db_query("select item.*,iteminfo.* from item, iteminfo where iteminfo.langID='$nlangID' and item.ID=iteminfo.itemID") or db_die();
$cur_res = db_query("select keysign from currency where ID='$ncurID'") or db_die();
$cur_row = db_fetch_row($cur_res);
$comment = "## number; name; quantity; packinfo.name; price [ $cur_row[0] ]; sizes; stock; expiration; itemgrID; orderby; visible; thumbnail; detail; keywords; longdescr\n";
$fw = fwrite($fp,$comment);
while ($item_row = db_fetch_row($item_res)) {
$pack_res = db_query("select name from packinfo where packID='$item_row[10]' and langID='$nlangID'") or db_die();
$pack_row = db_fetch_row($pack_res);
$price_res = db_query("select price.value,currency.keysign from price,currency where price.itemID='$item_row[0]' and currency.ID='$ncurID' and price.curID=currency.ID") or db_die();
$price_row = db_fetch_row($price_res);
$sizeinfo_res = db_query("select size.ID, sizeinfo.value from size,sizeinfo where size.itemID='$item_row[0]' and sizeinfo.langID='$nlangID' and size.ID=sizeinfo.sizeID") or db_die();
$sizesstring ="";
while ($sizeinfo_row = db_fetch_row($sizeinfo_res)) {
$sizesstring = $sizeinfo_row[1].",".$sizesring;
}
$size_res = db_query("select stock,expiration from size where itemID='$item_row[0]'") or db_die();
$size_row = db_fetch_row($size_res);
$export_array = array ($item_row[1], $item_row[14], $item_row[6], $pack_row[0], $price_row[0], $sizesstring, $size_row[0], $size_row[1], $item_row[2], $item_row[8], $item_row[9], $item_row[4], $item_row[5], $item_row[3], $item_row[16]);
$export_string = implode("; ", $export_array);
$export_string = $export_string;
$fw = fwrite($fp,$export_string);
echo "<li>$item_row[14] ($item_row[1]; $price_row[0] $price_row[1])\n";
«-- kode slut
Databasen med produktnavnet ser sådan du:
CREATE TABLE iteminfo (
ID int(8) unsigned NOT NULL auto_increment,
itemID int(8) unsigned NOT NULL default '1',
langID int(8) unsigned NOT NULL default '1',
name varchar(30) NOT NULL default '',
keywords varchar(50) default NULL,
longdescr text,
div0 tinyint(1) default NULL,
PRIMARY KEY (ID),
KEY ID (ID)
) TYPE=MyISAM;
--- ??
