[2dogrc]

Hey guys, doing a little php in osCommerce and got this error:

PHP Code:

Parse error: parse error, unexpected T_STRING in /home/i2dogrcc/public_html/ecommerce/os/catalog/includes/functions/general.php on line 1275 

here is line 1275

PHP Code:

    $the_products_catagory_query = tep_db_query("select products_id, categories_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . $products_id . "'" . " order by products_id,categories_id"); 

I am fairly unexperienced,
Thanx in advance!
2dogrc

[sszettella]

the problem is the "TABLE_PRODUCTS_TO_CATEGORIES". Is this a variable? if so, it should be preceded with a "$" sign:

Code:

$TABLE_PRODUCTS_TO_CATEGORIES

That's my best guess as to your intent, without further context, i can't really tell what you're trying to do with TABLE_PRODUCTS_TO_CATEGORIES.

[Keith]

I think it may be a constant definition (constants are often all uppercase), and therefore would need no dollar sign. Just a guess.

[Sabu]

undexpected t_string doesn't have to be specifically on the one line it references. Perhaps you've opened a string " on the line above it, and it thinks that the string continues down to this line where it runs into errors

[Acecool]

$the_products_catagory_query = tep_db_query("select products_id, categories_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . $products_id . "'" . " order by products_id,categories_id");


to

$the_products_catagory_query = tep_db_query('select products_id, categories_id from ' . TABLE_PRODUCTS_TO_CATEGORIES . ' where products_id="' . $products_id . '" order by products_id,categories_id');

If that does not work, give me the line above this line..

[perleo]

does the spaces make a difference as in

PHP Code:

 "some thing to join" . $var . "the var" 

should be

PHP Code:

"some thing to join".$var."the var" 

not to sure if that makes a difference

[FiRe]

nope no difference, just nicer with spaces..