Bit of a problem - - - Not quite sure?

[kachurak]

I have a page that is to be displayed with one applet if the condition met is either true/false. The problem is, that if a condition is NEITHER, I want it to return to an error page or a page that describes that the item was not found. I need it to recognize if the item is AVAILABLE, if it is, continue on, AND if the item is also a recognized ProductCode. If not, then redirect to the error page.

So here's what I have currently -->

if ($row_products['Availability'] == true );

But the problem is, the field contains either YES or NO... ? I've tried changing to:

if ($row_products['Availability'] != 'Yes' );
if ($row_products['Availability'] == 'No' );

But ends up STILL showing the error that I have in place!? Can this not be done this way? If not, what's my alternative?

Thanks in advance!

[olechka]

if (($row_products['Availability'] == 'Yes') OR ($row_products['Availability'] == 'No')
{
//do something
}
else
{
//display your error page
}

[bernouli]

if ($row_products['Availability'] != 'Yes' ) {
. . .
}
else if ($row_products['Availability'] == 'No' ) {
. . .
}
else {
. . .
}

[olechka]

sorry I missed the closing parenthesis after No
if (($row_products['Availability'] == 'Yes') OR ($row_products['Availability'] == 'No'))
{
}
else
{
}

[kachurak]

See, that's already what I've tried but failed. Here's the code in full so you can see what I've done... you can replace the AVAILABILITY IF statement with ANY of the three and it still won't work.

if ( $row_products['Availability'] == 'Yes' )
if ( $row_products['Availability'] != 'No' )
if ( $row_products['Availability'] == true )

===================================
if ( $row_products['Availability'] == "No" );
{
echo "We're sorry, but that item was not found, please try another item number.";
}
if ( $row_products['ProductSize'] != false )
{
echo "<applet width=\"200\" height=\"30\" code=\"uShopInput4.class\" codebase=\"classes3\">\n";
echo "<PARAM NAME=\"id\" VALUE=\"$row_products[ProductCode]\">\n";
echo "<PARAM NAME=\"name\" VALUE=\"$row_products[ProductName]\">\n";
echo "<PARAM NAME=\"description\" VALUE=\"$row_products[ProductDescription]\">\n";
echo "<PARAM NAME=\"option1\" VALUE=\"$row_products[ProductSize]\">\n";
echo "<PARAM NAME=\"price\" VALUE=\"$row_products[DistPrice]\">\n";
echo "<PARAM NAME=\"show_price\" VALUE=\"NO\">\n";
echo "<PARAM NAME=\"qty\" VALUE=\"1\">\n";
echo "<PARAM NAME=\"show_qty\" VALUE=\"NO\">\n";
echo "<PARAM NAME=\"classification\" VALUE=\"$row_products[Class]\">\n";
echo "<PARAM NAME=\"shipping_modifier\" VALUE=\"$0.00\">\n";
echo "<PARAM NAME=\"taxable\" VALUE=\"YES\">\n";
echo "<PARAM NAME=\"popup\" VALUE=\"YES\">\n";
echo "<PARAM NAME=\"label\" VALUE=\"Add to Cart\">\n";
echo "<PARAM NAME=\"background_color\" VALUE=\"#ffffff\">\n";
echo "<PARAM NAME=\"text_color\" VALUE=\"#000000\">\n";
echo "</applet>";
}
else
{
echo "<applet width=\"60\" height=\"25\" code=\"uShopInput1.class\" codebase=\"classes3/\">\n";
echo "<PARAM NAME=\"id\" VALUE=\"$row_products[ProductCode]\">\n";
echo "<PARAM NAME=\"name\" VALUE=\"$row_products[ProductName]\">\n";
echo "<PARAM NAME=\"description\" VALUE=\"$row_products[ProductDescription]\">\n";
echo "<PARAM NAME=\"price\" VALUE=\"$row_products[DistPrice]\">\n";
echo "<PARAM NAME=\"classification\" VALUE=\"$row_products[Class]\">\n";
echo "<PARAM NAME=\"qty\" VALUE=\"1\">\n";
echo "<PARAM NAME=\"shipping_modifier\" VALUE=\"$0.00\">\n";
echo "<PARAM NAME=\"taxable\" VALUE=\"YES\">\n";
echo "<PARAM NAME=\"popup\" VALUE=\"YES\">\n";
echo "<PARAM NAME=\"label\" VALUE=\"Add to Cart\">\n";
echo "</applet>";
}

===================================
Thanks again,

[kachurak]

Figured it out... thanks

If anyone wants to see or know how, just let me know - - -

[e-mail]

[bbaassiri]

what is the data type for availability, is it bool?

[bernouli]

if ( $row_products['Availability'] == "No" );
{
echo "We're sorry, but that item was not found, please try another item number.";
}
if ( $row_products['Availability'] == "Yes" && $row_products['ProductSize'] != false )
{
echo "<applet width=\"200\" height=\"30\" code=\"uShopInput4.class\" codebase=\"classes3\">\n";
echo "<PARAM NAME=\"id\" VALUE=\"$row_products[ProductCode]\">\n";
echo "<PARAM NAME=\"name\" VALUE=\"$row_products[ProductName]\">\n";
echo "<PARAM NAME=\"description\" VALUE=\"$row_products[ProductDescription]\">\n";
echo "<PARAM NAME=\"option1\" VALUE=\"$row_products[ProductSize]\">\n";
echo "<PARAM NAME=\"price\" VALUE=\"$row_products[DistPrice]\">\n";
echo "<PARAM NAME=\"show_price\" VALUE=\"NO\">\n";
echo "<PARAM NAME=\"qty\" VALUE=\"1\">\n";
echo "<PARAM NAME=\"show_qty\" VALUE=\"NO\">\n";
echo "<PARAM NAME=\"classification\" VALUE=\"$row_products[Class]\">\n";
echo "<PARAM NAME=\"shipping_modifier\" VALUE=\"$0.00\">\n";
echo "<PARAM NAME=\"taxable\" VALUE=\"YES\">\n";
echo "<PARAM NAME=\"popup\" VALUE=\"YES\">\n";
echo "<PARAM NAME=\"label\" VALUE=\"Add to Cart\">\n";
echo "<PARAM NAME=\"background_color\" VALUE=\"#ffffff\">\n";
echo "<PARAM NAME=\"text_color\" VALUE=\"#000000\">\n";
echo "</applet>";
}
if ($row_products['Availability'] == "Yes" && $row_products['ProductSize'] != true )
{
echo "<applet width=\"60\" height=\"25\" code=\"uShopInput1.class\" codebase=\"classes3/\">\n";
echo "<PARAM NAME=\"id\" VALUE=\"$row_products[ProductCode]\">\n";
echo "<PARAM NAME=\"name\" VALUE=\"$row_products[ProductName]\">\n";
echo "<PARAM NAME=\"description\" VALUE=\"$row_products[ProductDescription]\">\n";
echo "<PARAM NAME=\"price\" VALUE=\"$row_products[DistPrice]\">\n";
echo "<PARAM NAME=\"classification\" VALUE=\"$row_products[Class]\">\n";
echo "<PARAM NAME=\"qty\" VALUE=\"1\">\n";
echo "<PARAM NAME=\"shipping_modifier\" VALUE=\"$0.00\">\n";
echo "<PARAM NAME=\"taxable\" VALUE=\"YES\">\n";
echo "<PARAM NAME=\"popup\" VALUE=\"YES\">\n";
echo "<PARAM NAME=\"label\" VALUE=\"Add to Cart\">\n";
echo "</applet>";
}

[kachurak]

See below:

=======================================
if ($row_products['Availability'] == "No") {
echo "Sorry, but this item is currently NOT available. Please try another item!";
}
else {

  if ($row_products['ProductSize'] != false) {
       echo "<applet width=\"200\" height=\"30\" code=\"uShopInput4.class\" codebase=\"classes3\">\n";
       echo "<PARAM NAME=\"id\" VALUE=\"$row_products[ProductCode]\">\n";
       echo "<PARAM NAME=\"name\" VALUE=\"$row_products[ProductName]\">\n";
       echo "<PARAM NAME=\"description\" VALUE=\"$row_products[ProductDescription]\">\n";
       echo "<PARAM NAME=\"option1\" VALUE=\"$row_products[ProductSize]\">\n";
       echo "<PARAM NAME=\"price\" VALUE=\"$row_products[DistPrice]\">\n";
       echo "<PARAM NAME=\"show_price\" VALUE=\"NO\">\n";
       echo "<PARAM NAME=\"qty\" VALUE=\"1\">\n";
       echo "<PARAM NAME=\"show_qty\" VALUE=\"NO\">\n";
       echo "<PARAM NAME=\"classification\" VALUE=\"$row_products[Class]\">\n";
       echo "<PARAM NAME=\"shipping_modifier\" VALUE=\"$0.00\">\n";
       echo "<PARAM NAME=\"taxable\" VALUE=\"YES\">\n";
       echo "<PARAM NAME=\"popup\" VALUE=\"YES\">\n";
       echo "<PARAM NAME=\"label\" VALUE=\"Add to Cart\">\n";
       echo "<PARAM NAME=\"background_color\" VALUE=\"#ffffff\">\n";
       echo "<PARAM NAME=\"text_color\" VALUE=\"#000000\">\n";
       echo "</applet>";
  }
  else {
       echo "<applet width=\"60\" height=\"25\"  code=\"uShopInput1.class\" codebase=\"classes3/\">\n";
       echo "<PARAM NAME=\"id\" VALUE=\"$row_products[ProductCode]\">\n";
       echo "<PARAM NAME=\"name\" VALUE=\"$row_products[ProductName]\">\n";
       echo "<PARAM NAME=\"description\" VALUE=\"$row_products[ProductDescription]\">\n";
       echo "<PARAM NAME=\"price\" VALUE=\"$row_products[DistPrice]\">\n";
       echo "<PARAM NAME=\"classification\" VALUE=\"$row_products[Class]\">\n";
       echo "<PARAM NAME=\"qty\" VALUE=\"1\">\n";
       echo "<PARAM NAME=\"shipping_modifier\" VALUE=\"$0.00\">\n";
       echo "<PARAM NAME=\"taxable\" VALUE=\"YES\">\n";
       echo "<PARAM NAME=\"popup\" VALUE=\"YES\">\n";
       echo "<PARAM NAME=\"label\" VALUE=\"Add to Cart\">\n";
       echo "</applet>";
  };

};

=======================================