[RESOLVED] Simple search script - no results?

LiamBailey

I tried to write a simple search script for my db, and it isn't working. Can anyone hypothsise as to why?

<? if ($submit)  

{ 
  $query = ("SELECT * FROM baileymail_articles ORDER BY id DESC");
  $result = mysql_query($query) or die(mysql_error());
	while ($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
	$article = $row['article']; $keywords = $row['keywords']; $description = $row['description']; $section = $row['section'];
	$type = $row['type']; $title = $row['title'];
     if (preg_match('/$search/',$article) || preg_match('/$search/','$keywords') || preg_match('/$search/','$description') || preg_match('/$search/','$section') || preg_match('/$search/','$type') || preg_match('/$search/','$title')) 
		 {

After that I have done the code for how I one each row returned by the search to be displayed. Why doesn't it work? No error codes or anything, and I have entered words I am sure are in the tables and no results are returned.

bogu

Try MySQL FULL-TEXT SEARCH, there are a lot of problems in your code, the simplest and more elegant method will be the one I listed 4 you ...

LiamBailey

As I have previously said before on these threads, I am working on my second site and have taken a cheap hosting package as my first is on expensive hosting and this is a trial site.

I have no idea what version of Mysql or php I am using but my PHPmyadmin is 2.1.1

I am trying this now to ("SELECT * from table WHERE MATCH (article) AGAINST ('$search') ORDER BY id DESC") and it is saying I have an unexpected T_VARIABLE on line 16, but I have not started any php at all until line 75, so I think it may be that I don't have access to that function from my version of Mysql?

bogu

LiamBailey wrote:
I am trying this now to ("SELECT * from table WHERE MATCH (article) AGAINST ('$search') ORDER BY id DESC") and it is saying I have an unexpected T_VARIABLE on line 16, but I have not started any php at all until line 75, so I think it may be that I don't have access to that function from my version of Mysql?

That's not a MySQL error ...

MySQL manual wrote:
As of MySQL 3.23.23, MySQL has support for full-text indexing and searching:

Put you head into it and you can do it, I'm sure of it ... 🙂

Just try the examples from the MySQL manual ...

Using preg_match the way you are using, it will give you a lot of errors ...

LiamBailey

I know it is not a mysql_error, it is a php error on a line way above php begins, I have checked carefully every single line for a php opening tag and there isn't one.

What i am using is pretty much exactly the same as the example in the mysql manual: here is my code:

if ($submit)  

{ include("DBCONNECT/connect.inc");
  $query = ("SELECT * FROM baileymail_articles WHERE MATCH (article) AGAINST ('$search') ORDER BY id DESC");
  $result = mysql_query($query) or die(mysql_error());
	while ($row = mysql_fetch_array($result,MYSQL_ASSOC)) {

LiamBailey

I got it, I didn;t have my fields full text indexed. Thanks I'm chuffed.

LiamBailey

I got it, I didn;t have my fields full text indexed. Thanks I'm chuffed.