Renegade — Wed, 23 Nov 2005 07:49:22 +0000

Ah.. ok, thanks guys

edpudol — Wed, 23 Nov 2005 06:03:34 +0000

chrishirst wrote: Yes it's possible, but only with MySQL 5.0 and then only if the tables are ISAM and have been set up with FULLTEXT indexes.

Other than that you will have to set up your SQL command to search specific columns, otherwise you will have errors when a text search is done against a non-text field

chrishirst solution is the best I guess... the Full text is working in mysql 4.0 just set the fields you want to be include in the query as FULL TEXT.

Then here is a query sample:

Quote:
$sql = "SELECT * FROM WHERE MATCH (,,,) AGAINST ('%$query%')";

$query is variable

Busy — Mon, 21 Nov 2005 09:27:06 +0000

Usually your searching for wrong context, like a value as a character

Renegade — Mon, 21 Nov 2005 07:18:02 +0000

What does this error mean?

Unable to jump to row 0 on MySQL result index 8

Renegade — Sun, 20 Nov 2005 09:45:57 +0000

Great, thanks

Abhishek Reddy — Sun, 20 Nov 2005 07:38:07 +0000

Renegade wrote: What happens if the query is empty... how do I do a check (in PHP) because if(!$result) doesn't work...

If there is no error, then the !result check is useless for testing the returned value:

PHP Manual wrote: For SELECT, SHOW, DESCRIBE or EXPLAIN statements, mysql_query() returns a resource on success, or FALSE on error.

You will have to analyse the data in the resource to check the number of rows:

PHP Manual wrote:
The returned result resource should be passed to mysql_fetch_array(), and other functions for dealing with result tables, to access the returned data.

Use mysql_num_rows() to find out how many rows were returned for a SELECT statement

http://php.inspire.net.nz/manual/en/function.mysql-query.php

Renegade — Sun, 20 Nov 2005 06:12:35 +0000

What happens if the query is empty... how do I do a check (in PHP) because if(!$result) doesn't work...

Renegade — Fri, 18 Nov 2005 08:45:45 +0000

Great, thanks Greg

Greg K — Fri, 18 Nov 2005 05:34:41 +0000

Probably the code I gave you (or similar) would work the best.

-Greg

Renegade — Fri, 18 Nov 2005 00:23:23 +0000

Thanks Greg, here is what PHPMyAdmin spat out when I created the table:

CREATE TABLE `club` (
`userID` INT NOT NULL AUTO_INCREMENT ,
`sport` VARCHAR( 255 ) NOT NULL ,
`location` VARCHAR( 255 ) NOT NULL ,
`name` VARCHAR( 255 ) NOT NULL ,
`number` VARCHAR( 255 ) NOT NULL ,
`email` VARCHAR( 255 ) ,
`website` VARCHAR( 255 ) ,
`details` TEXT,
PRIMARY KEY ( `userID` )
) TYPE = MYISAM ;