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!

Register Log in
  • Congratulations gkittelson 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. beyton7

    mysql WHERE statement

    No need to apologize, I should have worded my first post better. You are quite correct, replacing the = with LIKE solved my problem, thank you for your help.
  2. beyton7

    mysql WHERE statement

    You'll have to forgive me, as I am a total newbie to mysql, the actual mysql SELECT statement is :- SELECT * FROM catches WHERE name = 'colname' AND pegno = 'colpeg' AND specie = 'colspecie' ORDER BY name ASC 'colname' , 'colpeg' , 'colspecie' are my 3 variables, and in the dropdown boxes...
  3. beyton7

    mysql WHERE statement

    Thank you, I have tried using LIKE instead of %, but it returns nothing. Its not perl, but PHP, but its the mysql part of the query that I am struggling with, hence the post in this forum. mysql code: $query_rsName = sprintf("SELECT * FROM catches WHERE name = '%s' AND pegno = '%s' AND specie...
  4. beyton7

    mysql WHERE statement

    I am having a problem with a mysql where statement, using a PHP page I have 3 drop down boxes, each with a SELECT DISTINCT statement in them, all these work ok in selecting the distinct value. I have set in each of these an initially selected label of "All", with a value of %. On my results...

Part and Inventory Search

Back
Top