[SOLVED] Disable link if recordset = 0?

[A JM]

Is there a way to disable a image link on my page if the resultset from a Mysql query returns zero rows?

 

Maybe there is a better way to do this instead of testing the resultset is equal to zero, any other ideas or suggestions?

 

Thanks,

 

A JM,

[.josh]

$resultset = 0; // assumed value from db query
$img = ($resultset == 0)? "<img src='..' ... />" : "<a href='..'><img src='..' ... /></a>";

 

[A JM]

Should this be implemented in HTML like so?

 

<?php $img = ($totalRows_rst == 0)? "<img src='../images/view.png' title='VIEW INVOICE' width='32' height='32' />" : "<a href='qry_open_detail.php?recordID=<?php echo  $row_rstcue['inv_num']; ?>'><img src='../images/view.png' title='VIEW INVOICE' width='32' height='32' /></a>"; ?>

[.josh]

<?php $img = ($totalRows_rst == 0)? "<img src='../images/view.png' title='VIEW INVOICE' width='32' height='32' />" : "<a href='qry_open_detail.php?recordID={$row_rstcue['inv_num']}'><img src='../images/view.png' title='VIEW INVOICE' width='32' height='32' /></a>";?>

[A JM]

I see that I was adding <?php tags where they weren't needed... no errors on loading the page but no img either? any thoughts?

 

Thanks,

 

 

[.josh]

<?php $img = ($totalRows_rst == 0)? "<img src='../images/view.png' title='VIEW INVOICE' width='32' height='32' />" : "<a href='qry_open_detail.php?recordID={$row_rstcue['inv_num']}'><img src='../images/view.png' title='VIEW INVOICE' width='32' height='32' /></a>"; echo $img; ?>

 

oops.  Still needed the echo, just needed to move it.

[A JM]

Sweet! many thanks...

 

A JM,