Board index   FAQ   Search  
Register  Login
Board index php forum :: Database phpMyAdmin

how to alter the display for a field (newbie)

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

Moderators: macek, egami, gesf

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)
User avatar
gesf
Moderator
Moderator
 
Posts: 1718
Joined: Sun Dec 29, 2002 5:03 am
Location: Portugal / Sweden

Return to phpMyAdmin

Who is online

Users browsing this forum: No registered users and 6 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.