Group + count search results

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Robbie1974
Forum Newbie
Posts: 8
Joined: Thu Jan 29, 2004 3:27 pm
Location: Blankenberge - Belgium

Group + count search results

Post by Robbie1974 »

I have about 22000 articles on my website.

If i use the search engine now, I get results from all section per page basis.
But this can be a long list.

Try entering 2210 on http://shop.kwarto.be/zoek.php

Is it possible to group and count the results by Category:

Hewlett Packard: 9 results found
Esselte: 3 results found
Konica Minolta: 10 results found
Ricoh: 2 results found

And when clicking the category it displays the final result.


This is my search code:

Code: Select all

<html>
<head>
<title>Zoekresultaten</title>
</head>

<body bgcolor="white">

<table border="1">
<tr><th>Code</th><th>Article</th><th>Category</th></tr>

<?php
$host="********";
$user="******";
$password="*******";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());
   
mysql_select_db("jshop", $conn)
   or die(mysql_error());
   
$search=$_POST["search"];



$sql = "SELECT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_productto.be/zoek.php[/url]

Is it possible to group and count the results by Category:

Hewlett Packard: 9 results found
Esselte: 3 results found
Konica Minolta: 10 results found
Ricoh: 2 results found

And when clicking the category it displays the final result.


This is my search code:

Code: Select all

<html>
<head>
<title>Zoekresultaten</title>
</head>

<body bgcolor="white">

<table border=&quote;1&quote;&gt;
&lt;tr&gt;&lt;th&gt;Code&lt;/th&gt;&lt;th&gt;Article&lt;/th&gt;&lt;th&gt;Category&lt;/th&gt;&lt;/tr&gt;

&lt;?php
$host=&quote;********&quote;;
$user=&quote;******&quote;;
$password=&quote;*******&quote;;

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());
   
mysql_select_db(&quote;jshop&quote;, $conn)
   or die(mysql_error());
   
$search=$_POST&#1111;&quote;search&quote;];



$sql = &quote;SELECT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%'&quote;;
$result = mysql_query($sql)
   or die(mysql_error());

while ($row = mysql_fetch_assoc($result)) {
   echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $row&#1111;'code'], &quote;&lt;/td&gt;&lt;td&gt;&quote;, $row&#1111;'name'], &quote;&lt;/td&gt;&lt;td&gt;&quote;, $row&#1111;'title'],
      &quote;&lt;/td&gt;&lt;/tr&gt;\n&quote;;
}
?&gt;

&lt;/table&gt;

&lt;/body&gt;

&lt;/html&gt;
Thanks for ideas

JCART | Please use

Code: Select all

tags when posting php code. Review [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/colororder="1">
<tr><th>Code&lt;/th&gt;&lt;th&gt;Article&lt;/th&gt;&lt;th&gt;Category&lt;/th&gt;&lt;/tr&gt;

&lt;?php
$host="********";
$user="******";
$password="*******";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());
   
mysql_select_db(&quote;jshop&quote;, $conn)
   or die(mysql_error());
   
$search=$_POST&#1111;&quote;search&quote;];



$sql = &quote;SELECT jss_products.productID, jss_products.description, jss_products.code, jss_produc search engine now, I get results from all section per page basis.
But this can be a long list.

Try entering 2210 on [url]http://shop.kwarto.be/zoek.php[/url]

Is it possible to group and count the results by Category:

Hewlett Packard: 9 results found
Esselte: 3 results found
Konica Minolta: 10 results found
Ricoh: 2 results found

And when clicking the category it displays the final result.


This is my search code:

Code: Select all

<html>
<head>
<title>Zoekresultaten&lt;/title&gt;
&lt;/head&gt;

&lt;body bgcolor=&quote;white&quote;&gt;

&lt;table border=&quote;1&quote;&gt;
&lt;tr&gt;&lt;th&gt;Code&lt;/th&gt;&lt;th&gt;Article&lt;/th&gt;&lt;th&gt;Category&lt;/th&gt;&lt;/tr&gt;

&lt;?php
$host=&quote;********&quote;;
$user=&quote;******&quote;;
$password=&quote;*******&quote;;

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());
   
mysql_select_db(&quote;jshop&quote;, $conn)
   or die(mysql_error());
   
$search=$_POST&#1111;&quote;search&quote;];



$sql = &quote;SELECT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%'&quote;;
$result = mysql_query($sql)
   or die(mysql_error());

while ($row = mysql_fetch_assoc($result)) {
   echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $row&#1111;'code'], &quote;&lt;/td&gt;&lt;td&gt;&quote;, $row&#1111;'name'], &quote;&lt;/td&gt;&lt;td&gt;&quote;, $row&#1111;'title'],
st.

Try entering 2210 on [url]http://shop.kwarto.be/zoek.php[/url]

Is it possible to group and count the results by Category:

Hewlett Packard: 9 results found
Esselte: 3 results found
Konica Minolta: 10 results found
Ricoh: 2 results found

And when clicking the category it displays the final result.


This is my search code:

Code: Select all

<html>
<head>
<title>Zoekresultaten</title>
</head>

<body bgcolor="white">

<table border="1">
<tr><th>Code</th><th>Article</th><th>Category</th></tr>

<?php
$host="********";
$user="******";
$password="*******";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());
   
mysql_select_db("jshop", $conn)
   or die(mysql_error());
   
$search=$_POST["search"];



$sql = "SELECT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%'";
$result = mysql_query($sql)
   or die(mysql_error());

while ($row = mysql_fetch_assoc($result)) {
   echo "<tr><td>", $row['code'], "</td><td>", $row['name'], "</td><td>", $row['title'],
      "</td></tr>\n";
}
?>

</table>

</body>

</html>
Thanks for ideas

JCART | Pleasehe search engine now, I get results from all section per page basis.
But this can be a long list.

Try entering 2210 on http://shop.kwarto.be/zoek.php

Is it possible to group and count the results by Category:

Hewlett Packard: 9 results found
Esselte: 3 results found
Konica Minolta: 10 results found
Ricoh: 2 results found

And when clicking the category it displays the final result.


This is my search code:

Code: Select all

<html>
<head>
<title>Zoekresultaten</title>
</head>

<body bgcolor="white">

<table border="1">
<tr><th>Code</th><th>Article</th><th>Category</th></tr>

<?php
$host="********";
$user="******";
$password="*******";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());
   
mysql_select_db("jshop", $conn)
   or die(mysql_error());
   
$search=$_POST["search"];



$sql = "SELECT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID wh>
<head>
<title>Zoekresultaten</title>
</head>

<body bgcolor="white">

<table border="1">
<tr><th>Code</th><th>Article</th><th>Category</th></tr>

<?php
$host="********";
$user="******";
$password="*******";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());
   
mysql_select_db("jshop", $conn)
   or die(mysql_error());
   
$search=$_POST["search"];



$sql = "SELECT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_produ
<html>
<head>
<title>Zoekresultaten</title>
</head>

<body bgcolor="white">

<table border="1">
<tr><th>Code</th><th>Article</th><th>Category</th></tr>

<?php
$host="********";
$user="******";
$password="*******";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());
   
mysql_select_db("jshop", $conn)
   or die(mysql_error());
   
$search=$_POST["search"];



$sql = "SELECT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%'";
$result = mysql_query($sql)
   or die(mysql_error());

while ($row = mysql_fetch_assoc($result)) {
   echo "<tr><td>", $row['code'], "</td><td>", $row['name'], "</td><td>", $row['title'],
      "</td></tr>\n";
}
?>

</table>

</body>

</html>
Thanks for ideas

JCART | Please use

Code: Select all

tags when posting php code. Review [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]
Robbie1974
Forum Newbie
Posts: 8
Joined: Thu Jan 29, 2004 3:27 pm
Location: Blankenberge - Belgium

Post by Robbie1974 »

this is almost what i want but I can't get the number of search results in there:

Code: Select all

<html>
<head>
<title>Zoekresultaten</title>
</head>

<body bgcolor="white">

<table border="1">
<tr><th>Code</th><th>n° of results</th></tr>

<?php
$host="****";
$user="****";
$password="****";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());
   
mysql_select_db("jshop", $conn)
   or die(mysql_error());
   
$search=$_POST["search"];



$sql = "SELECT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' group by jss_sections.title";
$result = mysql_query($sql)
   or die(mysql_error());

while ($row = mysql_fetch_assoc($result)) {
   echo "<tr><td>", $row['title'], "</td></tr>\n";
}
?>

</table>

</body>

</html>
JCART | Please use

Code: Select all

tags when posting php code. Review [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

Robbie1974
Forum Newbie
Posts: 8
Joined: Thu Jan 29, 2004 3:27 pm
Location: Blankenberge - Belgium

Post by Robbie1974 »

I can't get this thing to work. I'm just a beginner in php.

This is what I want to accomplish:

http://www.vikingdirect.be/(kg1vbxbm1mx ... ivision=00

This is the code I have so far:

Code: Select all

<?php
$host="****";
$user="****";
$password="****";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());

$search=$_POST["search"];



$sql = "SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' ";
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo "<tr><td>", $row['title'], "</td><td>", $num_rows , "</td></tr>\n";
}
?><?php
$host="localhost";
$user="root";
$password="";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());

$search=$_POST["search"];



$sql = "SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' ";
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo "<tr><td>", $row['title'], "</td><td>", $num_rows , "</td></tr>\n";
}
?>
Giving me this for result:

Code: Select all

Code n° of results 
Hewlett-Packard 24 
Hewlett-Packard 24 
Esselte 24 
Esselte 24 
Esselte 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Ricoh 24 
Ricoh 24
Really stuck here. Any help please?p;quote;;
$password="****&quote;;

$conn = mysql_connect($host,$user,$password)
or die(mysql_error());

mysql_select_db(&quote;jshop&quote;, $conn)
or die(mysql_error());

$search=$_POSTї&quote;search&quote;];



