For all experts - - - -

kachurak

Everyone that's helped me in the past, I thank. However, a new situation has arisen!

I have one product details page with the following issue. The product database (MySQL) has a field that has a ProductSize in it. Most products however, do NOT have a size OTHER than jewelry.

I need to be able to display two seperate applets, depending on whether or not the ProductSize field is populated. Here is what I have so far, but the problem is... No matter WHAT, the only applet ever loaded is the first!??

Any help would be appreciated!
Thanks again in advance,
Matt Kachurak

www.websystemz.com

Begin code of details.php

$colname_products = "1";
if (isset($HTTP_GET_VARS['ProductCode'])) {
$colname_products = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['ProductCode'] : addslashes($HTTP_GET_VARS['ProductCode']);
}
mysql_select_db($database_giftedunicorn, $giftedunicorn);
$query_products = sprintf("SELECT * FROM Products WHERE ProductCode = '%s' ORDER BY DistPrice DESC", $colname_products);
$products = mysql_query($query_products, $giftedunicorn) or die(mysql_error());
$row_products = mysql_fetch_assoc($products);
$totalRows_products = mysql_num_rows($products);

if ( $totalRows_products )
{
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>";
}
elseif ( $totalRows_products )
{
echo "<applet width=\"60\" height=\"25\" code=\"uShopInput1.class\" codebase=\"classes3\">\n";
echo "<PARAM NAME=\"id\" VALUE=\"$ProductCode\">\n";
echo "<PARAM NAME=\"name\" VALUE=\"$ProductName\">\n";
echo "<PARAM NAME=\"description\" VALUE=\"$ProductDescription\">\n";
echo "<PARAM NAME=\"price\" VALUE=\"$DiscountPrice\">\n";
echo "<PARAM NAME=\"classification\" VALUE=\"$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>";
}
else
{
header('Location: id2.php');

}

End code of details.php

Thanks again!
Matt

tomhath

I don't follow this logic, did you miss a "!" somewhere?

