--
Best regards,
George Nicolae
IT Manager
___________________
PaginiWeb.com - Professional Web Design
www.PaginiWeb.com
"Peter Silbermann" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I have an file application that works for some data but not other?? The
> error I'm getting causes an error on line 64
> for (reset($t1); $ti=current($tl)
i think the error is here ^^^^^^
should be $tl or $t1 ($t(one)). u put the "l" caracter and you should put
the "1"-"one" digit.
replay me if it works.
> any thoughts??
> <?php
>
> include "npdata.php";
> include "mapfuncs.php";
> global $connID, $opid, $nextpage;
>
> $li = get_complete_lot_info($lot);
> $ops = implode($li['ops'], ",");
>
> // To by pass a lot of unnecessary questioning of the operator
> // (which run? which operation? fixtures? pallets? yada yada
> // yada... I am going to pull the first operation that is identified
> // as being run on newport equipment in templateops. Then check
> // sys_loads for load information, then scam the stuff from the
> // newport database
>
> if (empty($opid)) {
> $sql = "SELECT op.Operation_ID FROM operations AS op ";
> $sql .= "INNER JOIN runs AS r ON (op.Run_ID = r.Run_ID) ";
> $sql .= "INNER JOIN templateops AS top ON (r.Type =
> top.Test_Code) ";
> $sql .= "AND (top.Operation = op.Operation) ";
> $sql .= "WHERE op.Operation_ID IN ($ops) AND top.Equip =
> 'NP' ORDER BY op.Operation_ID;";
>
> $res = mysql_query($sql);
> $op = (mysql_num_rows($res)? mysql_result($res, 0, 0): 0);
> } else {
> $opid = intval($opid);
> $opid = ((empty($opid) || ($opid<0))? 0: $opid);
> $op = ($opid? $li['ops'][$opid-1]: 0);
> }
>
>
> if ($op) {
> $sql = "SELECT System, Fixture, Positions, Pallet, Dev_ndx,
> 0 AS Test_list FROM sys_loads WHERE Operation_ID=$op;";
> $res = mysql_query($sql);
> if (mysql_num_rows($res)) {
> while ($obj = mysql_fetch_object($res)) {
> $loads[] = $obj;
> }
> // All devices should be loaded in the same
> system...
> $sysid = $loads[0]->System;
> $connID = connect_to_np_system($sysid);
> // get list of steps for the ENTIRE lot (used to be
> just one run)
> $sql = "SELECT s.Step_ID, s.Step, s.Params ";
> $sql .= "FROM runs AS r INNER JOIN operations AS op
> ON (r.Run_ID = op.Run_ID) ";
> $sql .= "INNER JOIN steps AS s ON (op.Operation_ID =
> s.Operation_ID) ";
> $sql .= "WHERE r.Lot_ID = '$lot' ORDER BY
> s.Step_ID;";
> $res = mysql_query($sql);
> if (mysql_num_rows($res)) {
> while ($obj = mysql_fetch_object($res)) {
> $steps[] = $obj;
> }
> for (reset($steps); $step=current($steps);
> next($steps)) {
> $p = explode(",", $step->Params);
> $name = $p[count($p)-1];
> // echo "ID: $step->Step_ID, Name:
> $name<br>\n";
> $list1[] = "<option
> value='$step->Step_ID'>$step->Step_ID. $name</option>";
> }
> for ($i=0; $i<count($loads); $i++) {
> // Get tests for each load in
> 'Newport' operation...
> $list2 = array();
> $load = $loads[$i];
> $tl =
> get_tests_by_fixture($load->Fixture, $lot);
> for (reset($tl); $ti=current($tl); next($tl)) {
> $ttype = ($ti[2]==0?
> "(LIV)": "(Burn-in)");
> $list2[] = "<option
> value='$ti[0]-$ti[1]'>$ti[0]-$ti[1] $ti[3] $ttype</option>";
> }
> $loads[$i]->Test_list = $list2;
> }
> echo "<table><tr><td
> width='120'> </td><td>";
> echo "<form name='frmTests'
> action='main.php' method='post'>\n";
> echo "<input type='hidden' name='page'
> value='$nextpage'>\n";
> echo "<input type='hidden' name='lot'
> value='$lot'>\n";
> echo "<input type='hidden' name='sysid'
> value='$sysid'>\n";
> echo "<input type='hidden' name='op'
> value='$op'>\n";
> echo "<table cellspacing='3' cellpadding='3'
> border='0'>\n";
> echo "<tr><td>Import Step:</td><td
> colspan='3'><select name='step'>\n";
> echo implode($list1, "\n");
> echo "</td></tr>\n";
>
> echo "<tr><td class='thdr'>Slot</td><td
> class='thdr'>Pallet</td>";
> echo "<td class='thdr'>Test(s)</td></tr>\n";
> $ptr=1;
> for (reset($loads); $load=current($loads);
> next($loads)) {
> echo
> "<tr><td>$load->Fixture</td>\n";
> echo "<td>$load->Pallet</td>\n";
> $nm = "tl" . $ptr++ . "[]";
> echo "<td><select name='$nm'
> multiple>\n";
> echo implode($load->Test_list,
> "\n");
> echo "</td></tr>\n";
> }
> echo "<tr><td> </td><td
> colspan='2'><input type='submit' value='Ok'></td></tr>\n";
> echo "</table>\n</form>\n";
> echo "</td></tr></table>\n";
> trav_set_focus('frmTests', 'step');
>
>
>
> } else {
> // No steps associated with lot. HUH?
> // Major error...
>
>
> }
> } else {
> // no newport operation loaded in sys_load
>
> }
> } else {
> // No newport operation available, shouldn't be trying to
> import
> // from newport anyway...
>
> }
>
> Peter Silbermann
> Tyco Electronics Inc.
> Fiber Optic Buisness Unit
> Active Products Group
> Device Validation
> 908-704-3303 (Work)
> 610-570-2185 (Mobile)
> [EMAIL PROTECTED]
>
> ?>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
