Sorry, but justs a quick remark on the top:
Have you looked at small and KAPITAL letters?
--
Franz Alt
[EMAIL PROTECTED]
> at work I run mysql 3.23.45. on a windows2000 machine with apache 1.3.23
> and php4.06. at home it's Linux SuSe *.0, mysql 4.03 apache 1.3.26 and
> php4.2.3. the problem is I'm having problems inserting data into
> temporary tables. the results are different running the same script.
> here is the script (It's semi long so please bear with me).
> $CreateTempTable=mysql_query("Create temporary table
> Tmp (maintId int unique,
> deptId varchar(30),
> exhibitId VARCHAR(30),
> datefinished date,
> progressId VARCHAR(33),
> reset int(1))");
> //create temp table for all occurrences during dates specified
>
> mysql_query("INSERT into Tmp
> SELECT maintId,
> deptId,
> exhibitId,
> datefinished,
> progressId,
> reset
> from maintenance where DateReported>='$firstdate'
> and DateReported<='$lastdate'");
> // insert into temporary table date reported data
>
> mysql_query("INSERT into Tmp
> SELECT maintId,
> deptId,
> exhibitId,
> datefinished,
> progressId,
> reset
> from maintenance where DateFinished>='$firstdate'
> and DateFinished<='$lastdate'");
> // insert into temporary table date finished data
>
> mysql_query("INSERT INTO Tmp
> SELECT maintId,
> deptId,
> exhibitId,
> datefinished,
> progressId,
> reset
> from maintenance where DateReported<='$firstdate'
> and DateFinished='0000-00-00'");
> //insert into temporary table unfinished and previously started data
>
> mysql_query("INSERT into Tmp
> SELECT maintId,
> deptId,
> exhibitId,
> datefinished,
> progressId,
> reset
> from maintenance where DateReported<='$firstdate'
> and DateFinished>='$lastdate'");
> // insert into temporary table finished and previously started data
>
> mysql_query("UPDATE Tmp set progressid='in progress'
> where DateFinished>'$lastdate'");
> //change database to show what was completed by lastdate
>
> mysql_query("alter table Tmp add complete
> tinyint default 0");
> //added to be able to sum() complete
>
> mysql_query("alter table Tmp add InProgress
> tinyint default 0");
> // added to be able to sum() InProgress
>
> mysql_query("Alter table Tmp add parts
> tinyint default 0");
> //added to be able to sum() parts
>
> mysql_query("ALTER TABLE Tmp add deferred
> tinyint default 0");
> //added to be able to sum() deferred
>
> mysql_query("UPDATE Tmp set complete='1' where
> progressId='complete'");
> //changed to be able to sum()complete
>
> mysql_query("UPDATE Tmp set InProgress='1'
> where progressId='in progress'");
> //changed to be able to sum()InProgress
>
> mysql_query("UPDATE Tmp set parts='1'
> where progressId='waiting for parts'");
> //changed to be able to sum()Waiting for parts
>
> mysql_query("UPDATE Tmp set deferred='1'
> where progressId='deferred'");
> //changed to be able to sum() deferred
>
> $row=mysql_query("SELECT dept.name,
> count(Tmp.deptId),
> sum(complete),
> sum(InProgress),
> sum(parts),
> sum(deferred),
> sum(reset)/sum(complete) * 100,
> sum(reset)/$days_result from Tmp, dept where
> Tmp.deptId=dept.deptid
> Group by dept.deptId order by dept.name");
> // selecting departments by groups
>
> if ($row==0)
> die(mysql_error());
> $totals=mysql_query("SELECT COUNT(deptId),sum(complete),
> sum(InProgress),sum(parts),sum(deferred),
> sum(reset)/sum(complete) * 100 ,sum(Tmp.reset)/$days_result from
> Tmp");
>
> any thoughts on the duplicates? this gives runs fine on mysql 3.2.53 but
> stops at duplivcate entries on 4.03.
>
> John Coder
>
>
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
