Jump to content

timstring

Members
  • Posts

    6
  • Joined

  • Last visited

Posts posted by timstring

  1. Here is one of the simplest routines I have written--right? No, wrong. The script takes a table, folds, spindles, and mutilates it, and writes the data back to the table. Here's the code:

    $Quest = "SELECT * FROM TOAWorkorders";$FindTechResult = mysql_query($Quest, $cxn)		or die ('The easter bunny is watching you' . mysql_error());while ($row = mysql_fetch_array($FindTechResult)){		       $IdNum = $row['IdNum'];      $BBT = $row['BBT'];	        $BBTArray = explode("-", $BBT);       $TechNum = $BBTArray["0"];        $Title = $BBTArray["2"];        $Name = explode(" ", $BBTArray['1']);        $FirstName = $Name["0"];        $LastName = $Name["1"];			  echo $TechNum . ' !! ' . $FirstName . ' !! ' . $LastName . ' !! ' . $Title . '<br>'; $Quest = "UPDATE TOAWorkorders SET TechNum = '$TechNum', FirstName = '$FirstName', LastName = '$LastName', Title = '$Title' WHERE IdNum = '$IdNum'";$result = mysql_query($Quest, $cxn)  or die(mysql_error());  	 }

    The problem with the script is the `UPDATE` statement. The field is processed correctly, but the update only updates 2/3 of the table, leaving 33k of rows untouched. Any ideas??

  2. This may be an HTML or PHP problem, or Java as well. I am trying to write an alphabetical index from inside a php file. Here's what I'm trying to accomplish: PHP script searches the My SQL table A link is generated out of each itemOn clicking on the link, a php variable is setand the script moves on. I need information for a function that the onClick refers to. I've only found rudimentary examples, and none are any help. So, I'm sending the problem to you. tim

  3. No, it's an HTML question

    <form action="validate1.php" method="post" name="LogIn" class="center"><div class="small"><label>Tech Number:  <br /></label><input type="number"] name="TechEntry" id="focus-field"><br />

  4. Is there any want to focus on a field in iOs 6? I have tried various techniques and have found one that works on my desktop but not on the iPhone. I was told that this feature was included in iOs 5, but I can't figure out how to make it work. Here's the latest try:

    <body onload = "document.getElementById('focus-field').focus();"> 	   then:  <input type= "number" name="Display_Entry"  id="focus-field" />

    ty in advance tim "If builders buildings, the way that programmers write programs, the first woodpecker to come along would wreck civilization."

×
×
  • Create New...