$sql = &quote;SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' &quote;;
$result = mysql_query($sql)
or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $rowї'title'], &quote;&lt;/td&gt;&lt;td&gt;&quote;, $num_rows , &quote;&lt;/td&gt;&lt;/tr&gt;\n&quote;;
}
?&gt;&lt;?php
$host=&quote;localhost&quote;;
$user=&quote;root&quote;;
$password=&quote;&quote;;

$conn = mysql_connect($host,$user,$password)
or die(mysql_error());

mysql_select_db(&quote;jshop&quote;, $conn)
or die(mysql_error());

$search=$_POSTї&quote;search&quote;];



$sql = &quote;SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' &quote;;
$result = mysql_query($sql)
or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
echo &quote;<tr>&lt;td&gt;&quote;, $rowї'title'], &quote;&lt;/td&gt;&lt;td&gt;&quote;, $num_rows , &quote;&lt;/td&gt;&lt;/tr&gt;\n&quote;;
}
?&gt;

Giving me this for result:

Code: Select all

Code n° of results 
Hewlett-Packard 24 
Hewlett-Packard 24 
Esselte 24 
Esselte 24 
Esselte 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Ricoh 24 
Ricoh 24
Really stuck here. Any help please?'title'], "</td><td>", $num_rows , "</td></tr>\n";
}
?><?php
$host="localhost";
$user="root";
$password="";

$conn = mysql_connect($host,$user,$password)
or die(mysql_error());

mysql_select_db(&quote;jshop&quote;, $conn)
or die(mysql_error());

$search=$_POSTї&quote;search&quote;];



$sql = &quote;SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' ";
$result = mysql_query($sql)
or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
echo "<tr&gt;&lt;td&gt;&quote;, $rowї'title'], &quote;&lt;/td&gt;&lt;td&gt;&quote;, $num_rows , &quote;&lt;/td&gt;&lt;/tr>\n";
}
?>

Giving me this for result:

Code: Select all

Code n° of results 
Hewlett-Packard 24 
Hewlett-Packard 24 
Esselte 24 
Esselte 24 
Esselte 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Ricoh 24 
Ricoh 24
Really stuck here. Any help please?ierarchyResults.aspx?searchString=ordner&searchSelectedDivision=00[/url]

This is the code I have so far:

Code: Select all

<?php
$host="****";
$user="****";
$password="****";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());

$search=$_POST["search"];



$sql = "SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' ";
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo "<tr><td>", $row['title'], "</td><td>", $num_rows , "</td></tr>\n";
}
?><?php
$host="localhost";
$user="root";
$password="";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());

$search=$_POST["search"];



$sql = "SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' ";
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo "<tr><td>", $row['title'], "</td><td>", $num_rows , "</td></tr>\n";
}
?>
Giving me this for result:

Code: Select all

Code n° of results 
Hewlett-Packard 24 
Hewlett-Packard 24 
Esselte 24 
Esselte 24 
Esselte 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Ricoh 24 
Ricoh 24
Rep;quote;;
$user="****";
$password="****";

$conn = mysql_connect($host,$user,$password)
or die(mysql_error());

mysql_select_db("jshop", $conn)
or die(mysql_error());

$search=$_POST["search"];



$sql = "SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' &quote;;
$result = mysql_query($sql)
or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $rowї'title'], &quote;&lt;/td&gt;&lt;td&gt;&quote;, $num_rows , &quote;&lt;/td&gt;&lt;/tr&gt;\n&quote;;
}
?&gt;&lt;?php
$host=&quote;localhost&quote;;
$user=&quote;root&quote;;
$password=&quote;&quote;;

$conn = mysql_connect($host,$user,$password)
or die(mysql_error());

mysql_select_db(&quote;jshop&quote;, $conn)
or die(mysql_error());

$search=$_POSTї&quote;search&quote;];



$sql = &quote;SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' &quote;;
$result = mysql_query($sql)
or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $rowї'title'], &quote;&lt;/td&gt;&lt;td&gt;&quote;, $num_rows , &quote;&lt;/td&gt;&lt;/tr&gt;\n&quote;;
}
?&gt;

Giving me this for result:

Code: Select all

Code n° of results 
Hewlett-Packard 24 
Hewlett-Packard 24 
Esselte 24 
Esselte 24 
Esselte 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
H_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());

$search=$_POST["search"];



$sql = "SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' &quote;;
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $row&#1111;'title'], &quote;&lt;/td&gt;&lt;td&gt;&quote;, $num_rows , &quote;&lt;/td&gt;&lt;/tr&gt;\n&quote;;
}
?&gt;&lt;?php
$host=&quote;localhost&quote;;
$user=&quote;root&quote;;
$password=&quote;&quote;;

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db(&quote;jshop&quote;, $conn)
   or die(mysql_error());

$search=$_POST&#1111;&quote;search&quote;];



$sql = &quote;SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' &quote;;
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo &quote;&lt;tr&gt;&lt; accomplish:

[url]http://www.vikingdirect.be/(kg1vbxbm1mx3i255yqf30k45)/searchHierarchyResults.aspx?searchString=ordner&searchSelectedDivision=00[/url]

This is the code I have so far:

[php]<?php
$host="****";
$user="****";
$password="****";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());

$search=$_POST["search"];



$sql = "SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' ";
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo "<tr><td>", $row['title'], "</td><td>", $num_rows , "</td></tr>\n";
}
?><?php
$host="localhost";
$user="root";
$password="";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());

$search=$_POST["search"];



$sql = "SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' ";
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo "<tr><td>", $row['title'], "</td><td>", $num_rows , "</td></tr>\n";
}
?>[/php]

Giving me this for result:

[code]Code n° of results 
Hewlett-Packard 24 
Hewlett-Packard 24 
Esselte 24 
Esselte 24 
Esselte 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard hing to work. I'm just a beginner in php.

This is what I want to accomplish:

[url]http://www.vikingdirect.be/(kg1vbxbm1mx3i255yqf30k45)/searchHierarchyResults.aspx?searchString=ordner&searchSelectedDivision=00[/url]

This is the code I have so far:

[php]<?php
$host="****";
$user="****";
$password="****";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());

$search=$_POST["search"];



$sql = "SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' ";
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $row&#1111;'title'], &quote;&lt;/td&gt;&lt;td&gt;&quote;, $num_rows , &quote;&lt;/td&gt;&lt;/tr&gt;\n&quote;;
}
?&gt;&lt;?php
$host=&quote;localhost&quote;;
$user=&quote;root&quote;;
$password=&quote;&quote;;

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db(&quote;jshop&quote;, $conn)
   or die(mysql_error());

$search=$_POST&#1111;&quote;search&quote;];



$sql = &quote;SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' &quom1mx3i255yqf30k45)/searchHierarchyResults.aspx?searchString=ordner&searchSelectedDivision=00[/url]

This is the code I have so far:

[php]<?php
$host="****";
$user="****";
$password="****";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db(&quote;jshop&quote;, $conn)
   or die(mysql_error());

$search=$_POST&#1111;&quote;search&quote;];



$sql = &quote;SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' &quote;;
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $row&#1111;'title'], &quote;&lt;/td&gt;&lt;td&gt;&quote;, $num_rows , &quote;&lt;/td&gt;&lt;/tr&gt;\n&quote;;
}
?&gt;&lt;?php
$host=&quote;localhost&quote;;
$user=&quote;root&quote;;
$password=&quote;&quote;;

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db(&quote;jshop&quote;, $conn)
   or die(mysql_error());

$search=$_POST&#1111;&quote;search&quote;];



$sql = &quote;SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' &quote;;
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $row&#1111;'title'], &quote;&lt;/td&gt;&lt;td&gt;&quote;, $num_rows , &quote;&lt;/td&gt;&lt;/tr&gt;\n&quote;;
}
?&gt;[/php]

Giving me this for result:

[code]Code n° of results 
Hewlett-Packard 24 
Hewlett-Packard 24 
Esselte 24 
Esselte 24 
Esselte 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 2Division=00[/url]

This is the code I have so far:

[php]<?php
$host="****";
$user="****";
$password="****";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());

$search=$_POST["search"];



$sql = "SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' ";
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo "<tr><td>", $row['title'], "</td><td>", $num_rows , "</td></tr>\n";
}
?><?php
$host="localhost";
$user="root";
$password="";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());

$search=$_POST["search"];



$sql = "SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' ";
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo "<tr><td>", $row['title'], "</td><td>", $num_rows , "</td></tr>\n";
}
?>[/php]

Giving me this for result:

[code]Code n° of results 
Hewlett-Packard 24 
Hewlett-Packard 24 
Esselte 24 
Esselte 24 
Esselte 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
kg1vbxbm1mx3i255yqf30k45)/searchHierarchyResults.aspx?searchString=ordner&searchSelectedDivision=00[/url]

This is the code I have so far:

[php]&lt;?php
$host=&quote;****&quote;;
$user=&quote;****&quote;;
$password=&quote;****&quote;;

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());

$search=$_POST["search"];



$sql = "SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' &quote;;
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $row&#1111;'title'], &quote;&lt;/td&gt;&lt;td&gt;&quote;, $num_rows , &quote;&lt;/td&gt;&lt;/tr&gt;\n&quote;;
}
?&gt;&lt;?php
$host=&quote;localhost&quote;;
$user=&quote;root&quote;;
$password=&quote;&quote;;

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db(&quote;jshop&quote;, $conn)
   or die(mysql_error());

$search=$_POST&#1111;&quote;search&quote;];



$sql = &quote;SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' &quote;;
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $row&#1111;'title'], &quote;&lt;/td&gt;&lt;td&gt;&quote;, $num_rows , &ampxbm1mx3i255yqf30k45)/searchHierarchyResults.aspx?searchString=ordner&searchSelectedDivision=00[/url]

This is the code I have so far:

[php]<?php
$host="****";
$user="****";
$password="****";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());

