On Thu, 23 Jan 2003 00:27:26 +0800 Jason Wong <php-db@gremlins.biz> wrote: > On Wednesday 22 January 2003 23:53, Fabrizio Tivano wrote: > > I have a php-application witch use mysql DB; > > > > My db have a field (DATE) like timestamp(8) = 20030110, > > for lay-out problem i call field_DATE > > with a query : > > date_format(field_DATE, '%d-%m-%Y'), > > > > and it display the field_DATA; > > 10-01-2003 > > > > well.....at this point i need to post this field_DATA on another php script > > witch let me to make another SELECT on same DB; > > but now the $field_DATA variable is like 10-01-2003. > > > > How i can post $field_DATA variable such as 20030110 again? (the original > > DB_field). > > There are many ways to do this. One is: > > $date = explode('-', '10-01-2003'); > $newdate = $date[2] . $date[0] . $date[1]; > > -- > Jason Wong -> Gremlins Associates -> www.gremlins.biz > Open Source Software Systems Integrators > * Web Design & Hosting * Internet & Intranet Applications Development * > YEP! that's work fine! thanx a lot! fabrizio -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php