[PHP][SQL]problem z datą w aukcji Opcje

[antko]

hej. mam problem. czy ktos moze powiedziec mi dlaczego data w aukcji wciacz ustawia mi sie na styczen (january)


<?php

session_start();

include("config.php");
include("functions.php");

$db = mysql_connect($dbhost, $dbuser, $dbpassword);
mysql_select_db($dbdatabase, $db);

$validid = pf_validate_number($_GET['id'], "redirect", $config_basedir);

if($_POST['submit']) {

if(is_numeric($_POST['bid']) == FALSE) {
header("Location: " . $config_basedir . "itemdetails.php?id=" . $validid . "&error=letter");
}

$theitemsql = "SELECT * FROM items WHERE id = " . $validid . ";";
$theitemresult = mysql_query($theitemsql);
$theitemrow = mysql_fetch_assoc($theitemresult);

$checkbidsql = "SELECT item_id, max(amount) AS highestbid, count(id) AS number_of_bids FROM bids WHERE item_id=" . $validid . " GROUP BY item_id;";
$checkbidresult = mysql_query($checkbidsql);
$checkbidnumrows = mysql_num_rows($checkbidresult);

if($checkbidnumrows == 0) {
if($theitemrow['startingprice'] > $_POST['bid']) {
header("Location: " . $config_basedir . "itemdetails.php?id=" . $validid . "&error=lowprice#bidbox");
}
}
else {
$checkbidrow = mysql_fetch_assoc($checkbidresult);

if($checkbidrow['highestbid'] > $_POST['bid']) {
header("Location: " . $config_basedir . "itemdetails.php?id=" . $validid . "&error=lowprice#bidbox");
}
}

$inssql = "INSERT INTO bids(item_id, amount, user_id) VALUES("
. $validid
. ", " . $_POST['bid']
. ", " . $_SESSION['USERID']
. ");";
mysql_query($inssql);

header("Location: " . $config_basedir . "itemdetails.php?id=" . $validid);
}
else {

require("header.php");

$itemsql = "SELECT UNIX_TIMESTAMP(dateends) AS dateepoch, items.* FROM items WHERE id = " . $validid . ";";
$itemresult = mysql_query($itemsql);

$itemrow = mysql_fetch_assoc($itemresult);

$nowepoch = mktime();
$rowepoch = $itemrow['dateepoch'];

if($rowepoch > $nowepoch) {
$VALIDAUCTION = 1;
}

echo "<h1>" . $itemrow['name'] . "</h1>";

$imagesql = "SELECT * FROM images WHERE item_id = " . $validid . ";";
$imageresult = mysql_query($imagesql);
$imagenumrows = mysql_num_rows($imageresult);

$bidsql = "SELECT item_id, MAX(amount) AS highestbid, COUNT(id) AS number_of_bids FROM bids WHERE item_id=" . $validid . " GROUP BY item_id;";
$bidresult = mysql_query($bidsql);
$bidnumrows = mysql_num_rows($bidresult);

echo "<p>";

if($bidnumrows == 0) {
echo "<strong>This item has had no bids</strong> - <strong>Starting Price</strong>: " . $config_currency . sprintf('%.2f', $itemrow['startingprice']);
}
else {
$bidrow = mysql_fetch_assoc($bidresult);
echo "<strong>Number Of Bids</strong>: " . $bidrow['number_of_bids'] . " - <strong>Current Price</strong>: " . $config_currency . sprintf('%.2f', $bidrow['highestbid']);
}

echo " - <strong>Auction ends</strong>: " . date("D jS F Y g.iA", $rowepoch);

echo "</p>";

if($imagenumrows == 0) {
echo "No images.";
}
else {
while($imagerow = mysql_fetch_assoc($imageresult)) {
echo "<img src='./images/" . $imagerow['name'] ."' width='200'>";
}
}

echo "<p>" . nl2br($itemrow['description']) . "</p>";

echo "<a name='bidbox'></a>";
echo "<h2>Bid for this item</h2>";

if(isset($_SESSION['USERNAME']) == FALSE) {
echo "To bid, you need to log in. Login <a href='login.php?id=" . $validid . "&ref=addbid'>here</a>.";
}
else {
if($VALIDAUCTION == 1) {
echo "Enter the bid amount into the box below.";
echo "<p>";

switch($_GET['error']) {
case "lowprice":
echo "The bid entered is too low. Please enter another price.";
break;

case "letter":
echo "The value entered is not a number.";
break;
}

?>

<form action="<?php echo pf_script_with_get($SCRIPT_NAME); ?>" method="post">
<table>
<tr>
<td><input type="text" name="bid"></td>
<td><input type="submit" name="submit" value="Bid!"></td>
</tr>
</table>
</form>

<?php
}
else {
echo "This auction has now ended.";
}

$historysql = "SELECT bids.amount, users.username FROM bids, users WHERE bids.user_id = users.id AND item_id = " . $validid . " ORDER BY amount DESC";
$historyresult = mysql_query($historysql);
$historynumrows = mysql_num_rows($historyresult);

if($historynumrows >= 1) {
echo "<h2>Bid History</h2>";
echo "<ul>";

while($historyrow = mysql_fetch_assoc($historyresult)) {
echo "<li>" . $historyrow['username'] . " - " . $config_currency . sprintf('%.2f', $historyrow['amount']) . "</li>";
}

echo "</ul>";
}
}
}

require("footer.php");

?>