#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    chennai, tamil nadu, INDIA
    Posts
    27
    Rep Power
    0
    String fexp="";
    fexp=request.getParameter("fexpcujob");

    String ftq="";
    ftq=request.getparameter("ftechquali");

    here jobreg is the table name and expcujob, quali is the field name.

    String query = "SELECT * FROM jobreg WHERE jobreg.expcujob=" + fexp;
    this is working for only one search condition.

    if i give two search condition, the below query is not working.
    String str_query2 = "SELECT * FROM jobreg WHERE jobreg.expcujob && jobreg.quali=" + fexp ,+ ftq;

    kindly send the immediate reply.



  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2000
    Posts
    5
    Rep Power
    0
    check the SQL syntax ... This is what I think it should look like:

    String str_query2 = "SELECT * FROM jobreg WHERE jobreg.expcujob=" + fexp + " and jobreg.quali=" + ftq;

    :-)


    ------------------
    PB

Similar Threads

  1. URGENT multiple selections in list ,processed with PHP & MYSQL
    By jt-developer in forum PHP Development
    Replies: 1
    Last Post: January 15th, 2004, 06:37 AM
  2. URGENT - mySQL Root Access
    By benjimcc in forum MySQL Help
    Replies: 1
    Last Post: January 14th, 2004, 08:21 AM
  3. Upgrade from access to mysql
    By karib1 in forum ASP Programming
    Replies: 7
    Last Post: December 16th, 2003, 12:35 PM
  4. Upgrade from access to mysql
    By karib1 in forum MySQL Help
    Replies: 1
    Last Post: December 16th, 2003, 12:27 AM

IMN logo majestic logo threadwatch logo seochat tools logo