Page 2 of 2

Posted: Sat Dec 21, 2002 4:52 am
by evilcoder
OK OK OK, try this:

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

?>

Posted: Sun Dec 22, 2002 12:31 am
by Kevey
Maybe I've misread what you're trying to do here, but this is how I usually fix date problems in MSSQL:

I replace each "0:00" with "", and, if needed, each "Jan","Feb" etc with "01","02" ...
It seems to work okay for me, possibly helps here.

str_replace("0:00","",string);
Your code would be something like:

Code: Select all

<HTML> 
<HEAD> 
<TITLE> 
Products in Stock 
</TITLE> 
</HEAD> 

<?php 

$query = "SELECT DATE_FORMAT(DateOut, '%W %M %Y') FROM AllocatedStock"; 

if (!($result = mssql_query($query))) 
&#123; 
echo("Error 1"); 
exit(); 
&#125; 
?> 

<body background="images/webbackground.gif"> 
<DIV align="center"> 
<CENTER> 
<TABLE border="0" cellpadding="0" cellspacing="0" width="90%"> 
<?php 

while(($row = mssql_fetch_array($result))) 
&#123; 
?> 
<TR align="center"> 
<TD width="10%"> 
<?php 
echo trim($row&#1111;"ProductCode"]); 
?> 
</TD> 
<TD width="10%"> 
<?php 
echo trim($row&#1111;"UID"]); 
?> 
</TD> 
<TD width="20%"> 
<?php 
echo trim($row&#1111;"Description"]); 
?> 
<br> 
<br> 
</TD> 
<TD width="14%"> 
<?php 
echo trim($row&#1111;"Name"]); 
?> 
</TD> 
<TD width="14%"> 
<?php 
echo trim($row&#1111;"Contact1"]); 
?> 
</TD> 
<TD width="10%"> 
<?php 
echo trim($row&#1111;"SalesPerson"]); 
?> 
</TD> 
<TD width="10%"> 
<?php 

$nDate=trim($row&#1111;"DateOut"]);

$nDate2 = str_replace("0:00", "",$nDate);

$nDate3= str_replace("Jan", "01",$nDate2);

echo $nDate3; 

?> 
</TD> 
<TD width="10%"> 
<?php 
$tokusch = $row&#1111;"ReleasedToClient"]; 
If ($toclient < 1) 
&#123; 
echo "No"; 
&#125; 
Else 
&#123; 
echo "Yes"; 
&#125; 
?> 
</TD> 
</TR> 
<?php 
&#125; 

?> 
</TABLE> 
</CENTER> 
</DIV> 

<p><br> 
</p> 
</body> 
</HTML>

THANK YOU!

Posted: Tue Dec 24, 2002 5:32 am
by jayeshdave
Thanks gyardleydn!

It now works great, thanks for all your help and patience.

I'm sure I will be needing more help soon!

Thanks.