Display last record first.

Posted on 16th Feb 2014 07:03 pm by admin

I need some help how put the last record first and first record last.

Thanks

Code: <?php
include("connect.php");

$query="SELECT * FROM MyNotes ";
$result=mysql_query($query);
$num = mysql_num_rows ($result);
mysql_close();

if ($num > 0 ) {
$i=0;
while ($i < $num) {
$username = mysql_result($result,$i,"username");
$notes = mysql_result($result,$i,"notes");
$id = mysql_result($result,$i,"id");

echo "<b>notes:</b> $notes
";
echo "<hr><BR>";

++$i; } } else { echo "The database is empty"; }?>

Your Answer:

Login to answer

Other forums

using a loop help
Hi guys , i need some help. I have this loop :
while ($row = mysql_fetch_assoc($Result)) { ?&

Help to integrate whois Domain Details to website
Hi,

can i know is their any php script r methods to add domain details to my website.

square instead of number
Hello
I do not know why but this code seems to work fine only in my xampp local insallation but n

Adding delete feature to my forum
Hello I am currently trying to add a delete feature to my forum. I believe I have everything built r

problem with query error
First Thanks to those who helped me on my previous posts, and the following code i'm using is not mi

Form submissing with PHP and JQuery/Ajax
I have searched everywhere, but cannot find a solution for this... I have worked all day trying to g

sapgui f4 help last search
I know this has to be simople. One user (maybe more) does not have the "last search saved" from the

limit string by words??
hello all,

I was wonder if there is a function to limit a string by the number of words inste

PHP / MySQL Associative Multidimensional Array:
Hello.

I have data in a MySQL Table that adheres to the below: (note, no index, could add if

Spliting paragraph into sentences and attach in
Here is what I am trying to do

example: Para1[123.456.789!] 3 sentences
Para2