[RESOLVED] Display last row

Smeep

hello, I'm a php newb 😃

I'm having a little difficulty getting it to display the LAST row available I'm building my own blog you see

A friend of mine recommended this:

$number_of_records = mysql_num_rows($result);
$author = mysql_result($result,$number_of_records,"author");

But it's not having the desired effect 🙁

here's my full code


<html>
<body>


<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
Enter your alias: <input type="text" name="author" />
Enter the title: <input type="title" name="title" />
<label>Type your review:<br />
<textarea name="text" rows="10" cols="40">
</textarea></label>
<input type="submit" value="Go!"/>
</form>

<?php
$dbcnx = @mysql_connect('mysql.lcn.biz', 'myusername', 'mypass');
if (!$dbcnx) {
 echo 'Unable to connect to the ' .
     'database server at this time.' ;
 exit();
}



// Select the database
if (!@mysql_select_db('paintzone')) {
 exit('<p>Unable to locate the ' .
     'database at this time.</p>');
} 

// Write to the fields

if (isset($_POST['text'])) {
	 		$text = htmlentities($_POST['text']);
			$author = htmlentities($_POST['author']);
			$title= htmlentities($_POST['title']); 
   $sql = "INSERT INTO blog SET
       text='$text',
			 author='$author',
			 title='$title',
			 date=CURDATE()";
   if (@mysql_query($sql)) {
     echo '<p>Your review has been added.</p>';
   } else {
     echo '<p>Error adding submitted review: ' .
        mysql_error() . '</p>';
   }
 }





// Query All entries
 $result = @mysql_query('SELECT * FROM blog');
 if (!$result) {
   exit('<p>Error performing query: ' .
       mysql_error() . '</p>');
 }

  // Display all Entries
		//	$author=mysql_result($result, 0 ,"author");
			//$date=mysql_result($result, 0 ,"date");
		//	$title=mysql_result($result, 0 ,"title");
		//	$text=mysql_result($result, 0 ,"text");

//Display last entry

				$number_of_records = mysql_num_rows($result);
				$author = mysql_result($result,$number_of_records,"author");

		echo '<table><tr><td><center>' .$author .'</center></td><td><center>' .$date .'</center></td></tr><tr><td><center> ' .$title .'</center></td></tr><tr><td><center>' .$text .'</center></td></tr></table>';

?>



</body>
</html>

Roger_Ramjet

results are indexed from base zero, so the index for the first row is 0 and the index for the last row is one less than the row count.

Smeep

Yeah, I know this much, but thank you for the reply.

I did a little (I mean, VERY little) Java and C++

So, from what (very) little knoledge I have there, I gather, I somehow find out what the last row number is, - 1.

But I haven't a clue where to start :S

Also, I can not base it on the last ID, unless I can base it on the "highest" ID number - Because I will be deleting records etc, and so dropping ID's. So Unless I can figure out a dynamic way of getting the highest ID, that's out of the quesiton.

yinrunning

change

$author = mysql_result($result,$number_of_records,"author");

to:

$author = mysql_result($result,$number_of_records-1,"author");

Another way to go:

$num_rows = mysql_num_rows($result) -1;
$author = mysql_result($result, $num_rows, "author");

That way you can just keep reusing $num_rows instead of remembering to -1 every time.

Shrike

Assuming you want the entry with the most recent date, you can just use ORDER BY and LIMIT to get the last record:

SELECT columns FROM table ORDER BY date DESC LIMIT 1

yinrunning

If the primary is auto-inc, wouldn't that be the same thing?

Smeep

Yes it would, thank you for you help! I'm going to try this right away, And I'll let you know how it turns out 😃

Alright, I've gotten it working! Thank you so much for your help!

Now, on to the login script 😃

LoganK

Please, "Thread Tools" -> "Mark Thread Resolved".

Editing the original post's title to "[SOLVED]" does not update the thread's title.

Smeep

Ah, thanks, I'll do it right away, sorry about that.

LoganK

That's allright! Glad you got this resolved.