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="****"e;;
$conn = mysql_connect($host,$user,$password)
or die(mysql_error());
mysql_select_db("e;jshop"e;, $conn)
or die(mysql_error());
$search=$_POSTї"e;search"e;];
$sql = "e;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%' "e;;
$result = mysql_query($sql)
or die(mysql_error());
$num_rows = mysql_num_rows($result);
while ($row = mysql_fetch_assoc($result)) {
echo "e;<tr><td>"e;, $rowї'title'], "e;</td><td>"e;, $num_rows , "e;</td></tr>\n"e;;
}
?><?php
$host="e;localhost"e;;
$user="e;root"e;;
$password="e;"e;;
$conn = mysql_connect($host,$user,$password)
or die(mysql_error());
mysql_select_db("e;jshop"e;, $conn)
or die(mysql_error());
$search=$_POSTї"e;search"e;];
$sql = "e;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%' "e;;
$result = mysql_query($sql)
or die(mysql_error());
$num_rows = mysql_num_rows($result);
while ($row = mysql_fetch_assoc($result)) {
echo "e;<tr><td>"e;, $rowї'title'], "e;</td><td>"e;, $num_rows , "e;</td></tr>\n"e;;
}
?>
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("e;jshop"e;, $conn)
or die(mysql_error());
$search=$_POSTї"e;search"e;];
$sql = "e;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>"e;, $rowї'title'], "e;</td><td>"e;, $num_rows , "e;</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?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%' "e;;
$result = mysql_query($sql)
or die(mysql_error());
$num_rows = mysql_num_rows($result);
while ($row = mysql_fetch_assoc($result)) {
echo "e;<tr><td>"e;, $rowї'title'], "e;</td><td>"e;, $num_rows , "e;</td></tr>\n"e;;
}
?><?php
$host="e;localhost"e;;
$user="e;root"e;;
$password="e;"e;;
$conn = mysql_connect($host,$user,$password)
or die(mysql_error());
mysql_select_db("e;jshop"e;, $conn)
or die(mysql_error());
$search=$_POSTї"e;search"e;];
$sql = "e;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%' "e;;
$result = mysql_query($sql)
or die(mysql_error());
$num_rows = mysql_num_rows($result);
while ($row = mysql_fetch_assoc($result)) {
echo "e;<tr><td>"e;, $rowї'title'], "e;</td><td>"e;, $num_rows , "e;</td></tr>\n"e;;
}
?>
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%' "e;;
$result = mysql_query($sql)
or die(mysql_error());
$num_rows = mysql_num_rows($result);
while ($row = mysql_fetch_assoc($result)) {
echo "e;<tr><td>"e;, $rowї'title'], "e;</td><td>"e;, $num_rows , "e;</td></tr>\n"e;;
}
?><?php
$host="e;localhost"e;;
$user="e;root"e;;
$password="e;"e;;
$conn = mysql_connect($host,$user,$password)
or die(mysql_error());
mysql_select_db("e;jshop"e;, $conn)
or die(mysql_error());
$search=$_POSTї"e;search"e;];
$sql = "e;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%' "e;;
$result = mysql_query($sql)
or die(mysql_error());
$num_rows = mysql_num_rows($result);
while ($row = mysql_fetch_assoc($result)) {
echo "e;<tr>< 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 "e;<tr><td>"e;, $rowї'title'], "e;</td><td>"e;, $num_rows , "e;</td></tr>\n"e;;
}
?><?php
$host="e;localhost"e;;
$user="e;root"e;;
$password="e;"e;;
$conn = mysql_connect($host,$user,$password)
or die(mysql_error());
mysql_select_db("e;jshop"e;, $conn)
or die(mysql_error());
$search=$_POSTї"e;search"e;];
$sql = "e;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("e;jshop"e;, $conn)
or die(mysql_error());
$search=$_POSTї"e;search"e;];
$sql = "e;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%' "e;;
$result = mysql_query($sql)
or die(mysql_error());
$num_rows = mysql_num_rows($result);
while ($row = mysql_fetch_assoc($result)) {
echo "e;<tr><td>"e;, $rowї'title'], "e;</td><td>"e;, $num_rows , "e;</td></tr>\n"e;;
}
?><?php
$host="e;localhost"e;;
$user="e;root"e;;
$password="e;"e;;
$conn = mysql_connect($host,$user,$password)
or die(mysql_error());
mysql_select_db("e;jshop"e;, $conn)
or die(mysql_error());
$search=$_POSTї"e;search"e;];
$sql = "e;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%' "e;;
$result = mysql_query($sql)
or die(mysql_error());
$num_rows = mysql_num_rows($result);
while ($row = mysql_fetch_assoc($result)) {
echo "e;<tr><td>"e;, $rowї'title'], "e;</td><td>"e;, $num_rows , "e;</td></tr>\n"e;;
}
?>[/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]<?php
$host="e;****"e;;
$user="e;****"e;;
$password="e;****"e;;
$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%' "e;;
$result = mysql_query($sql)
or die(mysql_error());
$num_rows = mysql_num_rows($result);
while ($row = mysql_fetch_assoc($result)) {
echo "e;<tr><td>"e;, $rowї'title'], "e;</td><td>"e;, $num_rows , "e;</td></tr>\n"e;;
}
?><?php
$host="e;localhost"e;;
$user="e;root"e;;
$password="e;"e;;
$conn = mysql_connect($host,$user,$password)
or die(mysql_error());
mysql_select_db("e;jshop"e;, $conn)
or die(mysql_error());
$search=$_POSTї"e;search"e;];
$sql = "e;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%' "e;;
$result = mysql_query($sql)
or die(mysql_error());
$num_rows = mysql_num_rows($result);
while ($row = mysql_fetch_assoc($result)) {
echo "e;<tr><td>"e;, $rowї'title'], "e;</td><td>"e;, $num_rows , &xbm1mx3i255yqf30k45)/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ї"e;search"e;];
$sql = "e;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%' "e;;
$result = mysql_query($sql)
or die(mysql_error());
$num_rows = mysql_num_rows($result);
while ($row = mysql_fetch_assoc($result)) {
echo "e;<tr><td>"e;, $rowї'title'], "e;</td><td>"e;, $num_rows , "e;</td></tr>\n"e;;
}
?><?php
$host="e;localhost"e;;
$user="e;root"e;;
$password="e;"e;;
$conn = mysql_connect($host,$user,$password)
or die(mysql_error());
mysql_select_db("e;jshop"e;, $conn)
or die(mysql_error());
$search=$_POSTї"e;search"e;];
$sql = "e;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%' "e;;
$result = mysql_query($sql)
or die(mysql_error());
$num_rows = mysql_num_rows($result);
while ($row = mysql_fetch_assoc($result)) {
echo "e;<tr><td>"e;, $rowї'title'], "e;</td><td>"e;, $num_rows , "e;</td></tr>\n"e;;
}
?>[/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%' "e;;
$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("e;jshop"e;, $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ї"e;search"e;];
$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%' "e;;
$result = mysql_query($sql)
or die(mysql_error());
$num_rows = mysql_num_rows($result);
while ($row = mysql_fetch_assoc($result)) {
echo "e;<tr><td>"e;, $rowї'title'], "e;</td><td>"e;, $num_rows , "e;</td></tr>\n"e;;
}
?><?php
$host="e;localhost"e;;
$user="e;root"e;;
$password="e;"e;;
$conn = mysql_connect($host,$user,$password)
or die(mysql_error());
mysql_select_db("e;jshop"e;, $conn)
or die(mysql_error());
$search=$_POSTї"e;search"e;];
$sql = "e;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%' "e;;
$result = mysql_query($sql)
or die(mysql_error());
$num_rows = mysql_num_rows($result);
while ($row = mysql_fetch_assoc($result)) {
echo "e;<tr><td>"e;, $rowї'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%' "e;;
$result = mysql_query($sql)
or die(mysql_error());
$num_rows = mysql_num_rows($result);
while ($row = mysql_fetch_assoc($result)) {
echo "e;<tr><td>"e;, $rowї'title'], "e;</td><td>"e;, $num_rows , "e;</td></tr>\n"e;;
}
?><?php
$host="e;localhost"e;;
$user="e;root"e;;
$password="e;"e;;
$conn = mysql_connect($host,$user,$password)
or die(mysql_error());
mysql_select_db("e;jshop"e;, $conn)
or die(mysql_error());
$search=$_POSTї"e;search"e;];
$sql = "e;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%' "e;;
$result = mysql_query($sql)
or die(mysql_error());
$num_rows = mysql_num_rows($result);
while ($row = mysql_fetch_assoc($result)) {
echo "e;<tr><td>"e;, $rowї'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="e;****"e;;
$password="e;****";
$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%' "e;;
$result = mysql_query($sql)
or die(mysql_error());
$num_rows = mysql_num_rows($result);
while ($row = mysql_fetch_assoc($result)) {
echo "e;<tr><td>"e;, $rowї'title'], "e;</td><td>"e;, $num_rows , "e;</td></tr>\n"e;;
}
?><?php
$host="e;localhost"e;;
$user="e;root"e;;
$password="e;"e;;
$conn = mysql_connect($host,$user,$password)
or die(mysql_error());
mysql_select_db("e;jshop"e;, $conn)
or die(mysql_error());
$search=$_POSTї"e;search"e;];
$sql = "e;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%' "e;;
$result = mysql_query($sql)
or die(mysql_error());
$num_rows = mysql_num_rows($result);
while ($row = mysql_fetch_assoc($result)) {
echo "e;<tr><td>"e;, $rowї'title'], "e;</td><td>"e;, $num_rows , "e;</td></tr>\n"e;;
}
?>
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%' "e;;
$result = mysql_query($sql)
or die(mysql_error());
$num_rows = mysql_num_rows($result);
while ($row = mysql_fetch_assoc($result)) {
echo "e;<tr><td>"e;, $rowї'title'], "e;</td><td>"e;, $num_rows , "e;</td></tr>\n"e;;
}
?><?php
$host="e;localhost"e;;
$user="e;root"e;;
$password="e;"e;;
$conn = mysql_connect($host,$user,$password)
or die(mysql_error());
mysql_select_db("e;jshop"e;, $conn)
or die(mysql_error());
$search=$_POSTї"e;search"e;];
$sql = "e;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%' "e;;
$result = mysql_query($sql)
or die(mysql_error());
$num_rows = mysql_num_rows($result);
while ($row = mysql_fetch_assoc($result)) {
echo "e;<tr><td>"e;, $rowї'title'], "e;</td><td>"e;, $num_rows , "e;</td></tr>\n"e;;
}
?>
Giving me this for result:
[code**";
$user="****";
$password="****";
$conn = mysql_connect($host,$user,$password)
or die(mysql_error());
mysql_select_db("e;jshop"e;, $conn)
or die(mysql_error());
$search=$_POSTї"e;search"e;];
$sql = "e;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%' "e;;
$result = mysql_query($sql)
or die(mysql_error());
$num_rows = mysql_num_rows($result);
while ($row = mysql_fetch_assoc($result)) {
echo "e;<tr><td>"e;, $rowї'title'], "e;</td><td>"e;, $num_rows , "e;</td></tr>\n"e;;
}
?><?php
$host="e;localhost"e;;
$user="e;root"e;;
$password="e;"e;;
$conn = mysql_connect($host,$user,$password)
or die(mysql_error());
mysql_select_db("e;jshop"e;, $conn)
or die(mysql_error());
$search=$_POSTї"e;search"e;];
$sql = "e;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%' "e;;
$result = mysql_query($sql)
or die(mysql_error());
$num_rows = mysql_num_rows($result);
while ($row = mysql_fetch_assoc($result)) {
echo "e;<tr><td>"e;, $rowї'title'], "e;</td><td>"e;, $num_rows , "e;</td></tr>\n"e;;
}
?>
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><td>"e;, $rowї'title'], "e;</td><td>"e;, $num_rows , "e;</td></tr>\n"e;;
}
?><?php
$host="e;localhost"e;;
$user="e;root"e;;
$password="e;"e;;
$conn = mysql_connect($host,$user,$password)
or die(mysql_error());
mysql_select_db("e;jshop"e;, $conn)
or die(mysql_error());
$search=$_POSTї"e;search"e;];
$sql = "e;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%' "e;;
$result = mysql_query($sql)
or die(mysql_error());
$num_rows = mysql_num_rows($result);
while ($row = mysql_fetch_assoc($result)) {
echo "e;<tr><td>"e;, $rowї'title'], "e;</td><td>"e;, $num_rows , "e;&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: