fulltext mysql query not working! help!

PoorDoggie · 05-08-2005, 12:10 PM

PHP Code:

  <?php

 
    include('config.php');

 
    if( isset($_POST['q']) ){

 
        // if a form was submitted

        $sql = "SELECT * FROM ".$config['table']." WHERE MATCH (".$config['name'].",".$config['type'].",".$config['glass'].") AGAINST ('".$_POST['q']."')";

        

        $result = mysql_query($sql);

        

        if( !$result ){

 
            echo "could not query database: ".die(mysql_error());

 
        }

        

        $b = mysql_num_rows($result);

        

        echo $b;

        

        while( $a = mysql_fetch_array($result) ){

 
            echo "Name: ";

            echo $a['name'];

 
        }

    

    }

    else{

 
        // if a form was NOT submitted

        // display the form

        

        ?>

        

        <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">

            <input name="q" id="q" /><input type="submit" id="submit" />

        </form>

        

        <?php

 
    }

 
?>

That is my script, and it dosen't work. I put [into the input named "q"] the exact value of one of the values, but it still outputs "0" to $b. Help!

Thanks
Tom

adam_uk · 05-08-2005, 01:06 PM

can you post a built query

just echo $sql

also have you created the indexes?

PoorDoggie · 05-08-2005, 01:25 PM

Quote:

Originally Posted by adam_uk

can you post a built query

just echo $sql

also have you created the indexes?

SELECT * FROM drinks WHERE MATCH (drink_name,drink_type,drink_glass) AGAINST ('search_term')

what do you mean created the indexes? I did "... FULLTEXT (drink_name,drink_type,drink_glass)..." in the "create table" mysql coding.

adam_uk · 05-08-2005, 01:47 PM

Quote:

Originally Posted by PoorDoggie

SELECT * FROM drinks WHERE MATCH (drink_name,drink_type,drink_glass) AGAINST ('search_term')

what do you mean created the indexes? I did "... FULLTEXT (drink_name,drink_type,drink_glass)..." in the "create table" mysql coding.

when using fulltext searching you need to make indexes of your data, this is where the searches are.

ie did you exectue a sql query like this:

Quote:

CREATE FULLTEXT INDEX full_index ON mytable(
mytable_title ,
mytable_caption ,
mytable_full_body
);

if you didnt this is why your fulltext searches are not operating

it can get quite complex if your searching differenent columns each time

http://www.phpfreaks.com/tutorials/129/0.php

PoorDoggie · 05-08-2005, 02:08 PM

Quote:

Originally Posted by adam_uk

when using fulltext searching you need to make indexes of your data, this is where the searches are.

ie did you exectue a sql query like this:

if you didnt this is why your fulltext searches are not operating

it can get quite complex if your searching differenent columns each time

http://www.phpfreaks.com/tutorials/129/0.php

what do I put where you have "mytable, mytable_title, mytable_caption & mytable_full_body"???

adam_uk · 05-08-2005, 02:14 PM

you need to edit that query to match your table layout and the columns you want to create indexes for.

once you have the query built you need to execute it. via phpmyadmin. or via command on ssh.

if you read the article above it will explain it better than i can.

PoorDoggie · 05-08-2005, 02:21 PM

thanks

PoorDoggie · 05-09-2005, 02:46 PM

nope, still not working. Do you think it could be anything to do with my server? (either web server or mysql server?)

RJ · 05-09-2005, 02:52 PM

Try it like this,

PHP Code:

   
        // if a form was submitted

 
$q = addslashes($_POST['q']); 

 
$sql = "SELECT * FROM ".$config['table']." WHERE ".$config['name']." like '%".$q."%' or ".$config['type']." like '%".$q."%' or ".$config['glass']." like '%".$q."%'";

PoorDoggie · 05-10-2005, 10:15 AM

Quote:

Originally Posted by -RJ-

Try it like this,

PHP Code:

   
        // if a form was submitted

 
$q = addslashes($_POST['q']); 

 
$sql = "SELECT * FROM ".$config['table']." WHERE ".$config['name']." like '%".$q."%' or ".$config['type']." like '%".$q."%' or ".$config['glass']." like '%".$q."%'";

great! works... thanks!

adam_uk · 05-10-2005, 12:48 PM

while that will work its not actually full text searching. and things like boolean searches wont work.

PoorDoggie · 05-10-2005, 01:57 PM

Quote:

Originally Posted by adam_uk

while that will work its not actually full text searching. and things like boolean searches wont work.

you mean like: "drink +name" and "'drink name'" and stuff? I don't think that matters, it wasn't how I was gonna do it anyway! lol

Thanks all!

05-08-2005, 12:10 PM	#1 (permalink)
PoorDoggie Soon to be RICHdoggie! Join Date: Jan 2005 Location: UK Posts: 2,390 316.50 NP$ (Donate)	fulltext mysql query not working! help! PHP Code: <?php include('config.php'); if( isset($_POST['q']) ){ // if a form was submitted $sql = "SELECT * FROM ".$config['table']." WHERE MATCH (".$config['name'].",".$config['type'].",".$config['glass'].") AGAINST ('".$_POST['q']."')"; $result = mysql_query($sql); if( !$result ){ echo "could not query database: ".die(mysql_error()); } $b = mysql_num_rows($result); echo $b; while( $a = mysql_fetch_array($result) ){ echo "Name: "; echo $a['name']; } } else{ // if a form was NOT submitted // display the form ?> <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>"> <input name="q" id="q" /><input type="submit" id="submit" /> </form> <?php } ?> That is my script, and it dosen't work. I put [into the input named "q"] the exact value of one of the values, but it still outputs "0" to $b. Help! Thanks Tom __________________ █ Exchange your long URL for a much smaller one! █ Free Anonymizer/Proxy █ Taz Martin's blog - Learn all about internet marketing, promoting your website and much more!

05-08-2005, 02:21 PM	#7 (permalink)
PoorDoggie Soon to be RICHdoggie! Join Date: Jan 2005 Location: UK Posts: 2,390 316.50 NP$ (Donate)	thanks __________________ █ Exchange your long URL for a much smaller one! █ Free Anonymizer/Proxy █ Taz Martin's blog - Learn all about internet marketing, promoting your website and much more!

05-09-2005, 02:46 PM	#8 (permalink)
PoorDoggie Soon to be RICHdoggie! Join Date: Jan 2005 Location: UK Posts: 2,390 316.50 NP$ (Donate)	nope, still not working. Do you think it could be anything to do with my server? (either web server or mysql server?) __________________ █ Exchange your long URL for a much smaller one! █ Free Anonymizer/Proxy █ Taz Martin's blog - Learn all about internet marketing, promoting your website and much more!

05-09-2005, 02:52 PM	#9 (permalink)
RJ NamePros Founder Administrator Join Date: Feb 2003 Location: Bay Area, CA Posts: 13,173 104,201.68 NP$ (Donate)	Try it like this, PHP Code: `// if a form was submitted $q = addslashes($_POST['q']); $sql = "SELECT * FROM ".$config['table']." WHERE ".$config['name']." like '%".$q."%' or ".$config['type']." like '%".$q."%' or ".$config['glass']." like '%".$q."%'";`

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
HOWTO: Install the Apache Web Server, Perl, PHP, and MySQL on Windows	deadserious	Webmaster Tutorials	96	05-27-2007 01:24 PM
Tutorial: How to Install Apache2 MySQL and PHP on Windows	deadserious	Webmaster Tutorials	35	09-21-2005 09:46 PM
mysql problem	Shof515	Programming	3	12-14-2004 09:20 PM
Tutorial: Getting Started With MySQL (The Basics)	deadserious	Webmaster Tutorials	3	04-18-2004 01:17 PM

05-08-2005, 01:06 PM	#2 (permalink)
adam_uk Senior Member Join Date: May 2003 Posts: 2,211 6,170.25 NP$ (Donate)	can you post a built query just echo $sql also have you created the indexes?

05-08-2005, 02:14 PM	#6 (permalink)
adam_uk Senior Member Join Date: May 2003 Posts: 2,211 6,170.25 NP$ (Donate)	you need to edit that query to match your table layout and the columns you want to create indexes for. once you have the query built you need to execute it. via phpmyadmin. or via command on ssh. if you read the article above it will explain it better than i can.

05-10-2005, 12:48 PM	#11 (permalink)
adam_uk Senior Member Join Date: May 2003 Posts: 2,211 6,170.25 NP$ (Donate)	while that will work its not actually full text searching. and things like boolean searches wont work.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Administrator