how to alter the display for a field (newbie)

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

Moderators: macek, egami, gesf

User avatar
gesf
Moderator
Moderator
Posts: 1717
Joined: Sun Dec 29, 2002 5:03 am
Location: Portugal / Sweden
Contact:

Postby gesf » 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)

Return to “phpMyAdmin”

Who is online

Users browsing this forum: No registered users and 0 guests