Greetings this is the index page for my modified script of MyCart
It suddenly decided to create its own loop.
Can anyone see what I have done wrong as I can no longer work on it locally.
<?
require("cart.php");
DBinfo();
Brand();
Root();
mysql_connect("$DBHost","$DBUser","$DBPass");
$old=date("z")-1;
mysql("$DBName","DELETE FROM Users WHERE Date < $old");
$del=date("z")-1;
mysql("$DBName","DELETE FROM Mycurrent WHERE AB < $del");
mysql("$DBName","DELETE FROM Mypending WHERE AB < $del");
mysql("$DBName","DELETE FROM Mylist WHERE AB < $del");
mysql("$DBName","DELETE FROM Cartitems WHERE AB < $del");
mysql("$DBName","DELETE FROM Mypending WHERE AB < $del");
mysql("$DBName","DELETE FROM Mypoc WHERE AB < $del");
$result=mysql("$DBName","SELECT CartItemsID,Date FROM CartItems");
while ($row=mysql_fetch_row($result)) {
$CII=$row[0];
$CDa=$row[1];
$pieces=explode(":",$CDa);
$DCHK=$pieces[1];
if ($DCHK < $old) {
mysql("$DBName","DELETE FROM CartItems WHERE CartItemsID = '$CII'");
}
}
if ($UID != "") {
$result=mysql("$DBName","SELECT * FROM Users WHERE User='$UID'");
$num=mysql_num_rows($result);
if ($num == "0") {
$dt=date("YmdHis");
$UID="$dt$REMOTE_ADDR";
$date=date("z");
mysql("$DBName","INSERT INTO Users VALUES ('$UID','$date')");
Header("Location: $PHP_SELF?UID=$UID");
}
}
if ($UID == "") {
$dt=date("YmdHis");
$UID="$dt$REMOTE_ADDR";
$date=date("z");
mysql("$DBName","INSERT INTO Users VALUES ('$UID','$date')");
Header("Location: $PHP_SELF?UID=$UID");
}
commonHeader("$Company","Please select a category:");
$result=mysql("$DBName","SELECT * FROM Category ORDER BY CategoryID");
fontFace("Arial","<b>Please select a category:-</b><br><br>I am an:");
echo "<ul>";
$Cat="Australian Resident";
$CatID="1";
redFont("Arial","<li><a href='$Relative/detailsa.php?AD=$CatID&UID=$UID'>$Cat</a></li>");
echo "</ul>";
echo "<ul>";
$Cat="International Resident";
$CatID="2";
redFont("Arial","<li><a href='$Relative/detailsi.php?AD=$CatID&UID=$UID'>$Cat</a></li>");
echo "</ul><br>";
greenFont("Arial","<font size=\"-1\"><b>Information:</b><br><b>GST</b>=Goods and Services Tax (Australian Residents Only)<br>
<b>P&H</b>=Postage and Handling</font>");
introFooter($Relative,$UID);
?>
Thanks
