Browse Products

[exec]

//host:
$host = ‘mysql50-31.wc1.dfw1.stabletransit.com’;
//user:
$user = ‘420983_wordpress’;
//password:
$password = ‘Mixomitosis1′;

$con = mysql_connect($host,$user,$password);
if (!$con)
{
die(‘Could not connect: ‘ . mysql_error());
}

mysql_select_db(“420983_costumecurio”, $con);

$sortby=$_GET['sortby'] ;

if ($sortby==’ProductNameAsc’) $result = mysql_query(“SELECT * FROM Inventory WHERE IntPrice<>‘NULL’ ORDER BY ProductName ASC”);

if ($sortby==’ProductNameDesc’) $result = mysql_query(“SELECT * FROM Inventory WHERE IntPrice<>‘NULL’ ORDER BY ProductName DESC”);

if ($sortby==’ManufacturerAsc’) $result = mysql_query(“SELECT * FROM Inventory WHERE IntPrice<>‘NULL’ ORDER BY Manufacturer ASC”);

if ($sortby==’ManufacturerDesc’) $result = mysql_query(“SELECT * FROM Inventory WHERE IntPrice<>‘NULL’ ORDER BY Manufacturer DESC”);

if ($sortby==’PriceAsc’) $result = mysql_query(“SELECT * FROM Inventory WHERE IntPrice<>‘NULL’ ORDER BY IntPrice ASC”);

if ($sortby==’PriceDesc’) $result = mysql_query(“SELECT * FROM Inventory WHERE IntPrice<>‘NULL’ ORDER BY IntPrice DESC”);

if ($sortby==’CategoryAsc’) $result = mysql_query(“SELECT * FROM Inventory WHERE IntPrice<>‘NULL’ ORDER BY Category ASC”);

if ($sortby==’CategoryDesc’) $result = mysql_query(“SELECT * FROM Inventory WHERE IntPrice<>‘NULL’ ORDER BY Category DESC”);

/*
$number_of_results=0;
while($result_count=mysql_fetch_array($result))
{
$number_of_results++;
}

echo “

There are ” . $number_of_results . ” items in the following list.

“;
*/

while($row = mysql_fetch_array($result))
{
/*
$image= “http://costumecurio.com/images_-_small_thumbnails/” . $row['LinkToImage'];
$altimgtext=$row[ProductName];
if ($row['LinkToImage']!=NULL) echo ““;
*/
$pidlink = $row['pid'];
$url=”http://costumecurio.com/sales/product-info/?&pid=” . $row['pid'];
echo “$row[ProductName]” . ” – ” ;
if ($row['ProductColor']!=NULL) echo $row['ProductColor'] . ” – ” ;
echo “by ” ;
echo $row['Manufacturer'] . ” – ” ;
echo “Price: $” . $row['ProductPrice'] ;
echo “
“;
}
[/exec]