how to alter the display for a field (newbie)

How to use phpmyadmin.... phpmyadmin related arguments. Even phpMyAdmin issues

Moderators: egami, macek, gesf

Post Reply
User avatar
Posts: 1716
Joined: Sun Dec 29, 2002 5:03 am
Location: Portugal / Sweden

Thu Apr 06, 2006 5:17 pm

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)
Gonçalo "gesf" Fontoura

Post Reply