$search=$_POST&#1111;&quote;search&quote;];



$sql = &quote;SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' &quote;;
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $row&#1111;'title'], &quote;&lt;/td&gt;&lt;td&gt;&quote;, $num_rows , &quote;&lt;/td&gt;&lt;/tr&gt;\n&quote;;
}
?&gt;&lt;?php
$host=&quote;localhost&quote;;
$user=&quote;root&quote;;
$password=&quote;&quote;;

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db(&quote;jshop&quote;, $conn)
   or die(mysql_error());

$search=$_POST&#1111;&quote;search&quote;];



$sql = &quote;SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' &quote;;
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $row&#1111;'title'], &quote;&lt;/td&gt;&lt;td&gt;&quote;, $num_rows , &quote;&lt;/td&gt;&lt;/tr&gt;\n&quote;;
}
?&gt;[/php]

Giving me this for result:

[code]Code n° of results 
Hewlett-Packard 24 
Hewlett-Packard 24 
Esselte 24 
Esselte 24 
Esselte 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 2onn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());

$search=$_POST["search"];



$sql = "SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' ";
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo "<tr><td>", $row['title'], "</td><td>", $num_rows , "</td></tr>\n";
}
?><?php
$host="localhost";
$user="root";
$password="";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());

$search=$_POST["search"];



$sql = "SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' ";
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo "<tr><td>", $row['title'], "</td><td>", $num_rows , "</td></tr>\n";
}
?>[/php]

Giving me this for result:

[code]Code n° of results 
Hewlett-Packard 24 
Hewlett-Packard 24 
Esselte 24 
Esselte 24 
Esselte 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Ricoh 24 
Ricoh 24
Really stuck here. Any help please? or die(mysql_error());

$search=$_POST["search"];



$sql = "SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' &quote;;
$result = mysql_query($sql)
or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
echo "<tr><td>", $row['title'], "</td><td>", $num_rows , "</td></tr>\n";
}
?><?php
$host="localhost";
$user="root";
$password="";

$conn = mysql_connect($host,$user,$password)
or die(mysql_error());

mysql_select_db(&quote;jshop&quote;, $conn/www.vikingdirect.be/(kg1vbxbm1mx3i255yq ... ivision=00[/url]

This is the code I have so far:

Code: Select all

<?php
$host="****";
$user="****";
$password="****";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());

$search=$_POST&#1111;&quote;search&quote;];



$sql = "SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' &quote;;
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $row&#1111;'title'], &quote;&lt;/td&gt;&lt;td&gt;&quote;, $num_rows , &quote;&lt;/td&gt;&lt;/tr&gt;\n&quote;;
}
?&gt;&lt;?php
$host=&quote;localhost&quote;;
$user=&quote;root&quote;;
$password=&quote;&quote;;

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db(&quote;jshop&quote;, $conn)
   or die(mysql_error());

$search=$_POST&#1111;&quote;search&quote;];



$sql = &quote;SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' &quote;;
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $row&#1111;'title'
This is what I want to accomplish:

[url]http://www.vikingdirect.be/(kg1vbxbm1mx3i255yqf30k45)/searchHierarchyResults.aspx?searchString=ordner&searchSelectedDivision=00[/url]

This is the code I have so far:

Code: Select all

<?php
$host="****";
$user="****";
$password="****";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());

$search=$_POST["search"];



$sql = "SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' &quote;;
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $row&#1111;'title'], &quote;&lt;/td&gt;&lt;td&gt;&quote;, $num_rows , &quote;&lt;/td&gt;&lt;/tr&gt;\n&quote;;
}
?&gt;&lt;?php
$host=&quote;localhost&quote;;
$user=&quote;root&quote;;
$password=&quote;&quote;;

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db(&quote;jshop&quote;, $conn)
   or die(mysql_error());

$search=$_POST&#1111;&quote;search&quote;];



$sql = &quote;SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' &quote;;
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $row&#1111;'tiults.aspx?searchString=ordner&searchSelectedDivision=00[/url]

This is the code I have so far:

Code: Select all

<?php
$host="****";
$user="****";
$password="****";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());

$search=$_POST["search"];



$sql = "SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' ";
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo "<tr><td>", $row['title'], "</td><td>", $num_rows , "</td></tr>\n";
}
?><?php
$host="localhost";
$user="root";
$password="";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());

$search=$_POST["search"];



$sql = "SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' ";
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo "<tr><td>", $row['title'], "</td><td>", $num_rows , "</td></tr>\n";
}
?>
Giving me this for result:

Code: Select all

Code n° of results 
Hewlett-Packard 24 
Hewlett-Packard 24 
Esselte 24 
Esselte 24 
Esselte 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Ricoh 24 
Ricoh 24 
[/code9444481bf]<?php
$host="****";
$user=&quote;****&quote;;
$password=&quote;****";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());

$search=$_POST["search"];



$sql = "SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' &quote;;
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $row&#1111;'title'], &quote;&lt;/td&gt;&lt;td&gt;&quote;, $num_rows , &quote;&lt;/td&gt;&lt;/tr&gt;\n&quote;;
}
?&gt;&lt;?php
$host=&quote;localhost&quote;;
$user=&quote;root&quote;;
$password=&quote;&quote;;

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db(&quote;jshop&quote;, $conn)
   or die(mysql_error());

$search=$_POST&#1111;&quote;search&quote;];



$sql = &quote;SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' &quote;;
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $row&#1111;'title'], &quote;&lt;/td&gt;&lt;td&gt;&quote;, $num_rows , &quote;&lt;/td&gt;&lt;/tr&gt;\n&quote;;
}
?&gt;
Giving me this for result:

Code: Select all

Code n° of results 
Hewlett-Packard 24 
Hewlett-Packard 24 
Esselte 24 
Esselte 24 
Esselte 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica , jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' &quote;;
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $row&#1111;'title'], &quote;&lt;/td&gt;&lt;td&gt;&quote;, $num_rows , &quote;&lt;/td&gt;&lt;/tr&gt;\n&quote;;
}
?&gt;&lt;?php
$host=&quote;localhost&quote;;
$user=&quote;root&quote;;
$password=&quote;&quote;;

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db(&quote;jshop&quote;, $conn)
   or die(mysql_error());

$search=$_POST&#1111;&quote;search&quote;];



$sql = &quote;SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' &quote;;
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $row&#1111;'title'], &quote;&lt;/td&gt;&lt;td&gt;&quote;, $num_rows , &quote;&lt;/td&gt;&lt;/tr&gt;\n&quote;;
}
?&gt;
Giving me this for result:

[code**";
$user="****";
$password="****";

$conn = mysql_connect($host,$user,$password)
or die(mysql_error());

mysql_select_db(&quote;jshop&quote;, $conn)
or die(mysql_error());

$search=$_POSTї&quote;search&quote;];



$sql = &quote;SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' &quote;;
$result = mysql_query($sql)
or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $rowї'title'], &quote;&lt;/td&gt;&lt;td&gt;&quote;, $num_rows , &quote;&lt;/td&gt;&lt;/tr&gt;\n&quote;;
}
?&gt;&lt;?php
$host=&quote;localhost&quote;;
$user=&quote;root&quote;;
$password=&quote;&quote;;

$conn = mysql_connect($host,$user,$password)
or die(mysql_error());

mysql_select_db(&quote;jshop&quote;, $conn)
or die(mysql_error());

$search=$_POSTї&quote;search&quote;];



$sql = &quote;SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' &quote;;
$result = mysql_query($sql)
or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $rowї'title'], &quote;&lt;/td&gt;&lt;td&gt;&quote;, $num_rows , &quote;&lt;/td&gt;&lt;/tr&gt;\n&quote;;
}
?&gt;

Giving me this for result:

Code: Select all

Code n° of results 
Hewlett-Packard 24 
Hewlett-Packard 24 
Esselte 24 
Essp.

This is what I want to accomplish:

[url]http://www.vikingdirect.be/(kg1vbxbm1mx3i255yqf30k45)/searchHierarchyResults.aspx?searchString=ordner&searchSelectedDivision=00[/url]

This is the code I have so far:

Code: Select all

<?php
$host="****";
$user="****";
$password="****";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());

$search=$_POST["search"];



$sql = "SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' ";
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo "<tr><td>", $row['title'], "</td><td>", $num_rows , "</td></tr>\n";
}
?><?php
$host="localhost";
$user="root";
$password="";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());

$search=$_POST["search"];



$sql = "SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' ";
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo "<tr><td>", $row['title'], "</td><td>", $num_rows , "</td></tr>\n";
}
?>
Giving me this for result:

Code: Select all

Code n° of results 
Hewlett-Packard 24 
Hewlett-Packard 24 
Esselte 24 
Esselte 24 
Esselte 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Ms the code I have so far:

Code: Select all

<?php
$host="****";
$user="****";
$password="****";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());

$search=$_POST["search"];



$sql = "SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' ";
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo "<tr><td>", $row['title'], "</td><td>", $num_rows , "</td></tr>\n";
}
?><?php
$host="localhost";
$user="root";
$password="";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());

$search=$_POST["search"];



$sql = "SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' ";
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo "<tr><td>", $row['title'], "</td><td>", $num_rows , "</td></tr>\n";
}
?>
Giving me this for result:

Code: Select all

Code n° of results 
Hewlett-Packard 24 
Hewlett-Packard 24 
Esselte 24 
Esselte 24 
Esselte 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Konica Minolta 24 
Konica Minolta 24 
ision=00[/url]

This is the code I have so far:

Code: Select all

<?php
$host="****";
$user="****";
$password="****";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());

$search=$_POST["search"];



$sql = "SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' ";
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo "<tr><td>", $row['title'], "</td><td>", $num_rows , "</td></tr>\n";
}
?><?php
$host="localhost";
$user="root";
$password="";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());

$search=$_POST["search"];



