Steve is right you can do it that way, but I would put in the area where you
insert the information into the database. Either way is correct. but I find
this way easier and you don't take up any area on your from. (preferences)

@mysql_select_db("$DBName") or die("Unable to select
database $DBName");
$logtime = date("Y-m-j G:i:s");
$sqlquery = "INSERT INTO $table

>From the PHP site:
  a.. a - "am" or "pm"

  b.. A - "AM" or "PM"

  c.. B - Swatch Internet time

  d.. d - day of the month, 2 digits with leading zeros; i.e. "01" to "31"

  e.. D - day of the week, textual, 3 letters; i.e. "Fri"

  f.. F - month, textual, long; i.e. "January"

  g.. g - hour, 12-hour format without leading zeros; i.e. "1" to "12"

  h.. G - hour, 24-hour format without leading zeros; i.e. "0" to "23"

  i.. h - hour, 12-hour format; i.e. "01" to "12"

  j.. H - hour, 24-hour format; i.e. "00" to "23"

  k.. i - minutes; i.e. "00" to "59"

  l.. I (capital i) - "1" if Daylight Savings Time, "0" otherwise.

  m.. j - day of the month without leading zeros; i.e. "1" to "31"

  n.. l (lowercase 'L') - day of the week, textual, long; i.e. "Friday"

  o.. L - boolean for whether it is a leap year; i.e. "0" or "1"

  p.. m - month; i.e. "01" to "12"

  q.. M - month, textual, 3 letters; i.e. "Jan"

  r.. n - month without leading zeros; i.e. "1" to "12"

  s.. O - Difference to Greenwich time in hours; i.e. "+0200"

  t.. r - RFC 822 formatted date; i.e. "Thu, 21 Dec 2000 16:01:07 +0200"
(added in PHP 4.0.4)

  u.. s - seconds; i.e. "00" to "59"

  v.. S - English ordinal suffix for the day of the month, 2 characters;
i.e. "th", "nd"

  w.. t - number of days in the given month; i.e. "28" to "31"

  x.. T - Timezone setting of this machine; i.e. "MDT"

  y.. U - seconds since the epoch

  z.. w - day of the week, numeric, i.e. "0" (Sunday) to "6" (Saturday)

  aa.. W - ISO-8601 week number of year, weeks starting on monday (added in
PHP 4.1.0) (Saturday)

  ab.. Y - year, 4 digits; i.e. "1999"

  ac.. y - year, 2 digits; i.e. "99"

  ad.. z - day of the year; i.e. "0" to "365"

  ae.. Z - timezone offset in seconds (i.e. "-43200" to "43200"). The offset
for timezones west of UTC is always negative, and for those east of UTC is
always positive.

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to