fulltext mysql query not working! help!

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

PHP Code:

  <?php

????: NamePros.com http://www.namepros.com/programming/88679-fulltext-mysql-query-not-working-help.html
 
    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: ";

????: NamePros.com http://www.namepros.com/showthread.php?t=88679
            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, 02:06 PM

can you post a built query

just echo $sql

also have you created the indexes?

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

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')
????: NamePros.com http://www.namepros.com/showthread.php?t=88679

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, 02:47 PM

Originally Posted by PoorDoggie

SELECT * FROM drinks WHERE MATCH (drink_name,drink_type,drink_glass) AGAINST ('search_term')
????: NamePros.com http://www.namepros.com/showthread.php?t=88679

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, 03:08 PM

Originally Posted by adam_uk

when using fulltext searching you need to make indexes of your data, this is where the searches are.
????: NamePros.com http://www.namepros.com/showthread.php?t=88679

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, 03: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, 03:21 PM

thanks

PoorDoggie · 05-09-2005, 03: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, 03:52 PM

Try it like this,

PHP Code:

   
        // if a form was submitted

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

????: NamePros.com http://www.namepros.com/showthread.php?t=88679
 
$sql = "SELECT * FROM ".$config['table']." WHERE ".$config['name']." like '%".$q."%' or ".$config['type']." like '%".$q."%' or ".$config['glass']." like '%".$q."%'";

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

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."%'"; 

????: NamePros.com http://www.namepros.com/showthread.php?t=88679

great! works... thanks!

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

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

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

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
????: NamePros.com http://www.namepros.com/showthread.php?t=88679

Thanks all!

05-08-2005, 01:10 PM	THREAD STARTER #1 (permalink)
PoorDoggie Soon to be RICHdoggie! Join Date: Jan 2005 Location: UK Posts: 2,408	fulltext mysql query not working! help! PHP Code: <?php ????: NamePros.com http://www.namepros.com/programming/88679-fulltext-mysql-query-not-working-help.html 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: "; ????: NamePros.com http://www.namepros.com/showthread.php?t=88679 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

05-09-2005, 03:52 PM	#9 (permalink)
RJ NamePros Webmaster Join Date: Feb 2003 Posts: 12,930 Follow @DomainBuyer	Try it like this, PHP Code: `// if a form was submitted $q = addslashes($_POST['q']); ????: NamePros.com http://www.namepros.com/showthread.php?t=88679 $sql = "SELECT * FROM ".$config['table']." WHERE ".$config['name']." like '%".$q."%' or ".$config['type']." like '%".$q."%' or ".$config['glass']." like '%".$q."%'";` __________________ @DomainBuyer facebook

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 02:24 PM
Tutorial: How to Install Apache2 MySQL and PHP on Windows	deadserious	Webmaster Tutorials	35	09-21-2005 10:46 PM
mysql problem	Shof515	Programming	3	12-14-2004 10:20 PM
Tutorial: Getting Started With MySQL (The Basics)	deadserious	Webmaster Tutorials	3	04-18-2004 02:17 PM

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

05-08-2005, 03:14 PM	#6 (permalink)
adam_uk Senior Member Join Date: May 2003 Posts: 2,187	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-08-2005, 03:21 PM	THREAD STARTER #7 (permalink)
PoorDoggie Soon to be RICHdoggie! Join Date: Jan 2005 Location: UK Posts: 2,408	thanks

05-09-2005, 03:46 PM	THREAD STARTER #8 (permalink)
PoorDoggie Soon to be RICHdoggie! Join Date: Jan 2005 Location: UK Posts: 2,408	nope, still not working. Do you think it could be anything to do with my server? (either web server or mysql server?)

05-10-2005, 01:48 PM	#11 (permalink)
adam_uk Senior Member Join Date: May 2003 Posts: 2,187	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)