View Single Post
  #3 (permalink)  
Old 04-19-2008, 08:11 PM
legal101205 legal101205 is offline
Junior Member
 
Join Date: Apr 2008
Posts: 4
Default

Thx for your reply.

Yes, my wish is well to take all the table content and the start_date column in the timestamp format.
But in this query, i was just assuming to select the start_date column.

I used your correction but i got the same error.

Ok i forgot to remove the * :

Code:
$data = $db->fetchAll ( 'SELECT UNIX_TIMESTAMP(start_date) AS date_unix FROM tournament' );
Is there a way like you said to get the timestamp of a field and the rest of all the fields without naming each other column in the query ?

Thx for your help.

Nicolas

Last edited by legal101205 : 04-19-2008 at 08:27 PM.
Reply With Quote