Extracting results problem...

Anon

Group:

In my site search bar, I'm using the following:

<?php

mysql_connect("localhost","abcde","12345678") or die("Unable to connect");
@mysql_select_db("abcde_com") or die("Unable to select database");
$result = mysql_query("SELECT * FROM url_store");
$matchcount =0;
while ($row = mysql_fetch_row($result)) {
$pattern=$searchterm;
if(preg_match("/$pattern/i", $row[6])) {
echo "$row[1], $row[2], $row[3], $row[4], $row[5]";
$matchcount++;
}
}
if($matchcount == 0) { echo "No matches"; }

?>

The problem is, when I do a search in the search bar, it always comes back with "0 matches found" -- despite the fact I KNOW the word exist somewhere in my table. What is dumb Guido doing wrong now?

Guido

badman

to exactly tell you, i need to see what exists and what you are searching for!

you can also use query "select * from tbl_name where colname like "%searchedword%"

for words ending in 'searchedword' use "%searchedword"

for words starting with above use "searchedword%"

hope it helps!

[deleted]

"dumb guido" is not printing the results taht he wants to match the pattern agains.
If he did that, he'd see what is going wrong.
$row[6] could be completely the wrong data.

Or the pattern may be wrong, thus never matching anything.

Anon

I see -- so the variable $row should be replaced with what I have?

My rows are something like:

index_num
site_title
description
url
keywords
location
channel
date_entered

So, all I have to do is change the names, and it should work? Geeez, I'm getting less dumber and dumber, but I'z stil a dumb mo'fo!

Guido (not bad for a blok who just picked up the book two weeks ago)

[deleted]

Ehm.. not quite... I think.. 🙂

You do this:
if(preg_match("/$pattern/i", $row[6]))

and you do something depending on it's outcome.
So if it's not behaving like you think it should behave then the problem must be in this line.

So to debug it, I'd suggest printing $row[6] and $pattern to see if it all makes sense int the first place.

It is also much more readable and usable if instead of $row[6], you use $row['fieldname'].

Because, using 6 may work, but if you ever decide to change the table-layout or the query structire, item 6 on the row may change to a different field. When you use the column name, it will allways be the correct column.

Anon

Well, if I type in the URL to open the .php file -- it dumps all of the rows into the screen in one big blob -- BUT, when I try to find something (a word) in this blob via the searchbar, it says no matches. I just don't get it.

Does anyone have any scrips laying around to display data via a searchbar?

I think I'm in a rut.

Guido