$sql = "SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' ";
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo "<tr><td>", $row['title'], "</td><td>", $num_rows , "</td></tr>\n";
}
?>
Giving me this for result:

Code: Select all

Code n° of results 
Hewlett-Packard 24 
Hewlett-Packard 24 
Esselte 24 
Esselte 24 
Esselte 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konic jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' ";
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo "<tr>&lt;td&gt;&quote;, $row&#1111;'title'], &quote;&lt;/td&gt;&lt;td&gt;&quote;, $num_rows , &quote;&lt;/td&gt;&lt;/tr&gt;\n&quote;;
}
?&gt;&lt;?php
$host=&quote;localhost&quote;;
$user=&quote;root&quote;;
$password=&quote;&quote;;

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db(&quote;jshop&quote;, $conn)
   or die(mysql_error());

$search=$_POST&#1111;&quote;search&quote;];



$sql = &quote;SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' &quote;;
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $row&#1111;'title'], &quote;&lt;/td&gt;&lt;td&gt;&quote;, $num_rows , &quote;&amh=$_POST["search"];



$sql = "SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' ";
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo "<tr><td>", $row['title'], "</td><td>", $num_rows , "</td></tr>\n";
}
?><?php
$host="localhost";
$user="root";
$password="";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());

$search=$_POST["search"];



$sql = "SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jHierarchyResults.aspx?searchString=ordner&searchSelectedDivision=00[/url]

This is the code I have so far:

Code: Select all

<?php
$host="****";
$user="****";
$password="****";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());

$search=$_POST["search"];



$sql = "SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' ";
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo "<tr><td>", $row['title'], "</td><td>", $num_rows , "</td></tr>\n";
}
?><?php
$host="localhost";
$user="root";
$password="";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());

$search=$_POST["search"];



$sql = "SELECT DISTINCT jss_products.productID, jss_products.description, jss_products.code, jss_products.name, jss_products_tree.sectionID, jss_sections.title, jss_sections.parent
FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID where jss_products.description like '%$search%' ";
$result = mysql_query($sql)
   or die(mysql_error());

$num_rows = mysql_num_rows($result);


while ($row = mysql_fetch_assoc($result)) {
   echo "<tr><td>", $row['title'], "</td><td>", $num_rows , "</td></tr>\n";
}
?>
Giving me this for result:

Code: Select all

Code n° of results 
Hewlett-Packard 24 
Hewlett-Packard 24 
Esselte 24 
Esselte 24 
Esselte 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Hewlett-Packard 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
Konica Minolta 24 
just a beginner in php.

This is what I want to accomplish:

[url]http://www.vikingdirect.be/(kg1vbxbm1mx3i255yqf30k45)/searchHierarchyResults.aspx?searchString=ordner&searchSelectedDivision=00[/url]

This is the code I have so far:

Code: Select all

<?php
$host="****
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

Afaik you have nowhere a SELECT COUNT(*) or GROUP BY clause in your query...
Robbie1974
Forum Newbie
Posts: 8
Joined: Thu Jan 29, 2004 3:27 pm
Location: Blankenberge - Belgium

Post by Robbie1974 »

Thanks for the help timvw.

Greetz from Blankenberge !!!!

Code: Select all

<?php
$host="****";
$user="****";
$password="****";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());


$keywords = $_POST["search"];

$association = 'AND';
$keywords = explode(" ",$keywords);
$query = array();
foreach($keywords as $keyword)
{
$query[] = "(`name` LIKE '%".$keyword."%'OR `description` LIKE '%".$keyword."%' OR `keywords` LIKE '%".$keyword."%' OR `code` LIKE '%".$keyword."%')";

           }

$query = implode("\n ".$association." ",$query);

$sql = "SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title  FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE ".$query." GROUP BY jss_sections.title";

$res = mysql_query($sql);

if (!$res) {

    /**     * This lines print the SQL statement in a viewable form.     */

   print '<pre>';
   print $sql;
   print '</pre>';

   /**     * E_USER_ERROR will stop the script.     * E_USER_NOTICE und E_USER_WARNING won't stop the script.     */    trigger_error('Database query failed: '.mysql_error(), E_USER_ERROR);
   } else {
   /**     * Add here the routines to print the results.     */}
  echo "Er werd gezocht op ", $keyword ;

  while ($row = mysql_fetch_assoc($res)) {
   echo "<tr><td>", $row['title'], "</td><td>", $row['TOTALFOUND'],
      "</td></tr>\n";
}

?>
s = $_POST["search"];

$association = 'AND';
$keywords = explode(&quote; &quote;,$keywords);
$query = array();
foreach($keywords as $keyword)
{
$queryї] = &quote;(`name` LIKE '%&quote;.$keyword.&quote;%'OR `description` LIKE '%&quote;.$keyword.&quote;%' OR `keywords` LIKE '%&quote;.$keyword.&quote;%' OR `code` LIKE '%&quote;.$keyword.&quote;%')&quote;;

}

$query = implode(&quote;\n &quote;.$association.&quote; &quote;,$query);

$sql = &quote;SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE &quote;.$query.&quote; GROUP BY jss_sections.title&quote;;

$res = mysql_query($sql);

if (!$res) {

/** * This lines print the SQL statement in a viewable form. */

print '&lt;pre&gt;';
print $sql;
print '&lt;/pre&gt;';

/** * E_USER_ERROR will stop the script. * E_USER_NOTICE und E_USER_WARNING won't stop the script. */ trigger_error('Database query failed: '.mysql_error(), E_USER_ERROR);
} else {
/** * Add here the routines to print the results. */}
echo &quote;Er werd gezocht op &quote;, $keyword ;

while ($row = mysql_fetch_assoc($res)) {
echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $row['title'], "</td&gt;&lt;td&gt;&quote;, $rowї'TOTALFOUND'],
&quote;&lt;/td&gt;&lt;/tr&gt;\n&quote;;
}

?&gt;tions.title";

$res = mysql_query($sql);

if (!$res) {

/** * This lines print the SQL statement in a viewable form. */

print '<pre>';
print $sql;
print '</pre>';

/** * E_USER_ERROR will stop the script. * E_USER_NOTICE und E_USER_WARNING won't stop the script. */ trigger_error('Database query failed: '.mysql_error(), E_USER_ERROR);
} else {
/** * Add here the routines to print the results. */}
echo &quote;Er werd gezocht op &quote;, $keyword ;

while ($row = mysql_fetch_assoc($res)) {
echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $rowї'title'], &quote;&lt;/td><td>", $row['TOTALFOUND'],
"</td></tr>\n";
}

?>te;;
$password="****";

$conn = mysql_connect($host,$user,$password)
or die(mysql_error());

mysql_select_db("jshop", $conn)
or die(mysql_error());


$keywords = $_POSTї&quote;search&quote;];

$association = 'AND';
$keywords = explode(&quote; &quote;,$keywords);
$query = array();
foreach($keywords as $keyword)
{
$queryї] = &quote;(`name` LIKE '%&quote;.$keyword.&quote;%'OR `description` LIKE '%&quote;.$keyword.&quote;%' OR `keywords` LIKE '%&quote;.$keyword.&quote;%' OR `code` LIKE '%&quote;.$keyword.&quote;%')&quote;;

}

$query = implode(&quote;\n &quote;.$association.&quote; &quote;,$query);

$sql = &quote;SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE &quote;.$query.&quote; GROUP BY jss_sections.title&quote;;

$res = mysql_query($sql);

if (!$res) {

/** * This lines print the SQL statement in a viewable form. */

print '&lt;pre&gt;';
print $sql;
print '&lt;/pre&gt;';

/** * E_USER_ERROR will stop the script. * E_USER_NOTICE und E_USER_WARNING won't stop the script. */ trigger_error('Database query failed: '.mysql_error(), E_USER_ERROR);
} else {
/** * Add here the routines to print the results. */}
echo &quote;Er werd gezocht op &quote;, $keyword ;

while ($row = mysql_fetch_assoc($res)) {
echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $rowї'title'], &quote;&lt;/td&gt;&lt;td&gt;&quote;, $rowї'TOTALFOUND'],
&quote;&lt;/td&gt;&lt;/tr&gt;\n&quote;;
}

r die(mysql_error());


$keywords = $_POST["search"];

$association = 'AND';
$keywords = explode(" ",$keywords);
$query = array();
foreach($keywords as $keyword)
{
$query[] = "(`name` LIKE '%".$keyword."%'OR `description` LIKE '%".$keyword."%' OR `keywords` LIKE '%".$keyword."%' OR `code` LIKE '%".$keyword.&quote;%')&quote;;

}

$query = implode(&quote;\n &quote;.$association.&quote; &quote;,$query);

$sql = &quote;SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE &quote;.$query.&quote; GROUP BY jss_sections.title&quote;;

$res = mysql_query($sql);

if (!$res) {

/** * This lines print the SQL statement in a viewable form. */

print '&lt;pre&gt;';
print $sql;
print '&lt;/pre&gt;';

/** * E_USER_ERROR will stop the script. * E_USER_NOTICE und E_USER_WARNING won't stop the script. */ trigger_error('Database query failed: '.mysql_error(), E_USER_ERROR);
} else {
/** * Add here the routines to print the results. */}
echo &quote;Er werd gezocht op &quote;, $keyword ;

