How to add UPC, ISBN, etc ver 1.1 install problem

[Lighthouse]

hi,

 

hopefully sameone can help me,i am useing oscommerce-2.2ms1

en want to use this module but i am missing something he gives me this error:

Parse error: parse error, unexpected T_STRING in /home/virtual/site116/fst/var/www/html/shop/admin/categories.php on line 320

this is the line :

if ($HTTP_GET_VARS['action'] == 'new_product') {

if ( ($HTTP_GET_VARS['pID']) && (!$HTTP_POST_VARS) ) {

$product_query = tep_db_query("select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.tep_db_query("insert into " . TABLE_PRODUCTS p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . $HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "'");

 

what do i have to do? :?

 

thanks for the help!

 

Lighthouse

[Guest]

try this

 

$product_query = tep_db_query("select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.tep_db_query("insert into " . TABLE_PRODUCTS p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . $HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "'");

[Lighthouse]

sorry but i don't see the difference, or i mis understand it :oops:

can't help it i am still a newbie in php

 

but thanks any way!

 

 

Lighouse

[Guest]

the quote marks are delimited properly in the second one

[Lighthouse]

thx i found what you ment

but i am still missing something i can't see it field wen i add a new card i have to check first now

:D

realy thx

 

Lighthouse

[Lighthouse]

back a gain :cry:

i am a getting a head he is has insert the number but wen i want to reedit the product i see

1064 - You have an error in your SQL syntax near '("insert into" . TABLE_PRODUCTS p.products_image, p.products_price, p.products_' at line 1

 

select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.tep_db_query("insert into" . TABLE_PRODUCTS p.products_image, p.products_price, p.products_ISBN, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from products p, products_description pd where p.products_id = '28' and p.products_id = pd.products_id and pd.language_id = '4'

 

[TEP STOP]

 

here is the code

  if ($HTTP_GET_VARS['action'] == 'new_product') {

   if ( ($HTTP_GET_VARS['pID']) && (!$HTTP_POST_VARS) ) {

     $product_query = tep_db_query("select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.tep_db_query("insert into" . TABLE_PRODUCTS  p.products_image, p.products_price, p.products_ISBN, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . $HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "'");

     $product = tep_db_fetch_array($product_query);

 

how do i find the probleem, yes i am starting to understand php but its still to littel to find the problem,

and if this is ready i need tho find out why i cant see the isbn number in de cart the customer is seeing

i am useing two modules to add the funtion for more field the are not as complete as i had hoped for

 

but if i have finisht it i wil contribut it

 

Lichthouse