What is the best way to simulate a fulltext search on a MySQL table of type InnoDB?
Do I index the searchable fields and use the LIKE() function with appropriate
wildcards?
What are the performance implications with this? Switching back to a table type of
MyISAM is really not an option. Is t
I would suggest creating the select dropdown so that the value is actually the numeric
value of the month. i.e:
January
February
.
.
.
Then you can do a simple concat before adding to the database.
--Nicole
---
Nicole Swan
Web Programming Specialis
Have you made sure that the parent table(s) is type INNODB as well?
Also, in my experience, it is best to let the database be in charge of as many
database functions as possible as it helps maintain the data's integrity. In other
words, use foreign keys, indexing for speeding up searching, 'on
Do you have some code you can provide so we can get a better idea of what you're
trying to do?
My guess is that the filter isn't set up quite right (as in the base dn you're
attaching to get the dn is not formatted correctly). What exactly are you trying to
achieve?
--Nicole
---
Have you tried lowering the fldBody as well? Like:
SELECT autoQuesID,fldQuesTitle,fldBody
FROM tblFAQ_Question
WHERE LOWER(fldBody) LIKE '%$strSearchFor%';
And $strSearchFor has already been lowered, of course.
--Nicole
---
Nicole Swan
Web Programming Specialist
Carroll C
PROTECTED]
Sent: Tuesday, April 27, 2004 5:00 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Request for help on (My)SQL Statement
That would be the way to do it except that MySQL doesn't support sub-selects
until version 4.1, which is in alpha still.
-Micah
On Tuesday 27 April 2004 04:05 pm
Have you tried a nested query? I think your problem is that you're really using
information from two different tables.
Maybe:
UPDATE ngc_polling SET lastrundate = (SELECT max(post_time) FROM nuke_phpbb_posts);
--Nicole
---
Nicole Swan
Web Programming Specialist
Carroll
I thought I would mention that if you just "echo" or "print" an array, just the word
"array" is shown. If you do a var_dump($myArray) on the array, the values should be
shown. Otherwise you can get the values as follows:
$myArray = $_GET["b"];
//then get and print values
foreach( $myArray as
In PHP you could do something like:
$mydate = date("l, F jS, Y", strtotime($row["eventdate"]));
echo $mydate;
http://us4.php.net/manual/en/function.date.php gives a full listing of possible
formatting options.
--Nicole
---
Nicole Swan
Web Programming Specialist
Carroll C
"\r\n" should give a carriage return.
i.e:
$mytext = 'what up doc';
$mytext .= '\r\n not much';
--Nicole
---
Nicole Swan
Web Programming Specialist
Carroll College CCIT
(406)447-4310
-Original Message-
From: Hull, Douglas D [mailto:[EMAIL PROTECTED]
Sent: Friday
What does your HTML look like? Have you defined the delete checkbox as an array? For
example:
Notice the brackets to indicate an array.
--Nicole
---
Nicole Swan
Web Programming Specialist
Carroll College CCIT
(406)447-4310
-Original Message-
From: [EMAIL PRO
Have you tried using an 'OR' operator?
SELECT
*
FROM
table1,
table2,
table3
WHERE
table1.threadref IN (1,2,3,4,5) OR
table2.threadref IN (1,2,3,4,5) OR
table3.threadref IN (1,2,3,4,5)
--Nicole
---
Nicole Swan
Web Prog
>From a quick glance, I noticed that you have commented out the code that does the
>actual query against the MySQL database. This is the line:
// $result = mysql_query($query, $db);
Without this statement, there is no query to the database. It should be:
$result = mysql_query($query); //witho
13 matches
Mail list logo