Guest Posted April 18, 2005 Share Posted April 18, 2005 (edited) Hey, Even though i first wrote this addon nearly 2 years ago I have been taken aback by the amount of interest I still get so due to the amount of mail I'm now receiving I've decided to setup a topic to help out users of the addon and discuss new ideas. This co-insides with the release of version 2 of the addon which is a substantial rewrite. If your having any problems with the addon or have any ideas for new features or improvements, please drop a message here and I will help out as much as possible Slante! Kenny Boyd Edited April 26, 2005 by hpdl Quote Link to comment Share on other sites More sharing options...
Guest Posted April 26, 2005 Share Posted April 26, 2005 (edited) Just a note to say Version 2 of the addon is now available from the contributions area at: OSC XML Feed - Version 2 Version 2 is a complete rewrite of the OSC XML Feed addon offering two new versions: v2.00A - ALL PRODUCTS FEED v2.00B - CATEGORY BASED FEED Both versions contain many new configurable features and come with an easy to use On/Off system to configure your feed output. More data is now available by default and includes support for user definable tag names, taxes, special prices and more. Users of previous 1.x versions are advised to try out this new version. A full HTML manual is included offering installation, extensive configuration and advanced editing help. Big thanks goes to Eyal Shoabi from url removed for the feature suggestions and extensive beta testing . Edited August 1, 2005 by Mibble Quote Link to comment Share on other sites More sharing options...
ieuflr2000 Posted April 27, 2005 Share Posted April 27, 2005 Hello theinternetfoundry, I test your OSC XML FEED - Version 2.0A & 2.0B. I cannot read with "RssReader" or of another reader. I made the turn and I do not understand? Thank you for your answer. Philippe :thumbsup: ---------- Bonjour theinternetfoundry, Je test votre OSC XML FEED - Version 2.0A & 2.0B. Je ne peux pas lire avec ? RssReader ? ou d?autre lecteur. J?ai fait le tour et je ne comprends pas ? Merci de votre r?ponse. Philippe :thumbsup: Quote IEUFLR2000 Link to comment Share on other sites More sharing options...
wnelson0 Posted May 3, 2005 Share Posted May 3, 2005 (edited) Just a note to say Version 2 of the addon is now available from the contributions area at: OSC XML Feed - Version 2 Version 2 is a complete rewrite of the OSC XML Feed addon offering two new versions: v2.00A - ALL PRODUCTS FEED v2.00B - CATEGORY BASED FEED Both versions contain many new configurable features and come with an easy to use On/Off system to configure your feed output. More data is now available by default and includes support for user definable tag names, taxes, special prices and more. Users of previous 1.x versions are advised to try out this new version. A full HTML manual is included offering installation, extensive configuration and advanced editing help. Big thanks goes to Eyal Shoabi from url removed for the feature suggestions and extensive beta testing . <{POST_SNAPBACK}> Are we supposed to edit the database information at the bottom of php file as in dbserver , username, and so on. If I read the instructions right it says to edit theses items but the php file says not to edit them? Also how do we know when it is working? Any information will be greatly appreciated. Thanks in advance Wayne Edited August 1, 2005 by Mibble Quote Link to comment Share on other sites More sharing options...
Guest Posted May 8, 2005 Share Posted May 8, 2005 Hello theinternetfoundry, I test your OSC XML FEED - Version 2.0A & 2.0B. I cannot read with "RssReader" or of another reader. I made the turn and I do not understand? Thank you for your answer. Philippe :thumbsup: ---------- Bonjour theinternetfoundry, Je test votre OSC XML FEED - Version 2.0A & 2.0B. Je ne peux pas lire avec ? RssReader ? ou d?autre lecteur. J?ai fait le tour et je ne comprends pas ? Merci de votre r?ponse. Philippe :thumbsup: <{POST_SNAPBACK}> Bonjour Philippe , This is a basic XML feed and not a RSS feed. You would use this addon to provide a basic xml output that other applications or websites can pick up from your site. If you search the contributions area for "RSS" then you will find a couple of addons that provide a full RSS feed. Merci, Kenny Quote Link to comment Share on other sites More sharing options...
Guest Posted May 8, 2005 Share Posted May 8, 2005 (edited) Just a note to say Version 2 of the addon is now available from the contributions area at: OSC XML Feed - Version 2 Version 2 is a complete rewrite of the OSC XML Feed addon offering two new versions: v2.00A - ALL PRODUCTS FEED v2.00B - CATEGORY BASED FEED Both versions contain many new configurable features and come with an easy to use On/Off system to configure your feed output. More data is now available by default and includes support for user definable tag names, taxes, special prices and more. Users of previous 1.x versions are advised to try out this new version. A full HTML manual is included offering installation, extensive configuration and advanced editing help. Big thanks goes to Eyal Shoabi from url removed for the feature suggestions and extensive beta testing . <{POST_SNAPBACK}> Are we supposed to edit the database information at the bottom of php file as in dbserver , username, and so on. If I read the instructions right it says to edit theses items but the php file says not to edit them? Also how do we know when it is working? Any information will be greatly appreciated. Thanks in advance Wayne <{POST_SNAPBACK}> Hi Wayne, Yes you edit the settings only in the top of XML.PHP or XML2.PHP. You would only edit the bottom areas of these files if you were adding your own extra tags which is advanced. If you just want to run the addon out of the box configur the settings at the top of the file only. To test the feed is working you need Internet Explorer 5 or Internet Explorer 6 as your browser and point it to the xml.php or xml2.php file on your server e.g: http://www.yoursite.com/catloag/xml.php Thanks - HTH, Kenny Edited August 1, 2005 by Mibble Quote Link to comment Share on other sites More sharing options...
ieuflr2000 Posted May 9, 2005 Share Posted May 9, 2005 Bonjour Kenny, Merci de ta r?ponse j?ai bien compris entre temps j?ai fait une recherche est maintenant cette contrib est parfaite. Merci Philippe France :thumbsup: --------- Hello Kenny, Thank you for your answer I understood well meanwhile I made a research this contrib is now is completed. Thank you Philippe France :thumbsup: Bonjour Philippe , This is a basic XML feed and not a RSS feed. You would use this addon to provide a basic xml output that other applications or websites can pick up from your site. If you search the contributions area for "RSS" then you will find a couple of addons that provide a full RSS feed. Merci, Kenny <{POST_SNAPBACK}> Quote IEUFLR2000 Link to comment Share on other sites More sharing options...
ieuflr2000 Posted May 15, 2005 Share Posted May 15, 2005 Bonjour Kenny, Je voudrais savoir SVP si sur cette ligne il y a besoin d?un code ISO ou pas ? echo '<?xml version="1.0" ?>'; Philippe ------------------------ Hello Kenny, I would like to know PLEASE if on this line he needs a code ISO or not there? echo '<?xml version="1.0" ?>'; Philippe :thumbsup: Quote IEUFLR2000 Link to comment Share on other sites More sharing options...
Guest Posted May 19, 2005 Share Posted May 19, 2005 Bonjour Kenny, Je voudrais savoir SVP si sur cette ligne il y a besoin d?un code ISO ou pas ? echo '<?xml version="1.0" ?>'; Philippe ------------------------ Hello Kenny, I would like to know PLEASE if on this line he needs a code ISO or not there? echo '<?xml version="1.0" ?>'; Philippe :thumbsup: <{POST_SNAPBACK}> Phillipe, yes you can add the ISO code to this line e.g: echo '<?xml version="1.0" encoding="ISO-8859-1"?>'; merci, Kenny Quote Link to comment Share on other sites More sharing options...
easyjava Posted May 21, 2005 Share Posted May 21, 2005 Tout d'abord merci pour cette contribution. Mais j'ai une erreur sur mon fichier xml : La page XML ne peut pas ?tre affich?e Impossible d'afficher l'entr?e XML en utilisant la feuille de style XSL. Corrigez l'erreur, puis cliquez sur le bouton Actualiser ou r?essayez ult?rieurement. -------------------------------------------------------------------------------- Un caract?re incorrect a ?t? trouv? dans un contenu de texte. Erreur de traitement de la ressource http://www.dupertuis.com... NAME><PRICE>45.00</PRICE><MANUFACTURER>Stanton</MANUFACTURER><MODEL>Dj pro 50</MODEL>... Si j'ai bien compris cela vient du fait que j'ai des caract?res sp?ciaux dans mes bdd. Mais comment dois-je faire pour r?gler ce probl?me ? Merci d'avance Quote Link to comment Share on other sites More sharing options...
ieuflr2000 Posted May 21, 2005 Share Posted May 21, 2005 Hello Kenny, Thank you for your answer and very good contribution. It is Ok now Thank you Philippe France :thumbsup: ---------------------- Bonjour Kenny, Merci pour ta r?ponse et tr?s bonne contribution. C?est ok maintenant Merci Philippe France :thumbsup: Phillipe, yes you can add the ISO code to this line e.g: echo '<?xml version="1.0" encoding="ISO-8859-1"?>'; merci, Kenny <{POST_SNAPBACK}> Quote IEUFLR2000 Link to comment Share on other sites More sharing options...
easyjava Posted May 22, 2005 Share Posted May 22, 2005 meme en ajoutant le code iso, il affiche deja bcp plus d items mais il me met quand meme : La page XML ne peut pas ?tre affich?e Impossible d'afficher l'entr?e XML en utilisant la feuille de style XSL. Corrigez l'erreur, puis cliquez sur le bouton Actualiser ou r?essayez ult?rieurement. -------------------------------------------------------------------------------- Nom commenc? avec un caract?re non valide. Erreur de traitement de la ressource http://www.dupertuis.com/catalog/xml. Lign... <PRICE>130.45</PRICE><MANUFACTURER>Velleman</MANUFACTURER><MODEL>vm101</MODEL><URL>... Quote Link to comment Share on other sites More sharing options...
ieuflr2000 Posted May 22, 2005 Share Posted May 22, 2005 Bonjour, Je viens de faire un test de tapage et elle fonctionne bien http://www.dupertuis.com/catalog/xml.php Ph :thumbsup: meme en ajoutant le code iso, il affiche deja bcp plus d items mais il me met quand meme : La page XML ne peut pas ?tre affich?e Impossible d'afficher l'entr?e XML en utilisant la feuille de style XSL. Corrigez l'erreur, puis cliquez sur le bouton Actualiser ou r?essayez ult?rieurement. -------------------------------------------------------------------------------- Nom commenc? avec un caract?re non valide. Erreur de traitement de la ressource http://www.dupertuis.com/catalog/xml. Lign... <PRICE>130.45</PRICE><MANUFACTURER>Velleman</MANUFACTURER><MODEL>vm101</MODEL><URL>... <{POST_SNAPBACK}> Quote IEUFLR2000 Link to comment Share on other sites More sharing options...
mac22 Posted June 12, 2005 Share Posted June 12, 2005 Dear Kenny I have 2 languages shop ( polish and english) Is't possible to get data ( xml.php/xml2.php) from only one language or separete them ??? regards maciej Quote Link to comment Share on other sites More sharing options...
soloo Posted June 12, 2005 Share Posted June 12, 2005 Hi First of all, thanks for your work - this contribution is great! but, i have a strange problem - most of my products displays 2 times, and in xml2 even 4 times. For example: in xml1 <PRODUCT ITEM='150'><NAME>Uvex Shooter SV</NAME><PRICE>149.00</PRICE><MANUFACTURER>Uvex</MANUFACTURER><WEIGHT>0.00</WEIGHT><MODEL></MODEL><QUANTITY>100</QUANTITY><URL>http://www.extremeshop.pl/extremeshop/product_info.php?products_id=150</URL><IMAGE_URL>http://www.extremeshop.pl/extremeshop/images/Okulary/shooter_sv_5499_d.jpg</IMAGE_URL><ADDED>2004-11-05 19:36:00</ADDED><MODIFIED>2005-04-17 12:20:08</MODIFIED><AVAILABLE></AVAILABLE></PRODUCT><PRODUCT ITEM='150'><NAME></NAME><PRICE>149.00</PRICE><MANUFACTURER>Uvex</MANUFACTURER><WEIGHT>0.00</WEIGHT><MODEL></MODEL><QUANTITY>100</QUANTITY><URL>http://www.extremeshop.pl/extremeshop/product_info.php?products_id=150</URL><IMAGE_URL>http://www.extremeshop.pl/extremeshop/images/Okulary/shooter_sv_5499_d.jpg</IMAGE_URL><ADDED>2004-11-05 19:36:00</ADDED><MODIFIED>2005-04-17 12:20:08</MODIFIED><AVAILABLE></AVAILABLE></PRODUCT> in xml2 <CATEGORY id='33' name='Okulary'><PRODUCT ITEM='148'><NAME>Uvex Sportsonic Chromium</NAME><PRICE>399.00</PRICE><MANUFACTURER>Uvex</MANUFACTURER><WEIGHT>0.00</WEIGHT><MODEL></MODEL><QUANTITY>100</QUANTITY><URL>http://www.extremeshop.pl/extremeshop/product_info.php?products_id=148</URL><IMAGE_URL>http://www.extremeshop.pl/extremeshop/images/Okulary/sportsonic_chrom5416_d.jpg</IMAGE_URL><ADDED>2004-11-05 19:33:51</ADDED><MODIFIED>2005-04-17 12:21:31</MODIFIED><AVAILABLE></AVAILABLE></PRODUCT><PRODUCT ITEM='148'><NAME>Uvex Sportsonic Chromium</NAME><PRICE>399.00</PRICE><MANUFACTURER>Uvex</MANUFACTURER><WEIGHT>0.00</WEIGHT><MODEL></MODEL><QUANTITY>100</QUANTITY><URL>http://www.extremeshop.pl/extremeshop/product_info.php?products_id=148</URL><IMAGE_URL>http://www.extremeshop.pl/extremeshop/images/Okulary/sportsonic_chrom5416_d.jpg</IMAGE_URL><ADDED>2004-11-05 19:33:51</ADDED><MODIFIED>2005-04-17 12:21:31</MODIFIED><AVAILABLE></AVAILABLE></PRODUCT><PRODUCT ITEM='148'><NAME></NAME><PRICE>399.00</PRICE><MANUFACTURER>Uvex</MANUFACTURER><WEIGHT>0.00</WEIGHT><MODEL></MODEL><QUANTITY>100</QUANTITY><URL>http://www.extremeshop.pl/extremeshop/product_info.php?products_id=148</URL><IMAGE_URL>http://www.extremeshop.pl/extremeshop/images/Okulary/sportsonic_chrom5416_d.jpg</IMAGE_URL><ADDED>2004-11-05 19:33:51</ADDED><MODIFIED>2005-04-17 12:21:31</MODIFIED><AVAILABLE></AVAILABLE></PRODUCT><PRODUCT ITEM='148'><NAME></NAME><PRICE>399.00</PRICE><MANUFACTURER>Uvex</MANUFACTURER><WEIGHT>0.00</WEIGHT><MODEL></MODEL><QUANTITY>100</QUANTITY><URL>http://www.extremeshop.pl/extremeshop/product_info.php?products_id=148</URL><IMAGE_URL>http://www.extremeshop.pl/extremeshop/images/Okulary/sportsonic_chrom5416_d.jpg</IMAGE_URL><ADDED>2004-11-05 19:33:51</ADDED><MODIFIED>2005-04-17 12:21:31</MODIFIED><AVAILABLE></AVAILABLE></PRODUCT> i don't know php or mysql too well, i hope you could help me with this problem! Quote Link to comment Share on other sites More sharing options...
Guest Posted June 13, 2005 Share Posted June 13, 2005 Dear Kenny I have 2 languages shop ( polish and english) Is't possible to get data ( xml.php/xml2.php) from only one language or separete them ??? regards maciej <{POST_SNAPBACK}> Hi maciej, Just so I understand properly - Are you wanting to have 2 seperate feeds, i.e. one showing english product titles and one showing Polish titles? Regards, Kenny Quote Link to comment Share on other sites More sharing options...
Guest Posted June 13, 2005 Share Posted June 13, 2005 HiFirst of all, thanks for your work - this contribution is great! but, i have a strange problem - most of my products displays 2 times, and in xml2 even 4 times. For example: in xml1 <PRODUCT ITEM='150'><NAME>Uvex Shooter SV</NAME><PRICE>149.00</PRICE><MANUFACTURER>Uvex</MANUFACTURER><WEIGHT>0.00</WEIGHT><MODEL></MODEL><QUANTITY>100</QUANTITY><URL>http://www.extremeshop.pl/extremeshop/product_info.php?products_id=150</URL><IMAGE_URL>http://www.extremeshop.pl/extremeshop/images/Okulary/shooter_sv_5499_d.jpg</IMAGE_URL><ADDED>2004-11-05 19:36:00</ADDED><MODIFIED>2005-04-17 12:20:08</MODIFIED><AVAILABLE></AVAILABLE></PRODUCT><PRODUCT ITEM='150'><NAME></NAME><PRICE>149.00</PRICE><MANUFACTURER>Uvex</MANUFACTURER><WEIGHT>0.00</WEIGHT><MODEL></MODEL><QUANTITY>100</QUANTITY><URL>http://www.extremeshop.pl/extremeshop/product_info.php?products_id=150</URL><IMAGE_URL>http://www.extremeshop.pl/extremeshop/images/Okulary/shooter_sv_5499_d.jpg</IMAGE_URL><ADDED>2004-11-05 19:36:00</ADDED><MODIFIED>2005-04-17 12:20:08</MODIFIED><AVAILABLE></AVAILABLE></PRODUCT> in xml2 <CATEGORY id='33' name='Okulary'><PRODUCT ITEM='148'><NAME>Uvex Sportsonic Chromium</NAME><PRICE>399.00</PRICE><MANUFACTURER>Uvex</MANUFACTURER><WEIGHT>0.00</WEIGHT><MODEL></MODEL><QUANTITY>100</QUANTITY><URL>http://www.extremeshop.pl/extremeshop/product_info.php?products_id=148</URL><IMAGE_URL>http://www.extremeshop.pl/extremeshop/images/Okulary/sportsonic_chrom5416_d.jpg</IMAGE_URL><ADDED>2004-11-05 19:33:51</ADDED><MODIFIED>2005-04-17 12:21:31</MODIFIED><AVAILABLE></AVAILABLE></PRODUCT><PRODUCT ITEM='148'><NAME>Uvex Sportsonic Chromium</NAME><PRICE>399.00</PRICE><MANUFACTURER>Uvex</MANUFACTURER><WEIGHT>0.00</WEIGHT><MODEL></MODEL><QUANTITY>100</QUANTITY><URL>http://www.extremeshop.pl/extremeshop/product_info.php?products_id=148</URL><IMAGE_URL>http://www.extremeshop.pl/extremeshop/images/Okulary/sportsonic_chrom5416_d.jpg</IMAGE_URL><ADDED>2004-11-05 19:33:51</ADDED><MODIFIED>2005-04-17 12:21:31</MODIFIED><AVAILABLE></AVAILABLE></PRODUCT><PRODUCT ITEM='148'><NAME></NAME><PRICE>399.00</PRICE><MANUFACTURER>Uvex</MANUFACTURER><WEIGHT>0.00</WEIGHT><MODEL></MODEL><QUANTITY>100</QUANTITY><URL>http://www.extremeshop.pl/extremeshop/product_info.php?products_id=148</URL><IMAGE_URL>http://www.extremeshop.pl/extremeshop/images/Okulary/sportsonic_chrom5416_d.jpg</IMAGE_URL><ADDED>2004-11-05 19:33:51</ADDED><MODIFIED>2005-04-17 12:21:31</MODIFIED><AVAILABLE></AVAILABLE></PRODUCT><PRODUCT ITEM='148'><NAME></NAME><PRICE>399.00</PRICE><MANUFACTURER>Uvex</MANUFACTURER><WEIGHT>0.00</WEIGHT><MODEL></MODEL><QUANTITY>100</QUANTITY><URL>http://www.extremeshop.pl/extremeshop/product_info.php?products_id=148</URL><IMAGE_URL>http://www.extremeshop.pl/extremeshop/images/Okulary/sportsonic_chrom5416_d.jpg</IMAGE_URL><ADDED>2004-11-05 19:33:51</ADDED><MODIFIED>2005-04-17 12:21:31</MODIFIED><AVAILABLE></AVAILABLE></PRODUCT> i don't know php or mysql too well, i hope you could help me with this problem! <{POST_SNAPBACK}> Hi Soloo, first time I have seen this happen, definately strange! - I would think it's either a problem with your database or a slight misconfiguration in the xml files. If your shop is operating properly and displaying data ok then I would guess it's a problem with the settings in xml/xml2.php. If you can email me both your xml.php and xml2.php files to the email address listed in the addon files and I will have a look over the code for you. Regards, Kenny Quote Link to comment Share on other sites More sharing options...
joylounge Posted June 15, 2005 Share Posted June 15, 2005 Hi I have added an extra field as described in the advanced HTML doc, word for word but i get an error. CODE // START -> insert any custom sql queries for extra tags here $product_extra_sql = "SELECT products_bimage FROM products WHERE products_id =' " . $row['products_id'] . "'"; $products_extra_query = mysql_query($product_extra_sql,$connection); $products_extra = mysql_fetch_array($products_extra_query); // END -> insert any custom sql queries for extra tags here Then CODE // START -> insert any extra custom tags here echo '<BIMAGE>' . $products_extra['products_bimage'] . '</BIMAGE '>'; // END -> insert any extra custom tags here Here is the error I receive:- The XML page cannot be displayed Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later. Only one top level element is allowed in an XML document. Error processing resource. Can any one help or point me in the correct direction - thanks Quote Link to comment Share on other sites More sharing options...
mac22 Posted June 15, 2005 Share Posted June 15, 2005 Hi maciej, Just so I understand properly - Are you wanting to have 2 seperate feeds, i.e. one showing english product titles and one showing Polish titles? Regards, Kenny <{POST_SNAPBACK}> Hi Kenny, I get mixed feed: english and polish without any order I would like to get i.e. only polish or only english or first part in polish second in english regards Maciej Quote Link to comment Share on other sites More sharing options...
soloo Posted June 17, 2005 Share Posted June 17, 2005 Hi Kenny, I get mixed feed: english and polish without any order I would like to get i.e. only polish or only english or first part in polish second in english regards Maciej <{POST_SNAPBACK}> my problems also seem to be caused because of english and polish language. it would be great to choose in which language the products should be displayed. Quote Link to comment Share on other sites More sharing options...
Guest Posted June 19, 2005 Share Posted June 19, 2005 Hi Kenny, I get mixed feed: english and polish without any order I would like to get i.e. only polish or only english or first part in polish second in english regards Maciej <{POST_SNAPBACK}> Hi Maciej & Soloo Ok I think both of your problems are connected and due to the fact of more than one language in use (maybe Polish in particular?) so I think all three of us can try and work together on a solution. Soloo is already in contact with me on email, Maciej if you can drop me an email so I have your email address and I will contact you both shortly. For anyone else experiencing a problem while using more than one language please hang on a while and as soon as a solution is ready I will post it here thanks Kenny Quote Link to comment Share on other sites More sharing options...
Guest Posted June 19, 2005 Share Posted June 19, 2005 Hi I have added an extra field as described in the advanced HTML doc, word for word but i get an error. CODE // START -> insert any custom sql queries for extra tags here $product_extra_sql = "SELECT products_bimage FROM products WHERE products_id =' " . $row['products_id'] . "'"; $products_extra_query = mysql_query($product_extra_sql,$connection); $products_extra = mysql_fetch_array($products_extra_query); // END -> insert any custom sql queries for extra tags here Then CODE // START -> insert any extra custom tags here echo '<BIMAGE>' . $products_extra['products_bimage'] . '</BIMAGE '>'; // END -> insert any extra custom tags here Here is the error I receive:- The XML page cannot be displayed Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later. Only one top level element is allowed in an XML document. Error processing resource. Can any one help or point me in the correct direction - thanks <{POST_SNAPBACK}> Hi Gary, this could be an error due to characters contained in the products_bimage variable. Can you me give me an example of what sort of data is in this variable - e.g: is it a image url? Thanks, Kenny Quote Link to comment Share on other sites More sharing options...
Eyals Posted June 19, 2005 Share Posted June 19, 2005 Hello all, Since I can't reach Kenny and I'm trying to apply some kind of urgent mod to this contribuion, I decided to ask for you help: I need a parent simple HTML page that shows all categories taken from xml.php, when I click on the category, it'll open and XML output of items from this category only. Looks pretty easy to do but I can't figure myself how (I have very very limted php understanding), I also tried XSL stylesheet with no luck. Can someone help please. Thanks. Quote Link to comment Share on other sites More sharing options...
soloo Posted June 22, 2005 Share Posted June 22, 2005 hey Kenny! i have another problem - i've managed to correct the problem with languages, or at least go around it - i've deleted english language from my osc - no one was using it anyway. but i wanted to add to your script a new tag, that would display description of the products. i've added it like this: //---------------------------------------------------------------------------------------------- // START -> insert any custom sql queries for extra tags here //---------------------------------------------------------------------------------------------- $product_extra_sql = "SELECT products_description FROM products_description WHERE products_id =' " . $row['products_id'] . "'"; $products_extra_query = mysql_query($product_extra_sql,$connection); $products_extra = mysql_fetch_array($products_extra_query); //---------------------------------------------------------------------------------------------- // END -> insert any custom sql queries for extra tags here //---------------------------------------------------------------------------------------------- //---------------------------------------------------------------------------------------------- // START -> insert any extra custom tags here //---------------------------------------------------------------------------------------------- echo '<DESCRIPTION>' . $products_extra['products_description'] . '</DESCRIPTION>'; //---------------------------------------------------------------------------------------------- // END -> insert any extra custom tags here //---------------------------------------------------------------------------------------------- but all i get is an error, like this: http://www.extremeshop.pl/extremeshop/xml3.php (it says that there is an error in xml query, at line 14, sign 64, and the description text is below, with this error sign marked in red.) any ideas? i'm totally new in this stuff.... Quote Link to comment Share on other sites More sharing options...
Guest Posted June 24, 2005 Share Posted June 24, 2005 hey Kenny!i have another problem - i've managed to correct the problem with languages, or at least go around it - i've deleted english language from my osc - no one was using it anyway. but i wanted to add to your script a new tag, that would display description of the products. i've added it like this: //---------------------------------------------------------------------------------------------- // START -> insert any custom sql queries for extra tags here //---------------------------------------------------------------------------------------------- $product_extra_sql = "SELECT products_description FROM products_description WHERE products_id =' " . $row['products_id'] . "'"; $products_extra_query = mysql_query($product_extra_sql,$connection); $products_extra = mysql_fetch_array($products_extra_query); //---------------------------------------------------------------------------------------------- // END ? -> insert any custom sql queries for extra tags here //---------------------------------------------------------------------------------------------- //---------------------------------------------------------------------------------------------- // START -> insert any extra custom tags here //---------------------------------------------------------------------------------------------- echo '<DESCRIPTION>' . $products_extra['products_description'] . '</DESCRIPTION>'; //---------------------------------------------------------------------------------------------- // END ? -> insert any extra custom tags here //---------------------------------------------------------------------------------------------- but all i get is an error, like this: http://www.extremeshop.pl/extremeshop/xml3.php (it says that there is an error in xml query, at line 14, sign 64, and the description text is below, with this error sign marked in red.) any ideas? i'm totally new in this stuff.... <{POST_SNAPBACK}> hey, I'm thinking it's probably an illegal character - what sort of data is in your new tag? can you show me some examples - thanks. Kenny Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.