Jump to content


  • Posts

  • Joined

  • Last visited

Everything 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. How do I format a number field? I don't want any commas.
  5. 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."
  6. How do I make an ordinary entry field case-sensitive. For example, Tims78456 != tim78456. thanks,tim
  • Create New...