Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

How do you write this query and return equiv text?


jacobr

Recommended Posts

Does anybody know how to write a PHP query that says:

 

Look in database, table returned_products, returns_status value and return the equlivalent text for that number?

 

So in table RETURNED_PRODUCTS there is a column RETURNS_STATUS with a number that stands for the status of the return - i.e. 1 = Awaiting, 2 = Cancelled, 3 = Complete, etc...

 

I need it to see the number 3 (or whatever) and echo back into my HTML "Complete" (or whatever is appropriate).

 

Any ideas? Thanks!

 

Jacob

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...