Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

How do you write this query and return equiv text?


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!



Link to comment
Share on other sites


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

  • Create New...