[Resolved] [Resolved] Keyword Sr(plz help)

Manat

lazzerous

first off, change your 'sku' field to be solely numeric

Next I would alter your select statement to order by sku first, and pertinance second

Third, during your while statement, only use the first entry from each sku

This shoudl accomplish what you've described.

sku | keyword | pertinance

1 | something | 1 <-- More pertinant
1 | blah | 2 <-- Less pertinant
2 | foo | 1
2 | bar |1
2 | biz |2
2 | baz |3

$get_entries = mysql_query("select * from skutable order by sku, pertinance desc") or die(mysql_error());

$sku_used = "0";

while ($row=mysql_fetch_array($get_entries))
    {
    if ($row[sku] != $sku_used)
        {
         echo "Most pertinant Sku:<br>\n";
         echo $row[keyword] . "<br><br>\n";
        $sku_used = $row[sku];
        }
    }

Manat

lazzerous

order in whichever way you want

the script I gave was to select everything, but only to display the most pertinent of each sku

if you want to select a particular entry by it's keyword, you would have a sql statement more like this:
select * from skutable where keyword='$phrase';

Explination of $sku_used

The purpose of the script I gave was to select everything from the table, but only show the most pertinant of each sku

the entries were ordered by sku,, and the pertinance, meaning that the first entry of each sku to show would be the most pertinant one.
Knowing this, I set the script to only display the entry of that sku had not been called yet... make sense? Look over my code again - it should

Manat

lazzerous

you could do this in one statament

SELECT
skutable.*, products.productID
FROM
skutable, products
WHERE
skutable.keyword='$phrase'
AND
skutable.sku = products.productID
ORDER BY
sku, pertinance DESC;

Manat

Excellent,

Thanks Lazzerous, I apreciate all ur help.

lazzerous

anytime - make sure to mark this thread resolved ;-)

Manat

Hi,

I know put this thread as resolved. Just got one quick question. If I wanted a next page button. How would I put that in the while loop?

Say after 10 search results, go to next page for remaining.

Thanks

lazzerous

what you're talking about is pagination...
There's a good tutorial here that should give plenty of insight

Also, make sure to search this forumn for pagination - a lot of users have had lengthy discussions on it within this board.

Take care,
-=Patrick=-

Manat

Hi,

Thanks, that article helped alot.
But how do I count how many results I got?
I mean it's easy to do it with something like:

$count = mysql_result($result, 0, 0);

But the problems is that I need to know the number of unique counts, in the while loop, but I want to display the number before the while loop.

Any Idea?

thx

lazzerous

to get a count of results, you would use mysql_num_rows()

$query = "select * from table";
$do_query = mysql_query($query);

$results_count = mysql_num_rows($do_query);

echo"Total Results: $results_count <br>\n";

Manat

Yes, I already tried that.

But I don't get the unique results, I get all of the results.

If you look at the while loop and the If statement IN the while loop, u will see that this is somewhat unique.

So that cannot be used, it will return everything.

Thx
MK

lazzerous

hmmm..

You could use the 'distinct' limiter in your sql query to kill the need for the 'if' statement in the while loop ('if' statements in loops slow things down as well)

let's say your table is this:

id | name
---|--------
1 | Joe
2 | Bob
3 | Joe

select name from table;
would return all three names

select distinct name from table would only return the first 2 entries, and the third is a duplicate

make sense?

Manat

But distinct is not for a Select *, it's for a Select fieldname.

I'm usring select *

So now what do I do?