Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

OSC XML Feed - Help & Discussion


Guest

Recommended Posts

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 by hpdl
Link to comment
Share on other sites

  • 2 weeks later...
  • Replies 84
  • Created
  • Last Reply

Top Posters In This Topic

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 by Mibble
Link to comment
Share on other sites

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:

IEUFLR2000

Link to comment
Share on other sites

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 .

 

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 by Mibble
Link to comment
Share on other sites

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:

 

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

Link to comment
Share on other sites

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 .

 

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

 

 

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 by Mibble
Link to comment
Share on other sites

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

IEUFLR2000

Link to comment
Share on other sites

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:

IEUFLR2000

Link to comment
Share on other sites

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:

 

Phillipe,

 

yes you can add the ISO code to this line e.g:

 

echo '<?xml version="1.0" encoding="ISO-8859-1"?>';

 

merci,

Kenny

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

IEUFLR2000

Link to comment
Share on other sites

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>...

Link to comment
Share on other sites

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>...

IEUFLR2000

Link to comment
Share on other sites

  • 3 weeks later...

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!

Link to comment
Share on other sites

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

 

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

Link to comment
Share on other sites

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!

 

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

 

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

Link to comment
Share on other sites

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

 

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.

Link to comment
Share on other sites

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

 

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

Link to comment
Share on other sites

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

 

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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....

Link to comment
Share on other sites

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....

 

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...