while ($row = mysql_fetch_assoc( 'AND';
$keywords = explode(" ",$keywords);
$query = array();
foreach($keywords as $keyword)
{
$query[] = "(`name` LIKE '%".$keyword."%'OR `description` LIKE '%".$keyword."%' OR `keywords` LIKE '%".$keyword."%' OR `code` LIKE '%".$keyword."%')";

}

$query = implode("\n ".$association." ",$query);

$sql = &quote;SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE &quote;.$query.&quote; GROUP BY jss_sections.title&quote;;

$res = mysql_query($sql);

if (!$res) {

/** * This lines print the SQL statement in a v<?php
$host="****";
$user="****";
$password=&quote;****&quote;;

$conn = mysql_connect($host,$user,$password)
or die(mysql_error());

mysql_select_db("jshop&quote;, $conn)
or die(mysql_error());


$keywords = $_POSTї&quote;search&quote;];

$association = 'AND';
$keywords = explode(&quote; &quote;,$keywords);
$query = array();
foreach($keywords as $keyword)
{
$queryї] = &quote;(`name` LIKE '%&quote;.$keyword.&quote;%'OR `description` LIKE '%&quote;.$keyword.&quote;%' OR `keywords` LIKE '%&quote;.$keyword.&quote;%' OR `code` LIKE '%&quote;.$keyword.&quote;%')&quote;;

}

$query = implode(&quote;\n &quote;.$association.&quote; &quote;,$query);

$sql = &quote;SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE &quote;.$query.&quote; GROUP BY jss_sections.title&quote;;

$res = mysql_query($sql);

if (!$res) {

/** * This lines print the SQL statement in a viewable form. */

print '&lt;pre&gt;';
print $sql;
print '&lt;/pre&gt;';

/** * E_USER_ERROR will stop the script. * E_USER_NOTICE und E_USER_WARNING won't stop the script. */ trigger_error('Database query failed: '.mysql_error(), E_USER_ERROR);
} else {
/** * Add here the routines to print the results. */}
echo &quote;Er werd gezocht op &quote;, $keyword ;

while ($row = mysql_fetch_assoc($res)) {
echo &quote;&amp timvw.

Greetz from Blankenberge !!!!

Code: Select all

<?php
$host="****";
$user="****";
$password="****";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());


$keywords = $_POST["search"];

$association = 'AND';
$keywords = explode(" ",$keywords);
$query = array();
foreach($keywords as $keyword)
{
$query[] = "(`name` LIKE '%".$keyword."%'OR `description` LIKE '%".$keyword."%' OR `keywords` LIKE '%".$keyword."%' OR `code` LIKE '%".$keyword."%')";

           }

$query = implode("\n ".$association." ",$query);

$sql = "SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title  FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectioner="****";
$password="****";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());


$keywords = $_POST["search"];

$association = 'AND';
$keywords = explode(" ",$keywords);
$query = array();
foreach($keywords as $keyword)
{
$query[] = "(`name` LIKE '%".$keyword."%'OR `description` LIKE '%".$keyword."%' OR `keywords` LIKE '%".$keyword."%' OR `code` LIKE '%".$keyword."%')";

           }

$query = implode("\n ".$association." ",$query);

$sql = "SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title  FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE ".$query." GROUP BY jss_sections.title";

$res = mysql_query($sql);

if (!$res) {

    /**     * This lines print the SQL statement in a viewable form.     */

   print '<pre>';
   print $sql;
   print '</pre>';

   /**     * E_USER_ERROR will stop the script.     * E_USER_NOTICE und E_USER_WARNING won't stop the script.     */    trigger_error('Database query failed: '.mysql_error(), E_USER_ERROR);
   } else {
   /**     * Add here the routines to print the results.     */}
  echo "Er werd gezocht op ", $keyword ;

  while ($row = mysql_fetch_assoc($res)) {
   echo "<tr>&amnnect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());


$keywords = $_POST["search"];

$association = 'AND';
$keywords = explode(" ",$keywords);
$query = array();
foreach($keywords as $keyword)
{
$query[] = "(`name` LIKE '%".$keyword."%'OR `description` LIKE '%".$keyword."%' OR `keywords` LIKE '%".$keyword."%' OR `code` LIKE '%".$keyword."%')";

           }

$query = implode("\n ".$association." ",$query);

$sql = "SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title  FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE ".$query." GROUP BY jss_sections.title";

$res = mysql_query($sql);

if (!$res) {

    /**     * This lines print the SQL statement in a viewable form.     */

   print '<pre>';
   print $sql;
   print '</pre>';

   /**     * E_USER_ERROR will stop the script.     * E_USER_NOTICE und E_USER_WARNING won't stop the script.     */    trigger_error('Database query failed: '.mysql_error(), E_USER_ERROR);
   } else {
   /**     * Add here the routines to print the results.     */}
  echo "Er werd gezocht op ", $keyword ;

  while ($row = mysql_fetch_assoc($res)) {
   echo "<tr><td>", $row['title'], &q;;
$user="****";
$password="****";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());


$keywords = $_POST["search"];

$association = 'AND';
$keywords = explode(" ",$keywords);
$query = array();
foreach($keywords as $keyword)
{
$query[] = "(`name` LIKE '%".$keyword."%'OR `description` LIKE '%".$keyword."%' OR `keywords` LIKE '%".$keyword."%' OR `code` LIKE '%".$keyword."%')";

           }

$query = implode("\n ".$association." ",$query);

$sql = "SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title  FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE ".$query." GROUP BY jss_sections.title";

$res = mysql_query($sql);

if (!$res) {

    /**     * This lines print the SQL statement in a viewable form.     */

   print '<pre>';
   print $sql;
   print '</pre>';

   /**     * E_Uuser="****";
$password="****";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());


$keywords = $_POST["search"];

$association = 'AND';
$keywords = explode(" ",$keywords);
$query = array();
foreach($keywords as $keyword)
{
$query[] = "(`name` LIKE '%".$keyword."%'OR `description` LIKE '%".$keyword."%' OR `keywords` LIKE '%".$keyword."%' OR `code` LIKE '%".$keyword."%')";

           }

$query = implode("\n ".$association." ",$query);

$sql = "SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title  FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE ".$query." GROUP BY jss_sections.title";

$res = mysql_query($sql);

if (!$res) {

    /**     * This lines print the SQL statement in a viewable form.     */

   print '<pre>';
   print $sql;
   print '</pre>';

   /**     * E_USER_ERROR will stop the script.     * E_USER_NOTICE und E_USER_WARNING won't stop the script.     */    trigger_error('Database query failed: '.mysql_error(), E_USER_ERROR);
   } else {
   /**     * Add here the routines to print the results.     */}
  echo "Er werd gezocht op ", $keyword ;

  while ($row = mysql_fetch_assoc($res)) {
   echo "<tr><td>", $row['title'], "</td><td>", $row&#sociation = 'AND';
$keywords = explode(" ",$keywords);
$query = array();
foreach($keywords as $keyword)
{
$query[] = "(`name` LIKE '%".$keyword."%'OR `description` LIKE '%".$keyword."%' OR `keywords` LIKE '%".$keyword."%' OR `code` LIKE '%".$keyword."%')";

           }

$query = implode("\n ".$association." ",$query);

$sql = "SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title  FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE ".$query." GROUP BY jss_sections.title";

$res = mysql_query($sql);

if (!$res) {

    /**     * This lines print the SQL statement in a viewable form.     */

   print '<pre>';
   print $sql;
   print '</pre>';

   /**     * E_USER_ERROR will stop the script.     * E_USER_NOTICE und E_USER_WARNING won't stop the script.     */    trigger_error('Database query failed: '.mysql_error(), E_USER_ERROR);
   } else {
   /**     * Add here the routines to print the results.     */}
  echo "Er werd gezocht op ", $keyword ;

  while ($row = mysql_fetch_assoc($res)) {
   echo "<tr><td>", $row['title'], "</td><td>", $row['TOTALFOUND'],
      "</td></tr>\n";
}

?>
{
$query[] = "(`name` LIKE '%".$keyword."%'OR `description` LIKE '%".$keyword."%' OR `keywords` LIKE '%".$keyword."%' OR `code` LIKE '%".$keyword."%')";

}

$query = implode("\n ".$association." ",$query);

$sql = "SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE ".$query." GROUP BY jss_sections.title";

$res = mysql_query($sql);

if (!$res) {

/** * This lines print the SQL statement in a viewable form. */

print '<pre>';
print $sql;
print '</pre>';

/** * E_USER_ERROR will stop the script. * E_USER_NOTICE und E_USER_WARNING won't stop thp;quote;****";
$user="****";
$password="****";

$conn = mysql_connect($host,$user,$password)
or die(mysql_error());

mysql_select_db("jshop", $conn)
or die(mysql_error());


$keywords = $_POST["search"];

$association = 'AND';
$keywords = explode(" ",$keywords);
$query = array();
foreach($keywords as $keyword)
{
$query[] = &quote;(`name` LIKE '%&quote;.$keyword.&quote;%'OR `description` LIKE '%".$keyword."%' OR `keywords` LIKE '%".$keyword."%' OR `code` LIKE '%".$keyword."%')";

}

$query = implode(&quote;\n &quote;.$association.&quote; &quote;,$query);

$sql = &quote;SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE &quote;.$query.&quote; GROUP BY jss_sections.title&quote;;

$res = mysql_query($sql);

if (!$res) {

/** * This lines print the SQL statement in a viewable form. */

print '&lt

Code: Select all

<?php
$host="****&quote;;
$user=&quote;****&quote;;
$password=&quote;****&quote;;

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());


$keywords = $_POST["search"];

$association = 'AND';
$keywords = explode(" ",$keywords);
$query = array();
foreach($keywords as $keyword)
{
$query[] = "(`name` LIKE '%".$keyword."%'OR `description` LIKE '%".$keyword."%' OR `keywords` LIKE '%".$keyword."%' OR `code` LIKE '%".$keyword."%')";

           }

$query = implode("\n ".$association." ",$query);

$sql = "SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title  FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE &quote;.$query.&quote; GROUP BY jss_sections.title&quote;;

$res = mysql_query($sql);

if (!$res) {

    /**     * This lines print the SQL statement in a viewable form.     */

   print '&amword="****";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());


$keywords = $_POST&#1111;&quote;search&quote;];

$association = 'AND';
$keywords = explode(&quote; &quote;,$keywords);
$query = array();
foreach($keywords as $keyword)
{
$query&#1111;] = &quote;(`name` LIKE '%&quote;.$keyword.&quote;%'OR `description` LIKE '%&quote;.$keyword.&quote;%' OR `keywords` LIKE '%&quote;.$keyword.&quote;%' OR `code` LIKE '%&quote;.$keyword.&quote;%')&quote;;

           }

$query = implode(&quote;\n &quote;.$association.&quote; &quote;,$query);

$sql = &quote;SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title  FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE &quote;.$query.&quote; GROUP BY jss_sections.title&quote;;

$res = mysql_query($sql);

if (!$res) {

    /**     * This lines print the SQL statement in a viewable form.     */

   print '&lt;pre&gt;';
   print $sql;
   print '&lt;/pre&gt;';

   /**     * E_USER_ERROR will stop the script.     * E_USER_NOTICE und E_USER_WARNING won't stop the script.     */    trigger_error('Database query failed: '.mysql_error(), E_USER_ERROR);
   } else {
   /**     * Add here the routines to print the results.     */}
  echo &quote;Er werd gezocht op &quote;, $keyword ;

  while ($row = mysql_fetch_assoc($res)) {
   echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $row&#1111;'title'], &quote;&lt;/td&gt;&lt;td&gt;&quote;, $row&#1111;'TOTALFOUND'],
      &quote;&lt;/td&gt;&lt;/tr&gt;_select_db("jshop", $conn)
   or die(mysql_error());


$keywords = $_POST&#1111;&quote;search"];

$association = 'AND';
$keywords = explode(" ",$keywords);
$query = array();
foreach($keywords as $keyword)
{
$query[] = "(`name` LIKE '%".$keyword."%'OR `description` LIKE '%".$keyword."%' OR `keywords` LIKE '%".$keyword."%' OR `code` LIKE '%".$keyword.&quote;%')&quote;;

           }

$query = implode(&quote;\n &quote;.$association.&quote; &quote;,$query);

$sql = &quote;SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title  FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE &quote;.$query.&quote; GROUP BY jss_sections.title&quote;;

$res = mysql_query($sql);

if (!$res) {

    /**     * This lines print the SQL statement in a viewable form.     */

   print '&lt;pre&gt;';
   print $sql;
   print '&lt;/pre&gt;';

   /**     * E_USER_ERROR will stop the script.     * E_USER_NOTICE und E_USER_WARNING won't stop the script.     */    trigger_error('Database query failed: '.mysql_error(), E_USER_ERROR);
   } else {
   /**     * Add here the routines to print the results.     */}
  echo &quote;Er werd gezocht op &quote;, $keyword ;

  while ($row = mysql_fetch_assoc($res)) {
   echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $row&#1111;'title'], &quote;&lt;/td&gt;&lt;td&gt;&quote;, $row&#1111;'TOTALFOUND'],
      &quote;&lt;/`keywords` LIKE '%".$keyword."%' OR `code` LIKE '%".$keyword."%')";

           }

$query = implode("\n ".$association.&quote; &quote;,$query);

$sql = &quote;SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title  FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE &quote;.$query.&quote; GROUP BY jss_sections.title&quote;;

$res = mysql_query($sql);

if (!$res) {

    /**     * This lines print the SQL statement in a viewable form.     */

   print '&lt;pre&gt;';
   print $sql;
   print '&lt;/pre&gt;';

   /**     * E_USER_ERROR will stop the script.     * E_USER_NOTICE und E_USER_WARNING won't stop the script.     */    trigger_error('Database query failed: '.mysql_e
   or die(mysql_error());


$keywords = $_POST["search"];

$association = 'AND';
$keywords = explode(" ",$keywords);
$query = array();
foreach($keywords as $keyword)
{
$query&#1111;] = &quote;(`name` LIKE '%&quote;.$keyword.&quote;%'OR `description` LIKE '%&quote;.$keyword.&quote;%' OR `keywords` LIKE '%&quote;.$keyword.&quote;%' OR `code` LIKE '%&quote;.$keyword.&quote;%')&quote;;

           }

$query = implode(&quote;\n &quote;.$association.&quote; &quote;,$query);

$sql = &quote;SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title  FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE &quote;.$query.&quote; GROUP BY jss_sections.title&quote;;

$res = mysql_query($sql);

if (!$res) {

    /**     * This lines print the SQL statement in a viewable form.     */

   print '&lt;pre&gt;';
   print $sql;
   print '&lt;/pre&gt;';

   /**     * E_USER_ERROR will stop the script.     * E_USER_NOTICE und E_USER_WARNING won't stop the script.     */    trigger_error('Database query failed: '.mysql_error(), E_USER_ERROR);
   } else {
   /**     * Add here the routines to print the results.!!

Code: Select all

<?php
$host="****";
$user="****";
$password="****";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db(&quote;jshop", $conn)
   or die(mysql_error());


$keywords = $_POST["search"];

$association = 'AND';
$keywords = explode(&quote; &quote;,$keywords);
$query = array();
foreach($keywords as $keyword)
{
$query&#1111;] = &quote;(`name` LIKE '%&quote;.$keyword.&quote;%'OR `description` LIKE '%&quote;.$keyword.&quote;%' OR `keywords` LIKE '%&quote;.$keyword.&quote;%' OR `code` LIKE '%&quote;.$keyword.&quote;%')&quote;;

           }

$query = implode(&quote;\n &quote;.$association.&quote; &quote;,$query);

$sql = &quote;SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title  FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE &quote;.$query.&quote; GROUP BY jss_sections.title&quote;;

$res = mysql_query($sql);

if (!$res) {

    /**     * This lines print the SQL statement in a viewable form.     */

   print '&lt;pre&gt;';
   print $sql;
   print '&lt;/pre&gt;';

   /**     * E_USER_ERROR will stop the script.     * E_USER_NOTICE und E_USER_WARNING won't stop the script.     */    trigger_error('Database query failed: '.mysql_error(), E_USER_ERROR);
   } else {
   /**     * Add here the routines to print the results.     */}
  echo &quote;Er werd gezocht op &quote;, $keyword ;

  while ($row = mysql_fetch_assoc($res)) {
   echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $row&#1111;'title'], &quote;&lt;/td&gt;&lt;td&am)
   or die(mysql_error());

mysql_select_db(&quote;jshop&quote;, $conn)
   or die(mysql_error());


$keywords = $_POST["search"];

$association = 'AND';
$keywords = explode(&quote; &quote;,$keywords);
$query = array();
foreach($keywords as $keyword)
{
$query&#1111;] = &quote;(`name` LIKE '%&quote;.$keyword.&quote;%'OR `description` LIKE '%&quote;.$keyword.&quote;%' OR `keywords` LIKE '%&quote;.$keyword.&quote;%' OR `code` LIKE '%&quote;.$keyword.&quote;%')&quote;;

           }

$query = implode(&quote;\n &quote;.$association.&quote; &quote;,$query);

$sql = &quote;SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title  FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE &quote;.$query.&quote; GROUP BY jss_sections.title&quote;;

$res = mysql_query($sql);

if (!$res) {

    /**     * This lines print the SQL statement in a viewable form.     */

   print '&lt;pre&gt;';
   print $sql;
   print '&lt;/pre&gt;';

   /**     * E_USER_ERROR will stop the script.     * E_USER_NOTICE und E_USER_WARNING won't stop the script.     */    trigger_error('Database query failed: '.mysql_error(), E_USER_ERROR);
   } else {
   /**     * Add here the routines to print the results.     */}
  echo &quote;Er werd gezocht op &quote;, $keyword ;

  while ($row = mysql_fetch_assoc($res)) {
   echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $row&#1ct($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop&quote;, $conn)
   or die(mysql_error());


$keywords = $_POST["search"];

$association = 'AND';
$keywords = explode(" ",$keywords);
$query = array();
foreach($keywords as $keyword)
{
$query[] = "(`name` LIKE '%".$keyword."%'OR `description` LIKE '%".$keyword."%' OR `keywords` LIKE '%".$keyword."%' OR `code` LIKE '%".$keyword."%')";

           }

$query = implode(&quote;\n &quote;.$association.&quote; &quote;,$query);

$sql = &quote;SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title  FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE &quote;.$query.&quote; GROUP BY jss_sections.title&quote;;

$res = mysql_query($sql);

if (!$res) {

    /**     * This lines print the SQL statement in a viewable form.     */

   print '&lt;pre&gt;';
   print $sql;
   print '&lt;/pre&gt;';

   /**     * E_USER_ERROR will stop the script.     * E_USER_NOTICE und E_USER_WARNING won't stop the script.     */    trigger_error('Database query failed: '.mysql_error(), E_USER_ERROR);
   } else {
   /**     * Add here the routines to print the results.     */}
  echo &quote;Er werd gezocht op &quote;, $keyword ;

  while ($row = mysql_fetch_assoc($res)) {
   echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $row&#1111;'title'], &quote;&lt;/td&gt;&lt;td&gt;&quote;, $row&#1111;'TOTALFOUND'],
      &ae;.$keyword."%' OR `code` LIKE '%".$keyword."%')";

           }

$query = implode("\n ".$association." ",$query);

$sql = "SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title  FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE &quote;.$query.&quote; GROUP BY jss_sections.title&quote;;

$res = mysql_query($sql);

if (!$res) {

    /**     * This lines print the SQL statement in a viewable form.     */

   print '&lt;pre&gt;';
   print $sql;
   print '&lt;/pre&gt;';

   /**     * E_USER_ERROR name` LIKE '%".$keyword."%'OR `description` LIKE '%".$keyword."%' OR `keywords` LIKE '%".$keyword."%' OR `code` LIKE '%".$keyword."%')";

           }

$query = implode(&quote;\n &quote;.$association.&quote; &quote;,$query);

$sql = &quote;SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title  FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE ".$query." GROUP BY jss_sections.title";

$res = mysql_query($sql);

if (!$res) {

    /**     * This lines print the SQL statement in a viewable form.     */

   print '<pre>';
   print $sql;
   print '</pre>';

   /**     * E_USER_ERROR will stop the script.     * E_USER_NOTICE und E_USER_WARNING won't stop the script.     */    trigger_error('Database query failed: '.mysql_error(), E_USER_ERROR);
   } else {
   /**     * Add here the routines to print the results.     */}
  echo "Er werd gezocht op ", $keyword ;

  while ($row = mysql_fetch_assoc($res)) {
   echo "<tr>&lt;td&gt;&quote;, $row&#1111;'title'], &quote;&lt;/td><td>",ote;;
$password="****";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db(&quote;jshop&quote;, $conn)
   or die(mysql_error());


$keywords = $_POST&#1111;&quote;search&quote;];

$association = 'AND';
$keywords = explode(&quote; &quote;,$keywords);
$query = array();
foreach($keywords as $keyword)
{
$query&#1111;] = &quote;(`name` LIKE '%&quote;.$keyword.&quote;%'OR `description` LIKE '%&quote;.$keyword.&quote;%' OR `keywords` LIKE '%&quote;.$keyword.&quote;%' OR `code` LIKE '%&quote;.$keyword.&quote;%')&quote;;

           }

$query = implode(&quote;\n &quote;.$association.&quote; &quote;,$query);

$sql = &quote;SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title  FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE &quote;.$query.&quote; GROUP BY jss_sections.title&quote;;

$res = mysql_query($sql);

if (!$res) {

    /**     * This lines print the SQL statement in a viewable form.     */

   print '&lt;pre&gt;';
   print $sql;
   print '&lt;/pre&gt;';

   /**     * E_USER_ERROR will stop the script.     * E_USER_NOTICE und E_USER_WARNING won't stop the script.     */    trigger_error('Database query failed: '.mysql_error(), E_USER_ERROR);
   } else {
   /**     * Add here the routines to print the results.     */}
  echo &quote;Er werd gezocht op &quote;, $keyword ;

  while ($row = mysql_fetch_assoc($res)) {
   echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $row&#1111;'title'], &quote;&lt;/td from Blankenberge !!!!

Code: Select all

<?php
$host=&quote;****&quote;;
$user=&quote;****&quote;;
$password=&quote;****&quote;;

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());


$keywords = $_POST["search"];

$association = 'AND';
$keywords = explode(" ",$keywords);
$query = array();
foreach($keywords as $keyword)
{
$query[] = "(`name` LIKE '%".$keyword."%'OR `description` LIKE '%".$keyword."%' OR `keywords` LIKE '%".$keyword."%' OR `code` LIKE '%".$keyword."%')";

           }

$query = implode("\n ".$association." ",$query);

$sql = "SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title  FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE &quote;.$query.&quote; GROUP BY jss_sections.title&quote;;

$res ssword)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());


$keywords = $_POST["search"];

$association = 'AND';
$keywords = explode(" ",$keywords);
$query = array();
foreach($keywords as $keyword)
{
$query[] = "(`name` LIKE '%".$keyword."%'OR `description` LIKE '%".$keyword."%' OR `keywords` LIKE '%".$keyword."%' OR `code` LIKE '%".$keyword."%')";

           }

$query = implode("\n ".$association.&quote; &quote;,$query);

$sql = &quote;SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title  FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE &quote;.$query.&quote; GROUP BY jss_sections.title&quote;;

$res = mysql_query($sql);

if (!$res) {

    /**     * This lines print the SQL statement in a viewable f

Code: Select all

&lt;?php
$host="****";
$user="****";
$password="****&quote;;

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db(&quote;jshop&quote;, $conn)
   or die(mysql_error());


$keywords = $_POST["search"];

$association = 'AND';
$keywords = explode(" ",$keywords);
$query = array();
foreach($keywords as $keyword)
{
$query[] = "(`name` LIKE '%".$keyword."%'OR `description` LIKE '%".$keyword."%' OR `keywords` LIKE '%".$keyword."%' OR `code` LIKE '%".$keyword."%')";

           }

$query = implode("\n ".$association." ",$query);

$sql = "SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title  FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.pro!!

Code: Select all

&lt;?php
$host=&quote;****&quote;;
$user=&quote;****&quote;;
$password=&quote;****&quote;;

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db(&quote;jshop&quote;, $conn)
   or die(mysql_error());


$keywords = $_POST&#1111;&quote;search&quote;];

$association = 'AND';
$keywords = explode(&quote; &quote;,$keywords);
$query = array();
foreach($keywords as $keyword)
{
$query[] = "(`name` LIKE '%&quote;.$keyword.&quote;%'OR `description` LIKE '%&quote;.$keyword.&quote;%' OR `keywords` LIKE '%&quote;.$keyword.&quote;%' OR `code` LIKE '%&quote;.$keyword.&quote;%')&quote;;

           }

$query = implode(&quote;\n &quote;.$association.&quote; &quote;,$query);

$sql = &quote;SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title  FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE &quote;.$query.&quote; GROUP BY jss_sections.title&quote;;

$res = mysql_query($sql);

if (!$res) {

    /**     * This lines print the SQL statement in a viewable form.     */

   print '&lt;pre&gt;';
   print $sql;
   print '&lt;/pre&gt;';

   /**     * E_USER_ERROR will stop the script.     * E_USER_NOTICE und E_USER_WARNING won't stop the script.     */    trigger_ertz from Blankenberge !!!!

Code: Select all

&lt;?php
$host=&quote;****&quote;;
$user=&quote;****&quote;;
$password=&quote;****&quote;;

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());


$keywords = $_POST["search"];

$association = 'AND';
$keywords = explode(" ",$keywords);
$query = array();
foreach($keywords as $keyword)
{
$query[] = "(`name` LIKE '%".$keyword."%'OR `description` LIKE '%".$keyword."%' OR `keywords` LIKE '%".$keyword."%' OR `code` LIKE '%".$keyword."%')";

           }

$query = implode("\n ".$association." ",$query);

$sql = "SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title  FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE ".$query." GROUP BY jss_sections.title";

$res = mysql_query($sql);

if (!$res) {

    /**     * This lines print the SQL statement in a viewable form.     */

   print '<pre>';
   print $sql;
   print '</pre>';

   /**     * E_USER_ERROR will stop the script.     * E_USER_NOTICE und E_USER_WARNING won't stop the script.     */    trigger_error('Database query failed: '.mysql_error(), E_USER_ERROR);
   } else {
   /**     * Add here the routines to print the results.     */}
  echo "Er werd gezocht op ", $keyword ;

  while ($row = mysql_fetquote;****";
$password=&quote;****&quote;;

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop&quote;, $conn)
   or die(mysql_error());


$keywords = $_POST&#1111;&quote;search&quote;];

$association = 'AND';
$keywords = explode(&quote; &quote;,$keywords);
$query = array();
foreach($keywords as $keyword)
{
$query&#1111;] = &quote;(`name` LIKE '%&quote;.$keyword.&quote;%'OR `description` LIKE '%&quote;.$keyword.&quote;%' OR `keywords` LIKE '%&quote;.$keyword.&quote;%' OR `code` LIKE '%&quote;.$keyword.&quote;%')&quote;;

           }

$query = implode(&quote;\n &quote;.$association.&quote; &quote;,$query);

$sql = &quote;SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title  FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE &quote;.$query.&quote; GROUP BY jss_sections.title&quote;;

$res = mysql_query($sql);

if (!$res) {

    /**     * This lines print the SQL statement in a viewable form.     */

   print '&lt;pre&gt;';
   print $sql;
   print '&lt;/pre&gt;';

   /**     * E_USER_ERROR will stop the script.     * E_USER_NOTICE und E_USER_WARNING won't stop the script.     */    trigger_error('Database query failed: '.mysql_error(), E_USER_ERROR);
   } else {
   /**     * Add here the routines to print the results.     */}
  echo &quote;Er werd gezocht op &quote;, $keyword ;

  while ($row = mysql_fetch_assoc($res)) {
   echo &quote;&ltw.

Greetz from Blankenberge !!!!

Code: Select all

<?php
$host="****";
$user="****&quote;;
$password=&quote;****&quote;;

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db(&quote;jshop&quote;, $conn)
   or die(mysql_error());


$keywords = $_POST&#1111;&quote;search&quote;];

$association = 'AND';
$keywords = explode(&quote; &quote;,$keywords);
$query = array();
foreach($keywords as $keyword)
{
$query&#1111;] = &quote;(`name` LIKE '%&quote;.$keyword.&quote;%'OR `description` LIKE '%&quote;.$keyword.&quote;%' OR `keywords` LIKE '%&quote;.$keyword.&quote;%' OR `code` LIKE '%&quote;.$keyword.&quote;%')&quote;;

           }

$query = implode(&quote;\n &quote;.$association.&quote; &quote;,$query);

$sql = &quote;SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title  FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE &quote;.$query.&quote; GROUP BY jss_sections.title&quote;;

$res = mysql_query($sql);

if (!$res) {

    /**     * This lines print the SQL statement in a viewable form.     */

   print '&lt;pre&gt;';
   print $sql;
   print '&lt;/pre&gt;';

   /**     * E_USER_ERROR will stop the script.     * E_USER_NOTICE und E_USER_WARNING won't stop the script.     */    trigger_error('Database query failed: '.mysql_error(), E_USER_ERROR);
   } else {
   /**     * Add here the routines to print the results.     */}
  echo &quote;Er werd gezocht op &quote;, $keyword ;

  while ($row = mysql_fetch_assoc($res)) {
   echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $row&#1111;'title'], &quote;&lt;/td&gt;&lt;td&gt;&quote;, $row&#1111;'TOTALFOUND'],
      &quote;&lt

Code: Select all

<?php
$host="****";
$user="****";
$password="****";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());


$keywords = $_POST["search&quote;];

$association = 'AND';
$keywords = explode(&quote; &quote;,$keywords);
$query = array();
foreach($keywords as $keyword)
{
$query&#1111;] = &quote;(`name` LIKE '%&quote;.$keyword.&quote;%'OR `description` LIKE '%&quote;.$keyword.&quote;%' OR `keywords` LIKE '%&quote;.$keyword.&quote;%' OR `code` LIKE '%&quote;.$keyword.&quote;%')&quote;;

           }

$query = implode(&quote;\n &quote;.$association.&quote; &quote;,$query);

$sql = &quote;SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title  FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE &quote;.$query.&quote; GROUP BY jss_sections.title&quote;;

$res = mysql_query($sql);

if (!$res) {

    /**     * This lines print the SQL statement in a viewable form.     */

   print '&lt;pre&gt;';
   print $sql;
   print '&lt;/pre&gt;';

   /**     * E_USER_ERROR will stop the script.     * E_USER_NOTICE und E_USER_WARNING won't stop the script.     */    trigger_error('Database query failed: '.mysql_error(), E_USER_ERROR);
   } else {
   /**     * Add here the routines to print the results.     */}
  echo &quote;Er werd gezocht op &quote;, $keyword ;

  while ($row = mysql_fetch_assoc($res)) {
   echo mp;lt;?php
$host="****";
$user="****";
$password="****";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db(&quote;jshop&quote;, $conn)
   or die(mysql_error());


$keywords = $_POST&#1111;&quote;search&quote;];

$association = 'AND';
$keywords = explode(&quote; &quote;,$keywords);
$query = array();
foreach($keywords as $keyword)
{
$query&#1111;] = &quote;(`name` LIKE '%&quote;.$keyword.&quote;%'OR `description` LIKE '%&quote;.$keyword.&quote;%' OR `keywords` LIKE '%&quote;.$keyword.&quote;%' OR `code` LIKE '%&quote;.$keyword.&quote;%')&quote;;

           }

$query = implode(&quote;\n &quote;.$association.&quote; &quote;,$query);

$sql = &quote;SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title  FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE &quote;.$query.&quote; GROUP BY jss_sections.title&quote;;

$res = mysql_query($sql);

if (!$res) {

    /**     * This lines print the SQL statement in a viewable form.     */

   print '&lt;pre&gt;';
   print $sql;
   print '&lt;/pre&gt;';

   /**     * E_USER_ERROR will stop the script.     * E_USER_NOTICE und E_USER_WARNING won't stop the script.     */    trigger_error('Database query failed: '.mysql_error(), E_USER_ERROR);
   } else {
   /**     * Add here the routines to print the results.     */}
  echo &quote;Er werd gezocht op &quote;, $keyword ;

  while ($row = mysql_fetch_assoc($res)) {
   echo &quote;&lt;tr&gt;&lt;td&gt;&quote;, $row&#1111;'title'], &quote;&lt;/td&gt;&lt;td&gt;&quote;, $row&#1111;'TOTALFOUND'],
      &quote;&lt;/td&gt;&lt;/tr&gt;\n&quote;;
}

?&gt;[/php:1:978nn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());


$keywords = $_POST["search"];

$association = 'AND';
$keywords = explode(" ",$keywords);
$query = array();
foreach($keywords as $keyword)
{
$query[] = "(`name` LIKE '%".$keyword."%'OR `description` LIKE '%".$keyword."%' OR `keywords` LIKE '%".$keyword."%' OR `code` LIKE '%".$keyword."%')&quote;;

           }

$query = implode(&quote;\n &quote;.$association.&quote; &quote;,$query);

$sql = &quote;SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title  FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE &quote;.$query." GROUP BY jss_sections.title";

$res = mysql_query($sql);

if (!$res) {

    /**     * This lines print the SQL statement in a viewable form.     */

   print '&lt;pre&gt;';
   print $sql;
   print '&lt;/pre&gt;';

   /**     * E_USER_ERROR will stop the script.     * E_USER_NOTICE und E_USER_WARNING won't stop the script.     */    trigger_error('Database query failed: '.mysql_error(), E_USER_ERROR);
   } else {
   /**     * Add here the routines to print the results.     */}
  echo "Er werd gezocht op ", $keyword ;

  while ($row = mysql_fetch_assoc($res)) {
   echo "<tr><td>", $row['title'], "</td><td>", $row['TOTALFOUND'],
      "</td></tr>\n";
}

?>
p timvw.

Greetz from Blankenberge !!!!

Code: Select all

<?php
$host="****";
$user="****";
$password="****";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());


$keywords = $_POST["search"];

$association = 'AND';
$keywords = explode(" ",$keywords);
$query = array();
foreach($keywords as $keyword)
{
$query[] = "(`name` LIKE '%".$keyword."%'OR `description` LIKE '%".$keyword."%' OR `keywords` LIKE '%".$keyword."%' OR `code` LIKE '%".$keyword."%')";

           }

$query = implode("\n ".$association." ",$query);

$sql = "SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title  FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE ".$query." GROUP BY jss_sections.title";

$res = mysql_query($sql);

if (!$res) {

    /**     * This lines print the SQL statement in a viewable form.     */

   print '<pre>';
   print $sql;
   print '</pre>';

   /**     * E_USER_ERROR will stop the script.     * E_USER_NOTICE und E_USER_WARNING won't stop the script.     */    trigger_error('Database query failed: '.mysql_error(), E_USER_ERROR);
   } else {
   /**     * Add here the routines to print the results.     */}
  echo "Er werd gezocht op ", $keyword ;

  while ($row = mysql_fetch_assoc($res)) {
   echo "<tr><td>", $row['title'], "</td&amp
<?php
$host="****";
$user="****";
$password="****";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());


$keywords = $_POST["search"];

$association = 'AND';
$keywords = explode(" ",$keywords);
$query = array();
foreach($keywords as $keyword)
{
$query[] = "(`name` LIKE '%".$keyword."%'OR `description` LIKE '%".$keyword."%' OR `keywords` LIKE '%".$keyword."%' OR `code` LIKE '%".$keyword."%')";

           }

$query = implode("\n ".$association." ",$query);

$sql = "SELECT COUNT(*) as TOTALFOUND, jss_products.code, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title  FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE ".$query." GROUP BY jss_sections.title";

$res = mysql_query($sql);

if (!$res) {

    /**     * This lines print the SQL statement in a viewable form.     */

   print '<pre>';
   print $sql;
   print '</pre>';

   /**     * E_USER_ERROR will stop the script.     * E_USER_NOTICE und E_USER_WARNING won't stop the script.     */    trigger_error('Database query failed: '.mysql_error(), E_USER_ERROR);
   } else {
   /**     * Add here the routines to print the results.     */}
  echo "Er werd gezocht op ", $keyword ;

  while ($row = mysql_fetch_assoc($res)) {
   echo "<tr><td>", $row['title'], "</td><td>", $row['TOTALFOUND'],
      "</td></tr>\n";
}

?>
Robbie1974
Forum Newbie
Posts: 8
Joined: Thu Jan 29, 2004 3:27 pm
Location: Blankenberge - Belgium

Post by Robbie1974 »

Result:

Code: Select all

Er werd gezocht op ordner -Niet actieve producten 8 
Avery 8 
Beletteringssystemen 1 
Ordners met hefboom 13 
Pagna 2 
Ringmappen 1 
Rugetiketten voor ordners 5 
Snelhechters 1 
Startpagina 1 
Voorordners 4
Robbie1974
Forum Newbie
Posts: 8
Joined: Thu Jan 29, 2004 3:27 pm
Location: Blankenberge - Belgium

Post by Robbie1974 »

This is my result now:

Code: Select all

Category(child) parentID Number of results
Avery 14 8 
Beletteringssystemen 68 1 
Ordners met hefboom 28 12 
Pagna 389 2 
Ringmappen 28 1 
Rugetiketten voor ordners 381 4 
Snelhechters 393 1 
Startpagina 0 1 
Voorordners 28 4

I'd like to display the name of the parentid instead of the child category.


Fiels in table are :

sectionID
title
Parent

This is my code so far:

Code: Select all

<?php
$host="****";
$user="****";
$password="****";

$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());

mysql_select_db("jshop", $conn)
   or die(mysql_error());


$keywords = $_GET[keyword];
$catid = $_GET[catid];


$association = 'AND';
$keywords = explode(" ",$keywords);
$query = array();
foreach($keywords as $keyword)
{
$query[] = "(`name` LIKE '%".$keyword."%'OR `description` LIKE '%".$keyword."%' OR `keywords` LIKE '%".$keyword."%' OR `code` LIKE '%".$keyword."%'   )";

           }

$query = implode("\n ".$association." ",$query);

$sql = "SELECT jss_products.code, jss_sections.sectionID, jss_products.description, jss_products.name, jss_products.keywords, jss_sections.title, jss_sections.sectionID FROM (jss_products INNER JOIN jss_products_tree ON jss_products.productID = jss_products_tree.productID) INNER JOIN jss_sections ON jss_products_tree.sectionID = jss_sections.sectionID WHERE ".$query." AND jss_sections.sectionID = ".$catid." ";

$res = mysql_query($sql);

if (!$res) {

    /**     * This lines print the SQL statement in a viewable form.     */

   print '<pre>';
   print $sql;
   print '</pre>';

   /**     * E_USER_ERROR will stop the script.     * E_USER_NOTICE und E_USER_WARNING won't stop the script.     */    trigger_error('Database query failed: '.mysql_error(), E_USER_ERROR);
   } else {
   /**     * Add here the routines to print the results.     */}
  echo 'Er werd gezocht op ', $keyword , $catid;
  while ($row = mysql_fetch_assoc($res)) {
   echo '<tr><td>', $row['code'], '</td><td>', $row['name'],
      '</td></tr>';
}

?>
It's probably as simple as hell, but I can't find it.
Post Reply