Do not show if recordset is empty

Hi there,
I was hoping that my Tabbed menu would leave out an item if the recordset was empty.

eg:

<?php if ($totalRows_rsContent > 0) { // Show if recordset not empty ?>
<li><span><a href="<?php echo $row_rsContent['Standardsurl']; ?>"><?php echo $row_rsContent['TabStandards']; ?></a></span></li><?php } // Show if recordset not empty ?>

Unfortunately the left and right curved pics of the tabs shows. (see attached picture - red arrow). Is there another way I can do this so it closes up?

Thanks

Any chance of a response?

please send a copy of the menu.php page so i can see this code in context, judging by the screen shot, all i can really guess is that there is a row being returned with a blank value.


what do you get if you change:
<?php if ($totalRows_rsContent > 0) { // Show if recordset not empty ?>

to:
<?php if ($totalRows_rsContent > 0) { // Show if recordset not empty ?>Rows: <?php echo($totalRows_rsContent); ?>

Hi Jason,

Attached is the menu. Any help much appreciated!

I presume from what you suggested, I do this: (?)

<?php if ($totalRows_rsContent > 0) { // Show if recordset not empty ?>
<li><span><a href="<?php echo $row_rsContent['Standardsurl']; ?>"><?php echo $row_rsContent['TabStandards']; ?></a></span></li>
<?php echo($totalRows_rsContent); ?>

I get syntax error. Let me know if you need anything else.

the file you attached was the menu.css file. i need the menu.php file to see the php code.


No, that's not what I asked you to do.

I asked you to change:
<?php if ($totalRows_rsContent > 0) { // Show if recordset not empty ?>

to:
<?php if ($totalRows_rsContent > 0) { // Show if recordset not empty ?>Rows: <?php echo($totalRows_rsContent); ?>

and post back a screen shot of the results.

Humblest apologies Jason. Next time I will wear my glasses Here it is attached - menu.php.
I will try your code and send a snapshot separately

Hi again Jason,
Here is the menu.php file with your code added plus a snapshot of the menu with your code. I trust I have got it right this time. The red arrow points to the empty recordset

i dont think you want to be checking if the recordset is empty, i think you want to be checking if the column for the menu item is empty:

<?php if ($row_rsContent['Manualurl'] != "") {  ?>
<li><span><a href="http://www.bamr.co.za/<?php echo $row_rsContent['Manualurl']; ?>" target="_blank"><?php echo $row_rsContent['TabManual']; ?></a></span></li>
<?php }  ?>

Fantastic Jason, GREATLY appreciated!!!!