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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.