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 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. bnownlater

    Need clarification on FullText information

    I am using SHOW INDEX on one of my tables that I have a FULLTEXT index on. Table: article non_unique: 1 key_name: THEARTICLE seq_in_index: 1 column_name: THEARTICLE collation: A Cardinality: NULL sub_part: 1 packed: NULL comment: FULLTEXT I read that sub_part means: "The prefix length in...
  2. bnownlater

    Need to convert Mysql to Excel?

    I need to display data from MySQL to Excel format. I looked at several excel classes, but they are missing three things that I need. 1. To be able to output a cell larger than 255 characters. 2. Be able to keep line breaks in cells. 3. be able to format the cell widths I am currently using...
  3. bnownlater

    Need SLQ reg exp keyword search for MS ACCESS using PHP

    That is not going to work. i really not sure if you can even use regular expressions in a query to an MS Access db. This is the current sql query: $Sql="Select * FROM MYTABLE WHERE TITLE LIKE '%eat%' AND TITLE LIKE '%fish%'"; I want to be able to search the TITLE phrase for each...
  4. bnownlater

    Need SLQ reg exp keyword search for MS ACCESS using PHP

    I am using an php to access a MS Access db. I want to use a regular expression to find the keywords in a phrase, but only if they are the start of any word in that phrase. For example: $keyword="eat" Matched: eat the cat, he is eating, the man eater,.. No Match: beat the time, trun...
  5. bnownlater

    How to make MySQL make a if...else selection for PHP?

    $x=0; While ($x < mysql_numrows($result)): If ($row['FIELD1']== 1){ echo &quot;Peter&quot;; }elseif ($row['FIELD1'] == 2){ echo &quot;PAUL&quot;; }elseif...{ $x++; endwhile;
  6. bnownlater

    Need Help Joining FOUR Tables

    I am having problems with my database and need someone to take a look at it for me. Here are my table setups: PUB --------- PUB_ID PUB_NAME PUB_DATE ALT_PUB_DATE POST_DATE TITLE ABSTRACT PAGE URL COMPANY ---------- ID PUB_ID CO_NAME METATAG ----------- ID PUB_ID TOPIC STATE ----------- ID...
  7. bnownlater

    Problem: Simple mail() takes too long... need a suggestion

    Thanks to all. I know that our mail server is loacted in our DMZ. Not real sure what software it is running? Do not know how to telnet to port 25? My PHP.ini file is correct with the server name. Someone suggested to put the IP address instead of the server name, due to DNS resolve problems. I...
  8. bnownlater

    Problem: Simple mail() takes too long... need a suggestion

    I have a simple form with 15 variables that I mail to one person. The process is taking 30 + seconds to complete (which seems to be high)? Is there a better way to handle this? I am using 4.2.1 with Win NT. Here is my code: // Set the script's max execution time to 300 seconds...

Part and Inventory Search

Back
Top