Gun to head: need code... :(

Anon

So, the ruger is cocked and loaded, and I need some code! I am having a bitch trying to get data from my table by keyword via a keyword search (search bar).

It either says "no matches" when in fact I KNOW the word exist, or it dumps all of my data in some large, unreadable blob.

Suggestions? Or should I just pull the trigger?

Guido

ace21

you should either tell us more or pull the trigger.

Ace21

cordex

I prefer 1911 style .45s (kimber, springfied armory or colt), but whatever floats your boat. A ruger will get the job done, I suppose.

To your problem: I don't know what kind of table you are using and I don't know what commands you are using. I don't even know if you're using hardball or hollow point. As Ace21 said, we need more info.

-Ben

Anon

I guess he pulled the trigger....

Anon

Pulling the trigger is the easy way out....

Ok -- my fields/rows

num (auto_incriment) primary key
title
url
description
keywords
location
channel
email
date_entered (timestamp)

WHEN I type something into my searchbar, regardless of what row, I'd like those entries with this word to be displayed. In the end, what WILL be displayed should be:

Title name (hyperlinked with URL) and the description. This will be your typical "portal search" result page. The keywords are to be searched, but not displayed.

Currently my code is:
<?php

mysql_connect("localhost","abcde","12345678") or die("Unable to connect");
@mysql_select_db("my_db") or die("Unable to select database");
$result = mysql_query("SELECT * FROM my_table");
$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"; }
?>

When I go through the search bar, regardless what I put in, I get "No matches" -- if I simple type in the URL of the .php file (that holds this code), it displays all the records in a big cluster.

Hammering cocked back....

Guido

Anon

I've got some black-eagle talons in that bad boy -- Ruger .45 to be exact (colt is fine, but mine holds 15 -- + 1 if I'm feeling really stupid) 😉 See my answer to Ace21 for more info. (looks like a SQL statement)

Guido

Anon

Uhmm... try using the keyword in your sql search (that's what sql is for !!)

$result = mysql_query("SELECT * FROM my_table WHERE keywords LIKE '%$pattern%'");

The percent signs around the $pattern indicate wildcards. Hope that helps.

Chris King

Anon

Well, not much happens -- if I put keywords in, then I will only search that row, and not the entire table -- 🙁

Thanks for the advice -- I'll see what I can do!

Guido

kparker

Looks to me like you're searching the wrong column!

Given:

   [0] num (auto_incriment) primary key
   [1] title
   [2] url
   [3] description
   [4] keywords
   [5] location
   [6] channel
   ...

it seems like you should be searching $row[4], not $row[6]. And certainly, if all you're looking for is a string literal match, then Chris's suggestion is the way to go.

While we're at it (and please no flaming!)--why do you say

   $pattern=$searchterm;
   if (preg_match("/$pattern/i", ...

when you could just as easily use $searchterm directly:

   if(preg_match("/$searchterm/i",

Anon

Thanks for the info.

Well, something should be noted, I wanted to search BY keyword, but this doesn't mean I simply want to search the keywords column. I pretty much want to search by all of the columns, maybe except num, date, and url.

As for your question about the code choice -- I'm sorry I can't really give an answer -- my good friend William Royere (a code godhead) was instructing me -- he was sending me stuff I've never SEEN in my life -- maybe I'll ask him your question -- see what kind of reply I get.

Regards,

Guido