if ( $totalRows_products ) 
{ 
...
} 
elseif ( $totalRows_products ) 
{ 
...

jeremuck

Well it looks like this is what you are doing:


// Select a product. Get number of products returned.

if( $numRows != 0 )
{
  //display first applet
}
elseif ( $numRows != 0 )
{
 // display second applet
}
else
{
  //go somewhere else
}

See your problem? I think what you want is:


// Select a product. Get number of products returned.

// Test condition for first applet
if( $numRows != 0 )
{
  //display first applet

  // Test if second applet should show
  if ( $numRows != 0 )
  {
   // display second applet
  }
else
{
  //go somewhere else
}

BTW in your original code, you are only testing if the number of rows is "true", or any number other than 0 or any empy string "". Are you sure this is what you want to test for?

kachurak

The reason that this may not make much sense is that I am BRAND new to programming, so forgive my ignorance, but I am trying to learn.

As for the methods suggested, I am still having some issues when trying to obtain the query and display the results. The problem is that I cannot seem to get past the first applet and the query seems to be incorrect?!

I have tried the methods suggested here only to keep failing... maybe I'm not setting the queries correctly with the results of the recordset?

Please advise... thanks
Matt

jeremuck

ok... tell us:
How do you know if the first applet should show or not?

Also, how do you know if the second applet should show or not?

Is there any scenario where you want the second applet to show, but not the first?

Are you sure the applets are working correctly?

WHat is the query you are running?

What is the database structure like?

kachurak

First, you can see what I'm trying to do here:

Database is MySQL, there are two fields that are of concern to me. ProductCode and ProductSize. (stored in one table, just different columns)

For example... there is a ring that has one product code 12345, but has 4 different sizes. (size5,size6,size7,size8). The first applet is the one should show the additional field (productsize) IF the product size field has information in it. (currently right now, the database shows NULL for this field, other than those that SHOULD have information)

There are two applets, one that shows an additional field.

Here is the main site, so you can see what I'm talking about.

http://www.giftedunicorn.com/category.php

If you choose category, and choose there are two different types of products, ones that DON'T have a size and ones that DO have a size. JEWELRY items should load the FIRST applet because it has a size variable.

Example:

http://www.giftedunicorn.com/details.php?ProductCode=27473

The FIRST applet should load... with SIZE (in the dropdown) in the applet.

The SECOND applet should load for all other instances of the query.

Example:

http://www.giftedunicorn.com/details.php?ProductCode=32421

This should load the SECOND applet withOUT the dropdown menu selection for size. It should show just the add button.

The applets are both working correctly, I've been able to change the settings so that each one will load correctly.

The query that I would LIKE to run, would be something of the following:

SELECT * FROM Products WHERE ProductCode = (passed variable).

Then, in the if...else statements, I'd like to somehow add the ProductSize to be determined...

I've tried different methods, such as:

SELECT * FROM Products WHERE ProductCode = (passed variable) AND/OR ProductSize IS/IS NOT NULL. This apparently doesn't work as it returns strange values.

Main database = DATABASE
Table in database = Products
Columns in Products = ProductCode, ProductSize, ProductID (key)

I think that I answered all the questions that I can... I've been struggling with this for quite a while. The thing is, there was another page that I designed a while back, but the only way for me to make it work back then was to create another query and pass the variable also. I'm not quite sure if this is what I need to do this time too... I'm just recreating a whole new setup because the last one was pretty sloppy.

Also, FYI, I'm using dreamweaver MX to create the site and pages.

Thanks again Jeremuck and others who are trying, I REALLY appreciate it!

Matt

kachurak

bump... sorry, but I really need to get this resolved!

jeremuck

ok, so you have two applets to display products.

The first one is for jewelery, because it's fundamentally different from everything else due to the fact it has different sizes.

The second one if for everything else.

Now, no matter what, you always get products out of the database. Yes, you can do this with one query.

productID is your key in the database, and the product is retrieved using this.

So, no matter what the productID, (whether it points to a jewelry item or anything else) the database will only return ONE product, or record.

Now this sizes business is still kind of confusing. Anything that is not a jewelry does not have a size. So we know the first applet should show if it does have a size. But there can be more than one size. So, is it a comma delimited list or something? That's what I'm assuming. You get a list of sizes from the database. Is this what the applet expects? What does the applet expect to display the list of sizes?

Second, what do you want to happen if no record returns? For example for some reason the productID isn't found in the database. What should happen?

Ok, I'm assuming the applet wants a list of sizes, separated with a comma, and that this is what you are getting out of the database.
Second, you want the first applet to display (because it shows an option list) if it's a jewelry item. We know it's a jewelry item if it has a size list. So, if it has a size list, we want the first applet. For any other record, we want the second applet. Only one applet shows, and if there is a freak accident and there is no record returned, I'm going to give an error message.

$colname_products = "1"; 
if (isset($HTTP_GET_VARS['ProductCode'])) { 
$colname_products = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['ProductCode'] : addslashes($HTTP_GET_VARS['ProductCode']); 
} 
mysql_select_db($database_giftedunicorn, $giftedunicorn); 

// Get the product that equals the product ID
$query_products = "SELECT * FROM Products WHERE ProductCode = '" . $colname_products . "';" ; 
$products = mysql_query($query_products, $giftedunicorn) or die(mysql_error()); 
$row_products = mysql_fetch_array($products, MYSQL_ASSOC); 

$totalRows_products = mysql_num_rows($products); 

if ( $totalRows_products != 1 ) 
{ 
  exit(print "I'm dying! I'm dying!");
}
// you need to see what the value of the ProductSize is!
// you might need to play with this condition to get it right.
// Basically, if the ProductSize is there, we want to do the following code
// You may need to look up what the msyql NULL value returns to PHP
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=\"$ProductCode\">\n"; 
 echo "<PARAM NAME=\"name\" VALUE=\"$ProductName\">\n"; 
  echo "<PARAM NAME=\"description\" VALUE=\"$ProductDescription\">\n"; 
  echo "<PARAM NAME=\"price\" VALUE=\"$DiscountPrice\">\n"; 
  echo "<PARAM NAME=\"classification\" VALUE=\"$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>"; 
}