how to alter the display for a field (newbie)

[gesf]

For the date/time case you can use a query like this:

Code: Select all

SELECT FROM_UNIXTIMESTAMP(timestamp_field, '%Y-%M-%D') AS MyDate FROM table

You need to run the proper query so you can get the needed result set from PhpMyAdmin.
For your case it would be something like:

Code: Select all

SELECT * FROM design_table WHERE category_id IN (SELECT id FROM categories)