Create a new field:
displaydate varchar(255) NOT NULL default ''
then INSERT this into it:
%d/%m/%y
OK Now for the page code. Add your database connection code as usual, then.
<HTML>
<HEAD>
<TITLE>
Products in Stock
</TITLE>
</HEAD>
<body background="images/webbackground.gif">
<DIV align="center">
<CENTER>
<TABLE border="0" cellpadding="0" cellspacing="0" width="90%">
<?php
$result = mysql_db_query("YourDBName", "SELECT * FROM AllocatedStock");
$row = mysql_fetch_array($result);
$displaydate = $row["displaydate"];
$productlist = mysql_query("SELECT UID, ProductCode, Description, Name, Contact1, SalesPerson, ReleasedToClient, date_format(date,'$displaydate') AS formatted FROM AllocatedStock ORDER BY date DESC");
while ($product = mysql_fetch_array($productlist)) {
$ProductCode = $product["ProductCode"];
$Description = $product["Description"];
$Name = $product["Name"];
$time = $product["formatted"];
$Contact1 = $product["Contact1"];
$SalesPerson = $product["SalesPerson"];
$ReleasedToClient = $product["ReleasedToClient"];
$UID = $product["UID"];
?>
<TR align="center">
<TD width="10%">
<?=$ProductCode ?>
</TD>
<TD width="10%">
<?=$UID ?>
</TD>
<TD width="20%">
<?=$Description ?>
<br>
<br>
</TD>
<TD width="14%">
<?=$Name ?>
</TD>
<TD width="14%">
<?=$Contact1 ?>
</TD>
<TD width="10%">
<?=$SalesPerson ?>
</TD>
<TD width="10%">
<?=$time ?>
</TD>
<TD width="10%">
<?php
$tokusch = $ReleasedToClient;
If ($toclient < 1)
{
echo "No";
}
Else
{
echo "Yes";
}
?>
</TD>
</TR>
<?php
}
?>
</TABLE>
</CENTER>
</body>
</HTML>
Code: Select all
<?php
?>Code: Select all