Datum in DB schreiben ( update )

[webmasteralf]

O.K.

Ausgabe :

Array
(
    [0] => 86826
    [id] => 86826
    [1] => leinesser
    [username] => leinesser
    [2] => 1156
    [hits] => 1156
    [3] => 0
    [admin] => 0
    [4] => 337fc3649879da199183821947d4afee
    [pw] => 337fc3649879da199183821947d4afee
    [5] => [email]Uwe@leinesser.de[/email]
    [email] => [email]Uwe@leinesser.de[/email]
    [6] => 1
    [visible] => 1
    [7] => 1800
    [timeout] => 1800
    [8] => 300
    [timeout_onl] => 300
    [9] => 1064985839
    [date_start] => 1064985839
    [10] => 2003-11-29
    [lizenz_end] => 2003-11-29
    [11] => mit_banner
    [lizenz_typ] => mit_banner
    [12] => 1071125062
    [last_access] => 1071125062
    [13] => 13804
    [access_diff] => 13804
    [14] => 100
    [hit_mail] => 100
    [15] => 50
    [loglim] => 50
    [16] => 900
    [stats_cache] => 900
    [17] => [url]http://www.leinesser.de[/url] 
[url]http://leinesser.de[/url]
[url]http://www.leinesser.de/filme[/url] 
[url]http://leinesser.de/filme[/url]
[url]http://home.arcor.de/leinesser[/url]
[url]http://home.arcor.de/le/leinesser[/url]
    [your_url] => [url]http://www.leinesser.de[/url] 
[url]http://leinesser.de[/url]
[url]http://www.leinesser.de/filme[/url] 
[url]http://leinesser.de/filme[/url]
[url]http://home.arcor.de/leinesser[/url]
[url]http://home.arcor.de/le/leinesser[/url]
    [18] => 
    [ipblock] => 
    [19] => 
    [refblock] => 
    [20] => 
    [ownref] => 
    [21] => 
    [qstr] => 
    [22] => 
    [index_files] => 
    [23] => 0
    [demo] => 0
    [24] => 1
    [flags] => 1
    [25] => 0
    [dlunite] => 0
    [26] => arialbd.ttf
    [ttf_file] => arialbd.ttf
    [27] => 3
    [gd_font] => 3
    [28] => 20
    [ttf_size] => 20
    [29] => #ffffff
    [bg_c] => #ffffff
    [30] => #0000e7
    [fg_c] => #0000e7
    [31] => 1
    [bg_trans] => 1
    [32] => 13
    [cssid] => 13
    [33] => 1
    [gmt] => 1
    [34] => de
    [lang] => de
    [35] => 1
    [conf] => 1
    [36] => 0
    [del_usr] => 0
    [37] => 0
    [limh] => 0
    [38] => 1000
    [limh_p] => 1000
    [39] => 0
    [limd] => 0
    [40] => 0
    [limd_p] => 0
    [41] => 0
    [kwspl] => 0
    [42] => 16048
    [tblsize] => 16048
    [43] => 29.11.2003
    [new_lizenz_end] => 29.11.2003
)

DB-Struktur :

#
# Tabellenstruktur für Tabelle `pphl_users`
#

CREATE TABLE `pphl_users` (
  `id` int(5) unsigned NOT NULL default '0',
  `username` varchar(30) NOT NULL default '',
  `hits` int(10) unsigned NOT NULL default '0',
  `admin` tinyint(1) NOT NULL default '0',
  `pw` varchar(32) NOT NULL default '',
  `email` varchar(70) NOT NULL default '',
  `visible` tinyint(1) NOT NULL default '1',
  `timeout` int(5) NOT NULL default '1800',
  `timeout_onl` int(5) NOT NULL default '300',
  `date_start` int(10) unsigned NOT NULL default '0',
  `lizenz_end` date NOT NULL default '0000-00-00',
  `lizenz_typ` varchar(30) NOT NULL default '',
  `last_access` int(10) unsigned NOT NULL default '0',
  `access_diff` int(5) unsigned NOT NULL default '0',
  `hit_mail` int(5) NOT NULL default '100',
  `loglim` int(10) unsigned NOT NULL default '50',
  `stats_cache` int(7) unsigned NOT NULL default '900',
  `your_url` text,
  `ipblock` text,
  `refblock` text,
  `ownref` text,
  `qstr` text,
  `index_files` text,
  `demo` tinyint(1) NOT NULL default '0',
  `flags` tinyint(1) NOT NULL default '1',
  `dlunite` tinyint(1) NOT NULL default '0',
  `ttf_file` varchar(30) NOT NULL default 'arialbd.ttf',
  `gd_font` int(2) NOT NULL default '3',
  `ttf_size` int(2) NOT NULL default '14',
  `bg_c` varchar(30) default 'black',
  `fg_c` varchar(30) default 'lightgrey',
  `bg_trans` tinyint(1) NOT NULL default '0',
  `cssid` int(10) unsigned NOT NULL default '13',
  `gmt` float NOT NULL default '1',
  `lang` char(2) NOT NULL default 'en',
  `conf` tinyint(1) NOT NULL default '0',
  `del_usr` tinyint(1) NOT NULL default '0',
  `limh` int(6) unsigned NOT NULL default '0',
  `limh_p` int(6) unsigned NOT NULL default '1000',
  `limd` int(3) unsigned NOT NULL default '0',
  `limd_p` int(3) unsigned NOT NULL default '0',
  `kwspl` tinyint(1) NOT NULL default '0',
  `tblsize` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `conf_del_usr` (`conf`,`del_usr`)
) TYPE=MyISAM;

Aktuell eingestzter Code :

$sql = "SELECT *,DATE_FORMAT(lizenz_end,'%d.%m.%Y') as new_lizenz_end  FROM ".$tbl_users." WHERE id='$id' OR username='$id'";
$res = mysql_query($sql);
$lizenzend = mysql_fetch_array($res);
echo $lizenzend['new_lizenz_end']; 

Hoff das hilft weiter !

Gruss und Danke

[MelloPie]

und wo is dein Problem?

[new_lizenz_end] => 29.11.2003 das is doch genau was Du wolltest, oder???

[webmasteralf]

Ihr werdet mich bestimmt auslachen,
aber nachdem ich gemerkt hatte das
das Datum richtig angezeigt wird,
habe ich den Code vom ganzen Script getrennt
und siehe da es funktionierte !

1000x Dank für Eure Bemühungen und Hilfe

Gruss und Danke Alf

[Wurzel]

OffTopic:

---

schon jemand die kamera gefunden ?

---

[webmasteralf]

TSCHULDIGUNG !

[MelloPie]

Statist!