Php Syntax Help - Custom Fields Switch

[voltage]

I have some custom fields in my product info templates in my store. I want to create some switches so that if there is no data in the sql, the code disappears on the catalog side.

This is what I have. It correctly comments out the code if there is no data in the sql BUT it is not displaying the sql data if there is data.

<?php $product_info = $db->Execute("select jewel_ring_weight from " . TABLE_PRODUCTS . " where products_id = '" . (int)zen_db_prepare_input($_GET['products_id']) . "'");
if ($product_info->fields['jewel_ring_weight'] > 0) {
  echo '<br />';
  echo '<tr class="prodSpecItem2 prodS"><td class="prodSpec2">Weight - Band (g):</td><td>' . ($product_info->fields['jewel_band_weight'] ) . '</td></tr>';
}
?>

This is the code it is not displaying:

<td>' . ($product_info->fields['jewel_band_weight'] ) . '</td>

Is this the correct way to extract the data from the database? If not what am I doing wrong?

Thanks for helping a novice.

[kobra]

I am not a very adept coder but I recall that the mysql call would be "get"

[voltage]

Thanks for the reply, but that didn't work. I know I'm close, but not quite there.

[Ajeh]

$product_info is used on the product_info page for the select already ...

You really would do better to use your own variable for this and not the one running the page ...

Also, in the where statement use:

where products_id = '" . (int)$_GET['products_id'] . "'"); 

[voltage]

Thanks, Ajeh. I am close, I believe. I incorporated your feedback.

I changed $product_info to $product_band and I changed the where statement to the one you suggested.

<?php
$product_band = $db->Execute("select jewel_ring_weight from " . TABLE_PRODUCTS . " where products_id = '" . (int)$_GET['products_id'] . "'");
if ($product_band->fields['jewel_ring_weight'] > 0) {
  echo '<br />';
  echo '<tr class="prodSpecItem2 prodS"><td class="prodSpec2">Weight - Band (g):</td><td>' . ($product_band->fields['jewel_band_weight'] ) . '</td></tr>';
}
?>

But the actual sql data still isn't pulled yet and the code does not disappear if the sql data is blank.

To see whats going on see here, scroll to the bottom of the product details table below the main image. It says 'Weight - band' but the cell next to this is empty.

Thanks in advance.

[Ajeh]

Bet if you were to echo: $product_band->fields['jewel_ring_weight']

Instead of echoing: $product_band->fields['jewel_band_weight']

You'd see more ...

[voltage]

Doh! Now that is just embarrassing! Geez . . . Thanks Ajeh for lending your expertise. It appears to work now.

[voltage]

I know i am pressing my luck with all of these questions but how do I do a switch if sql data is text and not numeric? The > 0 doesn't seem to have any effect.

[voltage]

Answer change: > 0 to > ''