Code: Select all
<?
$username="xxxxxx";
$password="xxxxxxx";
$database="xxxxxxx";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT products_description.products_name, products_description.extra_value3, products_description.extra_value4, products_description.extra_value6, products_description.extra_value7, products_description.extra_value_id12, products_description.extra_value_id13, products.products_price ".
"FROM products_description, products ".
"WHERE products_description.products_id = products.products_id ".
"ORDER BY products_description.products_name ";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)){
echo $row['products_name']. ", ".
$row['extra_value3']. ", ". $row['extra_value4']. ", ". $row['extra_value6']. ", ". $row['extra_value7']. ", ". $row['extra_value_id12']. "/". $row['extra_value_id13']. " - ". $row['products_price'];
echo "<br />";
}
?>I want to do something like what I have posted below, I just havent found a way to implement it, everytime I've tried I either get errors or empty fields:
Code: Select all
if ($extra_value_id12 == "7" ) {
echo "SEALED";
} elseif ($extra_value_id12 == "8"){
echo "NM";
} elseif ($extra_value_id12 == "9"){
echo "EX";
} elseif ($extra_value_id12 == "10"){
echo "VG+";
} elseif ($extra_value_id12 == "11"){
echo "VG";
} elseif ($extra_value_id12 == "12"){
echo "VG-";
} elseif ($extra_value_id12 == "13"){
echo "G";
} elseif ($extra_value_id12 == "14"){
echo "P";
} else {
echo "";
}
if ($extra_value_id13 == "15" ) {
echo "SEALED";
} elseif ($extra_value_id13 == "16"){
echo "NM";
} elseif ($extra_value_id13 == "17"){
echo "EX";
} elseif ($extra_value_id13 == "18"){
echo "VG+";
} elseif ($extra_value_id13 == "19"){
echo "VG";
} elseif ($extra_value_id13 == "20"){
echo "VG-";
} elseif ($extra_value_id13 == "21"){
echo "G";
} elseif ($extra_value_id13 == "22"){
echo "P";
} else {
echo "";
}