Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

p. and pd.


Guest

Recommended Posts

Posted

Hey i was wondering what does the p. and pd. mean in the coding of php?

ex)

p.product_id

Posted

That's actually SQL, and it corolated tables.

 

Really, it's an alias for the products (p) and products_description (pd) tables.

-------------------------------------------------------------------------------------------------------------------------

NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit.

If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.

Posted

oh man thank you very very very much that is exactly what i wanted to hear ;) now i can finally add onto my code :) is there anyways the defines that p. = products or does it automatically define itself as that?

Posted

Those are osCommerce standards ... you could of use fred.products_id when using the TABLE_PRODUCT . ' fred ... blah blah

 

But, p. for product and pd. for products_description was faster ... :wink:

Posted

Somewhere in the SQL, you should find a section thast goes like....

 

select......from products p, products description pd

 

 

 

This is what assignes p to products and pd to products_description.

 

Best of luck.

-------------------------------------------------------------------------------------------------------------------------

NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit.

If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...