show if problem

Hey Jason

Am struggling to get a show if to work.

Basically I have this content:

<strong><?php echo $row_Event['EventTitle']; ?></strong>
                        <?php echo(str_replace(array("<p>","</p>","<blockquote>","</blockquote>","<strong>","</strong>","<em>","</em>","<u>","</u>"),"",substr(preg_replace("/<img[^>]+\>/i", " ",$row_Event['EventContent']),0,250))."..."); ?>

In the table there is a column HideEvent which is either 0 (visible) or 1 (invisible)

Once I have created the show if I have this:

<?php
  if ("".$row_Event['HideEvent']  ."" == "0") {  // WebAssist Show If
?>
                        <strong><?php echo $row_Event['EventTitle']; ?></strong>
                        <?php echo(str_replace(array("<p>","</p>","<blockquote>","</blockquote>","<strong>","</strong>","<em>","</em>","<u>","</u>"),"",substr(preg_replace("/<img[^>]+\>/i", " ",$row_Event['EventContent']),0,250))."..."); ?>
                        <?php
  } // ("".$row_Event['HideEvent']  ."" == "0")
?>

but whether I toggle the HideEvent column to 0 or 1 no content shows

Thanks

Jamie

if you echo the hide event value to the page:

<?php echo($row_Event['HideEvent']); ?>

does it show the expected 1 or 0 value?

sorry Jason.... been a dip, was using the wrong connection on the recordset:o

I have another show if issue and this time the connection is right (well pretty sure!! ;) )...

heres the show if with the content and basically it hides all content within it:

<?php do { ?>
        <?php
  if ("".$row_NewsRS['Live']  ."" == "1") {  // WebAssist Show If
?>
          <div style="clear:right;"> 
            <!-- title start //-->
            <div style="float:left;width:480px;margin:20px 0 0 0;"> <a href="newsarticle.php?ID=<?php echo $row_NewsRS['NewsID']; ?>-<?php echo(str_replace(array(" "),"_", $row_NewsRS['NewsTitle'])); ?>"> <?php echo $row_NewsRS['NewsTitle']; ?> </a> </div>
            <!-- title end //-->
            <div style="float:right;margin:20px 3px 0 0;background-color:#19172F;color:#fff;padding:5px 20px;"> <?php echo(date("d/m/Y",strtotime($row_NewsRS['NewsDate']))); ?> </div>
            <div style="clear:right;">
              <div style="float:left;margin:10px 0 0 0;min-width:500px;"> 
                <!-- description start //--> 
                <?php echo(str_replace(array("<p>","</p>","<blockquote>","</blockquote>","<strong>","</strong>","<em>","</em>","<u>","</u>"),"",substr(preg_replace("/<img[^>]+\>/i", " ",$row_NewsRS['NewsContent']),0,250))."..."); ?> 
                <!-- description end //--> 
              </div>
            </div>
          </div>
          <div style="clear:right;height:30px;"></div>
            <?php
  } // ("".$row_NewsRS['Live']  ."" == "1")
?>
<?php } while ($row_NewsRS = mysql_fetch_assoc($NewsRS)); ?>

I have tried to echo the hide event using

<?php echo($row_NewsRS['Live']); ?>

but that shows nothing as well....

if the echo shows nothing, the problem is in the recordset...

if the echo doesn't work, the show if wont work

sooooo, whats the recordset?

i think i may have this one sussed... the recordset looked as if it had a extra data in it from a previous version of the recordset.. can that happen?

yes, that can sometimes happen.

oki doki thanks Jason

basically I am using thi son news page so that the client can add a news item and 'hide' it until they are ready to 'publish' it

that works fine with the list of news articles on the news page itself, but on every page I have a 'latest news' panel which uses the most recent article from the news list

how would I stop the panel section from showing a blank space if the most recent article is 'hidden' and get it to actually show the most recent visible article?

does that make sense?

no, i'm sorry, that doesn't make sense, please provide more details

ok

if you look at this page: news.php

I have used DA to create the update, insert pages that populate the content for the news 'feed'

I have added a column to the table called 'Live' which is controlled by a checkbox.. if the checkbox is checked, this = 1 and makes the content 'Live' on the news page, if the checkbox is not checked, this = 0 and makes the content disappear

so, if the client is creating content but doesnt want it to show (sort of saving the content) they can set the content to = 0 and not show. But if it is the most recent article, the latest news panel on the left hand column shows an empty space

so am trying to see if there is a way to allow the news panel section to show the most recent VISIBLE content so that it always has content in it....