first row in database function

VooDooRT

I'm trying to write a function that gives an if statement to display a back button based on if there is another entry in the database.

Basically, if you start a record 8, and there is only records ID 7 through 12, once you get the record 7, I don't want it to show the back button anymore.

Here is the code, hopefully this can help understand..

$result = mysql_query("SELECT date, name, email, feeling, message FROM success_stories WHERE ID='$id'");
	$rowcount = mysql_query("SELECT * FROM success_stories");
    $rows = mysql_num_rows($rowcount)-1;

<? if ($id>0){ ?>
<a href="success_popup.php?id=<?=$id-1?>"><img src="pix/subnav_success_popup_back.gif" width="102" height="15" alt="back" border="0"></a>
<? }else{?>
<img src="pix/subnav_success_popup_back_b.gif" width="102" height="15" alt="" border="0">
<? } ?>

jamey

What about using the SQL function MIN() to your advantage. Something along the lines of...

$minrow = mysql_query("SELECT MIN(ID) as MinimumID FROM success_stories)";
...
<? if ($id > $MinimumID) { ?>
<a href="success_popup.php?id=<?=$id-1?>"><img src="pix/subnav_success_popup_back.gif" width="102" height="15" alt="back" border="0"></a>
...

Of course, with either this method or the one you posted, you'll need to make sure that there are no skipped records (i.e. ID = 5 doesn't exist, but the lowest is ID = 4). You would probably be better off using the SQL sort feature. Maybe something like...

$result = "SELECT ID, date, name, email, feeling, message FROM success_stories WHERE ID='$id' order by ID DESC LIMIT 0,2");

Then stick the results in an array or two variables and check for the existance of the second before making the link.

Hope that helps.