Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Thomas001

    Axis 2 and Java

    Does anyone know where I can get a simple example of Java using Axis2, like a notify then request to get the information back? thanks, - thom
  2. Thomas001

    SQL field name iteration

    Yes indeed, it is skewed. There isn't anything I can do about it however because the other programmer already has his code sorting it out this way but with Perl. Basicly I'm trying to return the field name if the data within that column ='s the variable I set.
  3. Thomas001

    SQL field name iteration

    What if I'm trying to retreive multiple field names by matching a column they own. like: *E404 Joe *E403 Joe *E402 Joe *E401 Jim If I did a search for Joe, I would get E404, E403, E402, E401.. Am I explaining this well enough?
  4. Thomas001

    My SQL Query

    nevermind, apparrently there is only one entry. Though I may have to create another thread to house my next problem.. thanks cLFlaVA.
  5. Thomas001

    My SQL Query

    Give or take 15 different dept numbers. Perhaps it's the SQL statement? The loop looks flawless. Or maybe there should be a SQL statement within the loop.
  6. Thomas001

    My SQL Query

    I did, it returns: Print("[$sent_superemail] controls [$query] with a total of [$count]"); [JMONTGOM] controls [SELECT * FROM employees WHERE dept IN ('E1433')] with a total of [1]
  7. Thomas001

    My SQL Query

    this is still only giving me back one entry. $count = 0; $result = mysql_query("SELECT dept FROM $dbtable WHERE superemail = '$sent_superemail' "); $query = "SELECT * FROM $dbtable WHERE dept IN ("; if ($result) { while ($row = mysql_fetch_array($result)) { if ($count > 0)...
  8. Thomas001

    My SQL Query

    What if the superemail has multiple depts and I need to retreive all of them and use them in the next query?
  9. Thomas001

    My SQL Query

    $row = mysql_query("SELECT dept FROM $db_table WHERE superemail = '$sent_superemail' "); $set_dept = $row[?]; $sql = "SELECT * FROM $dbtable WHERE dept = '$set_dept' " Basicly I'm trying to get the dept based on the superemail, but I can't figure out how I would do it. I'm farely new to SQL...
  10. Thomas001

    Adding SQL fields on the fly..

    I know how to implement the for() loop.. But I don't know a good way to add multiple fields into my database.
  11. Thomas001

    Adding SQL fields on the fly..

    How would I go about adding multiple fields to a MySQL database that a user can specify within the same page?
  12. Thomas001

    Syntax Error..

    nm modif_sc was suppose to be sc =) =) =)
  13. Thomas001

    Syntax Error..

    This isn't getting put into the database, maybe it's because of a syntax error.. I'm not getting any error messages: $creation = "INSERT INTO $uber_table ( `subject` , `comment` , `modif_sc` , `name` , `type`, `date` ) VALUES ('$subject', '$comment'...
  14. Thomas001

    saving to file

    CODE FROM: kenrbnsn (TechnicalUser) /* page 1 */ <form action="<? echo $_SERVER['PHP_SELF'] ?>" method="POST"> Filename:&nbsp;<input type=text name=filename> Content: <textarea name=pageinfo></textarea> <input type=submit name=submit value="Create File"> </form> /* page 2 */ <? $filename =...
  15. Thomas001

    saving to file

    Something liek this: Click the save button in browser and it saves the variables to a text document that u can select where it saves.
  16. Thomas001

    saving to file

    Is there a way to bring up a "save as" dialog to save a certain set of variables? I also have a <textarea> that needs to be saved this way to. Thanks ^_-
  17. Thomas001

    Printing a SQL as array (easy solution?)

    aye, got it =) $query = "SELECT * FROM $uber_table"; $result = mysql_query($query); Retrieve($result); // Retrieve This Data and put into link form. // function Retrieve($array) { while ($rows = mysql_fetch_array($array)) { printf("<a href='%s'>%s</a> <br>\n", $rows['ID']...
  18. Thomas001

    Printing a SQL as array (easy solution?)

    $query = "SELECT subject FROM $uber_table"; $result = mysql_fetch_array(mysql_query($query)); Retrieve($result); // Retrieve This Data and put into link form. // function Retrieve($array) { foreach($array as $value) Print("$value <br>"); } Just trying to get this to print out all...
  19. Thomas001

    Printing an array..

    Does anyone know a good way I can print out an entire array? All I know is that it would probably require a loop of some sort. Thanks :)
  20. Thomas001

    added to database ?

    Would anyone know why I might not be getting an error message after trying to insert something into a database? It doesn't actually insert, and it worked fine yesterday.. The only thing I did was add new fields in the database. Help greatly appreciated.

Part and Inventory Search

Back
Top