just one line:

($admin_allowed_stores[0] == '*' ? " " : " LEFT JOIN " . TABLE_PRODUCTS_TO_STORES . " p2s ON p.products_id = p2s.products_id ")

what role does the question mark play?

what role does the colon play?

how would you "read" or translate this line into english?

string query = "SELECT * FROM SomeTable p " ;

if($admin_allowed_stores[0] != "*")

  query += " LEFT JOIN SomeTable p2s ON p.products_id = p2s.products_id";

Here $admin_allowed_stores[0] is a variable.

TABLE_PRODUCTS_TO_STORES is a variable also for the second table name.

in C#

query += admin_allowed_stores == '*' ? " " : " LEFT JOIN "  + TABLE_PRODUCTS_TO_STORES + " p2s ON p.products_id = p2s.products_id ";

($admin_allowed_stores[0] == '*' ? " " : " LEFT JOIN " . TABLE_PRODUCTS_TO_STORES . " p2s ON p.products_id = p2s.products_id ")

this is the conditional operator syntax

x=condition?truevalue:falsevalue;

here the condition is if($admin_allowed_stores[0] == '*')

if this is true then " " (the true condition )is assigned.

if the condition is false " LEFT JOIN " . TABLE_PRODUCTS_TO_STORES . " p2s ON p.products_id = p2s.products_id ")

"." is string concatination operator used in php.in dot net "+" is used for the same purpose.

please mark it as answer if it satisfy.if you still have any query please feel free to ask.

thanks

sanjeev